HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 185

SWITCH_PORT.ID as SWITCH_PORT_ID, SWITCH_PORT.WWN as SWITCH_PORT_WWN, SWITCH_PORT.NAME as SWITCH_PORT_NAME, SWITCH_PORT.SLOT_NUMBER, SWITCH_PORT.PORT_NUMBER, SWITCH_PORT.PORT_INDEX, SWITCH_PORT.TYPE as SWITCH_PORT_TYPE, SWITCH_PORT.FULL_TYPE as SWITCH_PORT_FULL_TYPE, SWITCH_PORT.STATUS as SWITCH_PORT_STATUS, SWITCH_PORT.HEALTH as SWITCH_PORT_HEALTH, SWITCH_PORT.SPEED, SWITCH_PORT.MAX_PORT_SPEED, SWITCH_PORT.NPIV, SWITCH_PORT.NPIV_CAPABLE, SWITCH_PORT.CALCULATED_STATUS, SWITCH_PORT.AREA_ID, SWITCH_PORT.PHYSICAL_PORT, SWITCH_PORT.CATEGORY, SWITCH_PORT.PERSISTENT_DISABLE, SWITCH_PORT.BLOCKED, SWITCH_PORT.FCR_INTEROP_MODE, SWITCH_INFO.IP_ADDRESS, SWITCH_INFO.PHYSICAL_SWITCH_WWN, SWITCH_INFO.FIRMWARE_VERSION, SWITCH_INFO.REACHABLE, SWITCH_INFO.SYSLOG_REGISTERED, SWITCH_INFO.SNMP_REGISTERED, SWITCH_INFO.ID as VIRTUAL_SWITCH_ID, SWITCH_INFO.NAME as VIRTUAL_SWITCH_NAME, SWITCH_INFO.OPERATIONAL_STATUS, SWITCH_INFO.SWITCH_MODE, SWITCH_INFO.WWN as VIRTUAL_SWITCH_WWN, SWITCH_INFO.DOMAIN_ID as VIRTUAL_SWITCH_DOMAIN_ID, SWITCH_INFO.VIRTUAL_FABRIC_ID, SWITCH_INFO.BASE_SWITCH, SWITCH_INFO.STATE as VIRTUAL_SWITCH_STATE, SWITCH_INFO.STATUS as VIRTUAL_SWITCH_STATUS, SWITCH_INFO.FABRIC_ID, SWITCH_INFO.CRYPTO_CAPABLE from DEVICE_NODE, DEVICE_PORT, SWITCH_PORT, SWITCH_INFO where DEVICE_PORT.NODE_ID = DEVICE_NODE.ID and DEVICE_PORT.SWITCH_PORT_WWN = SWITCH_PORT.WWN and SWITCH_PORT.VIRTUAL_SWITCH_ID = SWITCH_INFO.ID and DEVICE_NODE.FABRIC_ID = SWITCH_INFO.FABRIC_ID; N2F_PORT_MAP_INFO create or replace view N2F_PORT_MAP_INFO as select N2F_PORT_MAP.VIRTUAL_SWITCH_ID, N2F_PORT_MAP.N_PORT, N2F_PORT_MAP.F_PORT, AG_N_PORT.REMOTE_PORT_WWN as EDGE_SWITCH_PORT_WWN, AG_F_PORT.WWN as AG_F_PORT_WWN, AG_F_PORT.REMOTE_NODE_WWN, AG_F_PORT.REMOTE_PORT_WWN as DEVICE_PORT_WWN from Brocade Network Advisor Documentation Updates 53-1002363-02 Views E 177