Brocade Communications Systems IP250 user manual Vmstatisticsinfo

Views I

VM_STORAGE.ID	as LUN_ID,
VM_STORAGE.NAME	as LUN_NAME,
VM_STORAGE.TARGET_NODE,
VM_STORAGE.VENDOR,
VM_STORAGE.MODEL,
VM_STORAGE.SERIAL_NUMBER,
VM_STORAGE.TYPE,
VM_STORAGE.CAPACITY,
VM_STORAGE.STATUS	as LUN_STATUS,
VM_STORAGE.PATH_POLICY,
VM_STORAGE.ISCSI_TARGET_ADDRESS,
VM_STORAGE.ISCSI_TARGET_PORT,

VM_STORAGE.NAS_REMOTE_HOST,

VM_STORAGE.NAS_REMOTE_PATH,

VM_PATH.FS_TYPE,
VM_PATH.ID	as PATH_ID,
VM_PATH.VM_ID	as PATH_VM_ID,
VM_PATH.NAME	as PATH_NAME,
VM_PATH.FABRIC_ID,
VM_PATH.HBA_PORT,
VM_PATH.VM_PORT_WWN,
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,

Brocade Network Advisor IP User Manual	1669
53-1003056-01