HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 217
Zone_db_info, And Gige_port.switch_port_id = Switch_te_port_stats.port_id
![]() |
View all HP Brocade 8/12c manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 217 highlights
Views E CORE_SWITCH.NAME as CORE_NAME, SWITCH_TE_PORT_STATS.TRANSMIT_OK, SWITCH_TE_PORT_STATS.RECEIVE_OK, SWITCH_TE_PORT_STATS.TRANSMIT_OK_PERCENT_UTIL, SWITCH_TE_PORT_STATS.RECEIVE_OK_PERCENT_UTIL, -1,-1,-1,-1,-1, SWITCH_TE_PORT_STATS.CREATION_TIME, VIRTUAL_SWITCH.NAME as VIRTUAL_NAME, SWITCH_PORT.STATUS as SWITCH_PORT_STATUS, SWITCH_PORT.PORT_ID, SWITCH_PORT.PORT_NUMBER from DEVICE_PORT, VM_CONNECTIVITY, SWITCH_PORT, CORE_SWITCH, SWITCH_TE_PORT_STATS, VIRTUAL_SWITCH, DEVICE_PORT_MAC_ADDRESS_MAP, DEVICE_PORT_GIGE_PORT_LINK, GIGE_PORT where VM_CONNECTIVITY.ADAPTER_PORT_WWN = DEVICE_PORT.WWN and DEVICE_PORT.ID = DEVICE_PORT_MAC_ADDRESS_MAP.DEVICE_PORT_ID and DEVICE_PORT_MAC_ADDRESS_MAP.MAC_ADDRESS = GIGE_PORT.REMOTE_MAC_ADDRESS and GIGE_PORT.SWITCH_PORT_ID = SWITCH_TE_PORT_STATS.PORT_ID and GIGE_PORT.SWITCH_PORT_ID = SWITCH_PORT.ID and SWITCH_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID and VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID and SWITCH_TE_PORT_STATS.CREATION_TIME in (select max(CREATION_TIME) from SWITCH_TE_PORT_STATS group by PORT_ID); ZONE_DB_INFO create or replace view ZONE_DB_INFO as select ZONE_DB.ID, ZONE_DB.FABRIC_ID, ZONE_DB.OFFLINE, ZONE_DB.NAME, ZONE_DB.CREATED, ZONE_DB.CREATED_BY, ZONE_DB.LAST_MODIFIED, ZONE_DB.LAST_MODIFIED_BY, ZONE_DB.LAST_APPLIED, ZONE_DB.LAST_APPLIED_BY, ZONE_DB.DEFAULT_ZONE_STATUS, ZONE_DB.MCDATA_DEFAULT_ZONE, ZONE_DB.MCDATA_SAFE_ZONE, ZONE_DB.ZONE_TXN_SUPPORTED, ZONE_DB.ZONE_CONFIG_SIZE, ZONE_DB.ZONE_AVAILABLE_SIZE, ZONE_DB_CONFIG.ID AS CONFIG_ID, ZONE_DB_CONFIG.DEFINED_CONTENT, ZONE_DB_CONFIG.ACTIVE_CONTENT, ZONE_DB_CONFIG.TI_ZONE_CONTENT from ZONE_DB, ZONE_DB_CONFIG where Brocade Network Advisor Documentation Updates 209 53-1002363-02
![](/manual_guide/products/hewlettpackard-brocade-812c-brocade-network-advisor-documentation-updates-v111x-53100236303-2011-4c13200/217.png)