Brocade Network Advisor IP User Manual v12.3.0 - Manual (Page 1850)

1798 Brocade Network Advisor IP User Manual
53-1003153-01
Views
I
SOURCE_SWITCH_PORT.STATE AS SOURCE_SWITCH_PORT_STATE,
SOURCE_SWITCH_PORT.HEALTH AS SOURCE_SWITCH_PORT_HEALTH,
SOURCE_SWITCH_PORT.STATUS_MESSAGE AS SOURCE_SWITCH_PORT_STATUS_MESSAGE,
SOURCE_SWITCH_PORT.CATEGORY AS SOURCE_SWITCH_PORT_CATEGORY,
SOURCE_SWITCH_PORT.LICENSED AS SOURCE_SWITCH_PORT_LICENSED,
SOURCE_SWITCH_PORT.TYPE AS SOURCE_SWITCH_PORT_TYPE,
SOURCE_SWITCH_PORT.KIND AS SOURCE_SWITCH_PORT_KIND,
SOURCE_SWITCH_PORT.PHYSICAL_PORT AS SOURCE_PHYSICAL_PORT,
SOURCE_SWITCH_PORT.TRUNKED AS SOURCE_SWITCH_PORT_TRUNKED,
SOURCE_SWITCH_PORT.TRUNK_MASTER AS SOURCE_SWITCH_PORT_TRUNK_MASTER,
SOURCE_SWITCH_PORT.MASTER_PORT_NUMBER AS
SOURCE_SWITCH_PORT_MASTER_PORT_NUMBER,
SOURCE_SWITCH_PORT.SPEED as SOURCE_SWITCH_PORT_SPEED,
ISL.DEST_DOMAIN_ID, ISL.DEST_PORT_NUMBER,
DEST_VIRTUAL_SWITCH.ID AS DEST_SWITCH_ID,
DEST_VIRTUAL_SWITCH.NAME AS DEST_SWITCH_NAME,
DEST_VIRTUAL_SWITCH.WWN AS DEST_SWITCH_WWN,
DEST_VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID AS DEST_SWITCH_VIRTUAL_FABRIC_ID,
DEST_VIRTUAL_SWITCH.OPERATIONAL_STATUS AS DEST_SWITCH_OPERATIONAL_STATUS,
DEST_VIRTUAL_SWITCH.STATE AS DEST_SWITCH_STATE,
DEST_VIRTUAL_SWITCH.STATUS AS DEST_SWITCH_STATUS,
DEST_VIRTUAL_SWITCH.STATUS_REASON AS DEST_SWITCH_STATUS_REASON,
DEST_VIRTUAL_SWITCH.CORE_SWITCH_ID AS DEST_CORE_SWITCH_ID,
DEST_VIRTUAL_SWITCH.BASE_SWITCH AS DEST_BASE_SWITCH,
DEST_VIRTUAL_SWITCH.MANAGEMENT_STATE AS DEST_VIRTUAL_SWITCH_MANAGEMENT_STATE,
DEST_VIRTUAL_SWITCH.MONITORED AS DEST_VIRTUAL_SWITCH_MONITORED,
DEST_CORE_SWITCH.IP_ADDRESS AS DEST_CORE_SWITCH_IP_ADDRESS,
DEST_CORE_SWITCH.WWN AS DEST_CORE_SWITCH_WWN,
DEST_CORE_SWITCH.NAME AS DEST_CORE_SWITCH_NAME,
DEST_CORE_SWITCH.TYPE AS DEST_CORE_SWITCH_TYPE,
DEST_CORE_SWITCH.OPERATIONAL_STATUS AS DEST_CORE_SWITCH_OPERATIONAL_STATUS,
DEST_CORE_SWITCH.MODEL AS DEST_CORE_SWITCH_MODEL,
DEST_CORE_SWITCH.VENDOR AS DEST_CORE_SWITCH_VENDOR,
DEST_CORE_SWITCH.REACHABLE AS DEST_CORE_SWITCH_REACHABLE,
DEST_SWITCH_PORT.ID AS DEST_SWITCH_PORT_ID,
DEST_SWITCH_PORT.WWN AS DEST_SWITCH_PORT_WWN,
DEST_SWITCH_PORT.NAME AS DEST_SWITCH_PORT_NAME,
DEST_SWITCH_PORT.SLOT_NUMBER AS DEST_SWITCH_PORT_SLOT_NUMBER,
DEST_SWITCH_PORT.PORT_NUMBER AS DEST_SWITCH_PORT_PORT_NUMBER,
DEST_SWITCH_PORT.PORT_ID AS DEST_SWITCH_PORT_PORT_ID,
DEST_SWITCH_PORT.PORT_INDEX AS DEST_SWITCH_PORT_PORT_INDEX,
DEST_SWITCH_PORT.AREA_ID AS DEST_SWITCH_PORT_AREA_ID,
DEST_SWITCH_PORT.MAC_ADDRESS AS DEST_SWITCH_PORT_MAC_ADDRESS,
DEST_SWITCH_PORT.STATUS AS DEST_SWITCH_PORT_STATUS,
DEST_SWITCH_PORT.STATE AS DEST_SWITCH_PORT_STATE,
DEST_SWITCH_PORT.HEALTH AS DEST_SWITCH_PORT_HEALTH,
DEST_SWITCH_PORT.STATUS_MESSAGE AS DEST_SWITCH_PORT_STATUS_MESSAGE,
DEST_SWITCH_PORT.CATEGORY AS DEST_SWITCH_PORT_CATEGORY,
DEST_SWITCH_PORT.LICENSED AS DEST_SWITCH_PORT_LICENSED,
DEST_SWITCH_PORT.TYPE AS DEST_SWITCH_PORT_TYPE,
DEST_SWITCH_PORT.KIND AS DEST_SWITCH_PORT_KIND,
DEST_SWITCH_PORT.PHYSICAL_PORT AS DEST_PHYSICAL_PORT,
DEST_SWITCH_PORT.TRUNKED AS DEST_SWITCH_PORT_TRUNKED,
DEST_SWITCH_PORT.TRUNK_MASTER AS DEST_SWITCH_PORT_TRUNK_MASTER,
DEST_SWITCH_PORT.MASTER_PORT_NUMBER AS DEST_SWITCH_PORT_MASTER_PORT_NUMBER,
DEST_SWITCH_PORT.SPEED as DEST_SWITCH_PORT_SPEED,
CASE WHEN SOURCE_SWITCH_PORT.TRUNK_MASTER = 1 AND DEST_SWITCH_PORT.TRUNK_MASTER =
1 THEN 'TRUNK' ELSE 'ISL' END AS CONNECTION_TYPE,
FABRIC.SEED_SWITCH_WWN AS FABRIC_SEED_SWITCH_WWN, FABRIC.NAME AS FABRIC_NAME,
FABRIC.FABRIC_NAME AS FABRIC_FABRIC_NAME,