HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 216
VM_STATISTICS_INFO, Views, This view gets the FC port statistics for the VM Connectivity data.
![]() |
View all HP Brocade 8/12c manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 216 highlights
E Views VM_PATH.ACTIVE as PATH_ACTIVE, VM_PATH.PREFERRED as PATH_PREFERRED from VM_LUN join VM_PATH on VM_LUN.ID = VM_PATH.LUN_ID; VM_STATISTICS_INFO This view gets the FC port statistics for the VM Connectivity data. create or replace view VM_STATISTICS_INFO as select distinct DEVICE_PORT.SWITCH_PORT_WWN, DEVICE_PORT.DOMAIN_ID, VM_CONNECTIVITY.HYPERVISOR_HOST, VM_CONNECTIVITY.ADAPTER_PORT_WWN, VM_CONNECTIVITY.ADAPTER_PORT_STATUS, VM_CONNECTIVITY.HYPERVISOR_VM_ID, VM_CONNECTIVITY.VM_NAME, CORE_SWITCH.IP_ADDRESS, CORE_SWITCH.NAME as CORE_NAME, FC_PORT_STATS.TX, FC_PORT_STATS.RX, FC_PORT_STATS.TX_UTILIZATION, FC_PORT_STATS.RX_UTILIZATION, FC_PORT_STATS.SYNCLOSSES, FC_PORT_STATS.SIGNALLOSSES, FC_PORT_STATS.SEQUENCEERRORS, FC_PORT_STATS.INVALIDTRANSMISSIONS, FC_PORT_STATS.CRCERRORS, FC_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, FC_PORT_STATS, VIRTUAL_SWITCH where VM_CONNECTIVITY.ADAPTER_PORT_WWN = DEVICE_PORT.WWN and DEVICE_PORT.SWITCH_PORT_WWN = SWITCH_PORT.WWN and SWITCH_PORT.ID = FC_PORT_STATS.PORT_ID and SWITCH_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID and VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID and FC_PORT_STATS.CREATION_TIME in (select MAX(CREATION_TIME) from FC_PORT_STATS group by PORT_ID) union select DEVICE_PORT.SWITCH_PORT_WWN, DEVICE_PORT.DOMAIN_ID, VM_CONNECTIVITY.HYPERVISOR_HOST, VM_CONNECTIVITY.ADAPTER_PORT_WWN, VM_CONNECTIVITY.ADAPTER_PORT_STATUS, VM_CONNECTIVITY.HYPERVISOR_VM_ID, VM_CONNECTIVITY.VM_NAME, CORE_SWITCH.IP_ADDRESS, 208 Brocade Network Advisor Documentation Updates 53-1002363-02
![](/manual_guide/products/hewlettpackard-brocade-812c-brocade-network-advisor-documentation-updates-v111x-53100236303-2011-4c13200/216.png)