Brocade Network Advisor SAN + IP User Manual v12.3.0 - Manual (Page 2639)

Brocade Network Advisor SAN + IP User Manual 2567
53-1003155-01
Views
I
DEVICE_NODE.AG as DEVICE_NODE_IS_AG,
DEVICE_NODE.SIMULATED as DEVICE_NODE_SIMULATED,
DEVICE_NODE.FABRIC_ID as DEVICE_NODE_FABRIC_ID
from DEVICE_PORT
join DEVICE_NODE on DEVICE_PORT.NODE_ID = DEVICE_NODE.ID
)
select FABRIC_MEMBER.FABRIC_ID,
FABRIC.SEED_SWITCH_WWN as FABRIC_SEED_SWITCH_WWN,
FABRIC.NAME as FABRIC_NAME,
FABRIC.MANAGEMENT_STATE as FABRIC_MANAGEMENT_STATE,
FABRIC.PRINCIPAL_SWITCH_WWN as FABRIC_PRINCIPAL_SWITCH_WWN,
FABRIC.FABRIC_NAME as FABRIC_SWITCH_PERSIST_FABRIC_NAME,
FABRIC.STATUS as FABRIC_STATUS,
FABRIC.BOTTLENECK_STATUS as FABRIC_BOTTLENECK_STATUS,
CORE_SWITCH.ID as CORE_SWITCH_ID,
CORE_SWITCH.IP_ADDRESS as CORE_SWITCH_IP_ADDRESS,
CORE_SWITCH.WWN as CORE_SWITCH_WWN, CORE_SWITCH.NAME as CORE_SWITCH_NAME,
CORE_SWITCH.TYPE as CORE_SWITCH_TYPE,
CORE_SWITCH.MODEL as CORE_SWITCH_MODEL,
CORE_SWITCH.VENDOR as CORE_SWITCH_VENDOR,
CORE_SWITCH.REACHABLE as CORE_SWITCH_REACHABLE,
CORE_SWITCH.OPERATIONAL_STATUS as CORE_SWITCH_OPERATIONAL_STATUS,
VIRTUAL_SWITCH.NAME as SWITCH_NAME, VIRTUAL_SWITCH.SWITCH_MODE,
VIRTUAL_SWITCH.DOMAIN_ID, VIRTUAL_SWITCH.WWN as VIRTUAL_SWITCH_WWN,
VIRTUAL_SWITCH.OPERATIONAL_STATUS as SWITCH_OPERATIONAL_STATUS,
VIRTUAL_SWITCH.MANAGEMENT_STATE as SWITCH_MANAGEMENT_STATE,
VIRTUAL_SWITCH.STATE as SWITCH_STATE,
VIRTUAL_SWITCH.STATUS as SWITCH_STATUS,
VIRTUAL_SWITCH.STATUS_REASON as SWITCH_STATUS_REASON,
SWITCH_PORT.ID as SWITCH_PORT_ID, SWITCH_PORT.VIRTUAL_SWITCH_ID,
SWITCH_PORT.SLOT_NUMBER, SWITCH_PORT.PORT_NUMBER,
SWITCH_PORT.USER_PORT_NUMBER, SWITCH_PORT.NAME as PORT_NAME,
SWITCH_PORT.SPEED as PORT_SPEED, SWITCH_PORT.STATUS as PORT_STATUS,
SWITCH_PORT.STATE as PORT_STATE, SWITCH_PORT.TYPE as PORT_TYPE,
SWITCH_PORT.SPEEDS_SUPPORTED,
SWITCH_PORT.PHYSICAL_PORT as PHYSICAL_OR_LOGICAL_PORT,
SWITCH_PORT.PORT_INDEX as ZONING_PORT_INDEX, SWITCH_PORT.OCCUPIED,
SWITCH_PORT.REMOTE_NODE_WWN as SWITCH_PORT_REMOTE_NODE_WWN,
SWITCH_PORT.PORT_ID, SWITCH_PORT.WWN as SWITCH_PORT_WWN,
SWITCH_PORT.AREA_ID, SWITCH_PORT.MAC_ADDRESS, SWITCH_PORT.PORT_MOD,
SWITCH_PORT.FULL_TYPE, SWITCH_PORT.HEALTH,
SWITCH_PORT.STATUS_MESSAGE as SWITCH_PORT_STATUS_MESSAGE,
SWITCH_PORT.MAX_PORT_SPEED, SWITCH_PORT.REMOTE_PORT_WWN,
SWITCH_PORT.LICENSED, SWITCH_PORT.TRUNKED, SWITCH_PORT.TRUNK_MASTER,
SWITCH_PORT.FICON_SUPPORTED, SWITCH_PORT.BLOCKED, SWITCH_PORT.NPIV,
SWITCH_PORT.NPIV_CAPABLE, SWITCH_PORT.NPIV_ENABLED, SWITCH_PORT.QOS_CAPABLE,
SWITCH_PORT.QOS_ENABLED, SWITCH_PORT.TUNNEL_CONFIGURED,
SWITCH_PORT.FCR_FABRIC_ID, SWITCH_PORT.FCR_INTEROP_MODE,
SWITCH_PORT.USER_DEFINED_VALUE1, SWITCH_PORT.USER_DEFINED_VALUE2,
SWITCH_PORT.USER_DEFINED_VALUE3, SWITCH_PORT.KIND, SWITCH_PORT.LAST_UPDATE,
DEVPORT_DEVNODE_VIEW.DEVICE_PORT_TYPE, DEVPORT_DEVNODE_VIEW.DEVICE_PORT_WWN,
DEVPORT_DEVNODE_VIEW.NPV_PHYSICAL,
DEVPORT_DEVNODE_VIEW.DEVICE_PORT_EDGE_SWITCH_PORT_WWN,
DEVPORT_DEVNODE_VIEW.DEVICE_PORT_LOGGED_TO_AG,
DEVPORT_DEVNODE_VIEW.DEVICE_PORT_AG_NODE_WWN,
DEVPORT_DEVNODE_VIEW.DEVICE_PORT_AG_N_PORT_WWN,
DEVPORT_DEVNODE_VIEW.DEVICE_PORT_NAME, DEVPORT_DEVNODE_VIEW.DEVICE_PORT_ID,
DEVPORT_DEVNODE_VIEW.DEVICE_PORT_PORT_ID,
DEVPORT_DEVNODE_VIEW.DEVICE_PORT_SWITCH_PORT_WWN,
DEVPORT_DEVNODE_VIEW.DEVICE_PORT_FC4_TYPE,