Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2348)

Brocade Network Advisor SAN + IP User Manual 2311
53-1002949-01
Views
I
VM_PATH.TARGET_PORT,
VM_PATH.HBA_NODE,
VM_PATH.VM_NODE_WWN,
VM_PATH.TARGET_NODE as PATH_TARGET_NODE,
VM_PATH.HBA_NAME,
VM_PATH.USAGE as PATH_USAGE,
VM_PATH.ENABLED as PATH_ENABLED,
VM_PATH.ACTIVE as PATH_ACTIVE,
VM_PATH.PREFERRED as PATH_PREFERRED
from
VM_STORAGE join VM_PATH on VM_STORAGE.ID = VM_PATH.STORAGE_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,
DEVICE_ENCLOSURE.IP_ADDRESS as HYPERVISOR_HOST,
VM_PATH.HBA_PORT as ADAPTER_PORT_WWN,
VM_VIRTUAL_MACHINE.HYPERVISOR_VM_ID,
VM_VIRTUAL_MACHINE.NAME as 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
VM_STORAGE,
VM_HOST,
DEVICE_ENCLOSURE,
VM_VIRTUAL_MACHINE,
VM_PATH,
DEVICE_PORT,
SWITCH_PORT,
CORE_SWITCH,
FC_PORT_STATS,
VIRTUAL_SWITCH
where
VM_PATH.HBA_PORT::BPCHAR = DEVICE_PORT.WWN
and VM_PATH.VM_ID = VM_VIRTUAL_MACHINE.ID
and VM_PATH.STORAGE_ID = VM_STORAGE.ID
and VM_STORAGE.HOST_ID = DEVICE_ENCLOSURE.ID
and DEVICE_ENCLOSURE.ID = VM_HOST.DEVICE_ENCLOSURE_ID
and DEVICE_ENCLOSURE.ID = VM_VIRTUAL_MACHINE.HOST_ID
and DEVICE_PORT.SWITCH_PORT_WWN = SWITCH_PORT.WWN