HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 180
Core_switch_details_info, Left Outer Join Cna_eth_port On Cna_port.id = Cna_eth_port.cna_port_id
![]() |
View all HP Brocade 8/12c manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 180 highlights
E Views select CNA_PORT.ID, CNA_PORT.PORT_NUMBER, CNA_PORT.PORT_WWN, CNA_PORT.NODE_WWN, CNA_PORT.PHYSICAL_PORT_TYPE, CNA_PORT.NAME, CNA_PORT.MAC_ADDRESS, CNA_PORT.MEDIA, CNA_PORT.CEE_STATE, CNA_PORT.HBA_ID, CNA_PORT.CREATION_TIME as CNA_PORT_CREATION_TIME, CNA_ETH_PORT.ID as ETH_PORT_ID, CNA_ETH_PORT.ETH_DEV, CNA_ETH_PORT.ETH_LOG_LEVEL, CNA_ETH_PORT.NAME as ETH_PORT_NAME, CNA_ETH_PORT.MAC_ADDRESS as ETH_MAC_ADDRESS, CNA_ETH_PORT.IOC_ID, CNA_ETH_PORT.HARDWARE_PATH, CNA_ETH_PORT.STATUS, CNA_ETH_PORT.CREATION_TIME as ETH_PORT_CREATION_TIME, HBA_PORT.DEVICE_PORT_ID from CNA_PORT left outer join HBA_PORT on CNA_PORT.ID = HBA_PORT.CNA_PORT_ID left outer join CNA_ETH_PORT on CNA_PORT.ID = CNA_ETH_PORT.CNA_PORT_ID; CORE_SWITCH_DETAILS_INFO create or replace view CORE_SWITCH_DETAILS_INFO as select CORE_SWITCH.ID, CORE_SWITCH.IP_ADDRESS, CORE_SWITCH.WWN, CORE_SWITCH.NAME, CORE_SWITCH.TYPE, CORE_SWITCH.MODEL, CORE_SWITCH.FIRMWARE_VERSION, CORE_SWITCH.VENDOR, CORE_SWITCH.MAX_VIRTUAL_SWITCHES, CORE_SWITCH.NUM_VIRTUAL_SWITCHES, CORE_SWITCH.REACHABLE, CORE_SWITCH.UNREACHABLE_TIME, CORE_SWITCH.OPERATIONAL_STATUS, CORE_SWITCH.CREATION_TIME, CORE_SWITCH.LAST_SCAN_TIME, CORE_SWITCH.LAST_UPDATE_TIME, CORE_SWITCH.SYSLOG_REGISTERED, CORE_SWITCH.CALL_HOME_ENABLED, CORE_SWITCH.SNMP_REGISTERED, CORE_SWITCH.USER_IP_ADDRESS, CORE_SWITCH.NIC_PROFILE_ID, CORE_SWITCH.MANAGING_SERVER_IP_ADDRESS, CORE_SWITCH.VF_ENABLED, CORE_SWITCH.VF_SUPPORTED, CORE_SWITCH.MANAGED_ELEMENT_ID as CORE_MANAGED_ELEMENT_ID, CORE_SWITCH_DETAILS.ETHERNET_MASK, CORE_SWITCH_DETAILS.FC_MASK, CORE_SWITCH_DETAILS.FC_IP, 172 Brocade Network Advisor Documentation Updates 53-1002363-02
![](/manual_guide/products/hewlettpackard-brocade-812c-brocade-network-advisor-documentation-updates-v111x-53100236303-2011-4c13200/180.png)