Brocade Network Advisor Documentation Updates v11.1.x (53-1002363-03, August 2011)

208 Brocade Network Advisor Documentation Updates
53-1002363-02
Views
E
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,