Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1863)

Brocade Network Advisor SAN User Manual 1811
53-1003154-01
Views
H
AG_F_PORT.QOS_ENABLED as AG_F_PORT_QOS_ENABLED,
AG_F_PORT.TUNNEL_CONFIGURED as AG_F_PORT_TUNNEL_CONFIGURED,
AG_F_PORT.FCR_FABRIC_ID as AG_F_PORT_FCR_FABRIC_ID,
AG_F_PORT.FCR_INTEROP_MODE as AG_F_PORT_FCR_INTEROP_MODE,
AG_F_PORT.USER_DEFINED_VALUE1 as AG_F_PORT_USER_DEFINED_VALUE1,
AG_F_PORT.USER_DEFINED_VALUE2 as AG_F_PORT_USER_DEFINED_VALUE2,
AG_F_PORT.USER_DEFINED_VALUE3 as AG_F_PORT_USER_DEFINED_VALUE3,
AG_F_PORT.KIND as AG_F_PORT_KIND,
AG_F_PORT.LAST_UPDATE as AG_F_PORT_LAST_UPDATE,
AG_SWITCH.WWN as AG_SWITCH_VIRTUAL_SWITCH_WWN,
AG_SWITCH.NAME as AG_SWITCH_SWITCH_NAME,
AG_SWITCH.DOMAIN_ID as AG_SWITCH_SWITCH_DOMAIN_ID,
AG_SWITCH.SWITCH_MODE as AG_SWITCH_SWITCH_MODE,
AG_SWITCH.OPERATIONAL_STATUS as AG_SWITCH_SWITCH_OPERATIONAL_STATUS,
AG_SWITCH.MANAGEMENT_STATE as AG_SWITCH_SWITCH_MANAGEMENT_STATE,
AG_SWITCH.STATE as AG_SWITCH_SWITCH_STATE,
AG_SWITCH.STATUS as AG_SWITCH_SWITCH_STATUS,
AG_SWITCH.STATUS_REASON as AG_SWITCH_SWITCH_STATUS_REASON,
AG_PHYSICAL_SWITCH.IP_ADDRESS as AG_PHYSICAL_SWITCH_IP_ADDRESS,
AG_PHYSICAL_SWITCH.ID as AG_PHYSICAL_SWITCH_ID,
AG_PHYSICAL_SWITCH.WWN as AG_PHYSICAL_SWITCH_WWN,
AG_PHYSICAL_SWITCH.NAME as AG_PHYSICAL_SWITCH_NAME,
AG_PHYSICAL_SWITCH.TYPE as AG_PHYSICAL_SWITCH_TYPE,
AG_PHYSICAL_SWITCH.MODEL as AG_PHYSICAL_SWITCH_MODEL,
AG_PHYSICAL_SWITCH.VENDOR as AG_PHYSICAL_SWITCH_VENDOR,
AG_PHYSICAL_SWITCH.REACHABLE as AG_PHYSICAL_SWITCH_REACHABLE,
AG_PHYSICAL_SWITCH.OPERATIONAL_STATUS as AG_PHYSICAL_SWITCH_OPERATIONAL_STATUS,
AG_PHYSICAL_SWITCH_DETAILS.MODEL_NUMBER as AG_PHYSICAL_SWITCH_MODEL_NUMBER,
END_DEVICE_NODE.FABRIC_ID,
END_DEVICE_NODE.SYMBOLIC_NAME as DEVICE_NODE_SYMBOLIC_NAME,
END_DEVICE_NODE.FDMI_HOST_NAME,
END_DEVICE_NODE.VENDOR,
END_DEVICE_NODE.CAPABILITY_,
END_DEVICE_NODE.TRUSTED as DEVICE_NODE_TRUSTED,
END_DEVICE_NODE.CREATION_TIME as DEVICE_NODE_CREATION_TIME,
END_DEVICE_NODE.MISSING as DEVICE_NODE_MISSING,
END_DEVICE_NODE.MISSING_TIME as DEVICE_NODE_MISSING_TIME,
END_DEVICE_NODE.PROXY_DEVICE,
END_DEVICE_NODE.AG,
END_DEVICE_NODE.PREVIOUS_MISSING_STATE,
END_DEVICE_NODE.SIMULATED,
coalesce(USER_DEFINED_DEVICE_DETAIL.TYPE, END_DEVICE_NODE.TYPE, ''::character
varying) as USER_DEFINED_DEVICE_TYPE,
USER_DEFINED_DEVICE_DETAIL.NAME as USER_DEFINED_NAME,
USER_DEFINED_DEVICE_DETAIL.IP_ADDRESS as USER_DEFINED_IP_ADDRESS,
USER_DEFINED_DEVICE_DETAIL.CONTACT,
USER_DEFINED_DEVICE_DETAIL.LOCATION,
USER_DEFINED_DEVICE_DETAIL.DESCRIPTION,
AG_F_PORT.REMOTE_PORT_WWN as DEVICE_PORT_WWN,
AG_F_PORT.REMOTE_NODE_WWN as DEVICE_NODE_WWN,
END_DEVICE_PORT.PORT_ID as DEVICE_PORT_FC_ADDRESS,
END_DEVICE_PORT.NUMBER as DEVICE_PORT_NUMBER,
END_DEVICE_PORT.ID as DEVICE_PORT_ID,
END_DEVICE_PORT.DOMAIN_ID,
END_DEVICE_PORT.TYPE as DEVICE_PORT_TYPE,
END_DEVICE_PORT.SYMBOLIC_NAME as DEVICE_PORT_SYMBOLIC_NAME,
END_DEVICE_PORT.FC4_TYPE,
END_DEVICE_PORT.COS,
END_DEVICE_PORT.IP_PORT,
END_DEVICE_PORT.NPV_PHYSICAL,