Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

Brocade Network Advisor SAN User Manual 1571
53-1002948-01
Views
H
VM_LUN_INFO
create or replace view VM_LUN_INFO as
select
VM_STORAGE.HOST_ID,
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,