HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 201
NPORT_WWN_MAP_INFO, some F-Port that is mapped to some other N-Port that is online
View all HP Brocade 8/12c manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 201 highlights
Views E ISL_INFO.TYPE, ISL_INFO.SOURCE_PORT_NUMBER, ISL_INFO.SOURCE_SWITCH_ID, SOURCE_CORE_SWITCH.IP_ADDRESS as SOURCE_SWITCH_IP_ADDRESS, SOURCE_VIRTUAL_SWITCH.WWN as SOURCE_SWITCH_WWN, ISL_INFO.SOURCE_DOMAIN_ID as MASTER_PORT, ISL_INFO.SOURCE_SWITCH_NAME, ISL_INFO.SOURCE_SWITCH_PORT_ID, ISL_INFO.DEST_PORT_NUMBER, ISL_INFO.DEST_SWITCH_ID, DEST_CORE_SWITCH.IP_ADDRESS as DEST_SWITCH_IP_ADDRESS, DEST_VIRTUAL_SWITCH.WWN as DEST_SWITCH_WWN, ISL_INFO.SOURCE_SWITCH_PORT_WWN, ISL_INFO.DEST_DOMAIN_ID as REMOTE_MASTER_PORT, ISL_INFO.DEST_SWITCH_NAME, ISL_INFO.DEST_SWITCH_PORT_ID from ISL_TRUNK_GROUP, ISL_INFO, CORE_SWITCH SOURCE_CORE_SWITCH, CORE_SWITCH DEST_CORE_SWITCH, VIRTUAL_SWITCH SOURCE_VIRTUAL_SWITCH, VIRTUAL_SWITCH DEST_VIRTUAL_SWITCH where ISL_INFO.SOURCE_SWITCH_ID = ISL_TRUNK_GROUP.VIRTUAL_SWITCH_ID and ISL_INFO.SOURCE_PORT_NUMBER = ISL_TRUNK_GROUP.MASTER_USER_PORT and ISL_INFO.SOURCE_SWITCH_ID = SOURCE_VIRTUAL_SWITCH.ID and SOURCE_VIRTUAL_SWITCH.CORE_SWITCH_ID = SOURCE_CORE_SWITCH.ID and ISL_INFO.DEST_SWITCH_ID = DEST_VIRTUAL_SWITCH.ID and DEST_VIRTUAL_SWITCH.CORE_SWITCH_ID = DEST_CORE_SWITCH.ID; NPORT_WWN_MAP_INFO This view provides a consolidation between Nport WWN map and AG''s N and F ports. It considers only those N-Ports that are currently occupied i.e. having non-empty remote port wwn. This is required because NPort-WWN mapping might exist for NPorts that are not yet online and if a device is connected to AG through some F-Port that is mapped to some other N-Port that is online then AG will use that mapping. create or replace view NPORT_WWN_MAP_INFO as select NPORT_WWN_MAP.VIRTUAL_SWITCH_ID, NPORT_WWN_MAP.N_PORT, NPORT_WWN_MAP.DEVICE_PORT_WWN, AG_N_PORT.REMOTE_PORT_WWN as EDGE_SWITCH_PORT_WWN, AG_F_PORT.USER_PORT_NUMBER as F_PORT, AG_F_PORT.WWN as AG_F_PORT_WWN, AG_F_PORT.REMOTE_NODE_WWN from NPORT_WWN_MAP, SWITCH_PORT AG_N_PORT, SWITCH_PORT AG_F_PORT where NPORT_WWN_MAP.VIRTUAL_SWITCH_ID = AG_N_PORT.VIRTUAL_SWITCH_ID and NPORT_WWN_MAP.N_PORT = AG_N_PORT.USER_PORT_NUMBER and NPORT_WWN_MAP.VIRTUAL_SWITCH_ID = AG_F_PORT.VIRTUAL_SWITCH_ID and NPORT_WWN_MAP.DEVICE_PORT_WWN = AG_F_PORT.REMOTE_PORT_WWN; Brocade Network Advisor Documentation Updates 193 53-1002363-02