Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1900)

1848 Brocade Network Advisor SAN User Manual
53-1003154-01
Views
H
DEST_NODE.WWN as DEST_DEVICE_WWN,
DEST_PORT.WWN as DEST_PORT_WWN,
SOURCE_NODE.FABRIC_ID as SOURCE_FABRIC_ID,
DEST_NODE.FABRIC_ID as DEST_FABRIC_ID,
SOURCE_PORT.DOMAIN_ID as SOURCE_SWITCH_DOMAIN_ID,
DEST_PORT.DOMAIN_ID as DEST_SWITCH_DOMAIN_ID,
VM_VIRTUAL_MACHINE.HYPERVISOR_VM_ID,
VM_VIRTUAL_MACHINE.NAME as VM_NAME
from
VM_PATH,
VM_VIRTUAL_MACHINE,
DEVICE_PORT as SOURCE_PORT,
DEVICE_PORT as DEST_PORT,
DEVICE_NODE as DEST_NODE,
DEVICE_NODE as SOURCE_NODE,
EE_MONITOR,
EE_MONITOR_STATS
where
VM_PATH.HBA_PORT::BPCHAR = SOURCE_PORT.WWN
and VM_PATH.VM_ID = VM_VIRTUAL_MACHINE.ID
and SOURCE_PORT.ID = EE_MONITOR.SOURCE_PORT_ID
and EE_MONITOR.ID = EE_MONITOR_STATS.EE_MONITOR_ID
and SOURCE_PORT.NODE_ID = SOURCE_NODE.ID
and DEST_PORT.ID = EE_MONITOR.DEST_PORT_ID
and DEST_PORT.NODE_ID = DEST_NODE.ID
and EE_MONITOR_STATS.CREATION_TIME in (select MAX(CREATION_TIME) from
EE_MONITOR_STATS group by EE_MONITOR_ID);
comment on view VM_EE_MONITOR_INFO is
'Combined ee_monitor, ee_monitor_stats, device_port and device_node tables to get
the EE Monitor info for vmplug-in';
VM_HOST_INFO
CREATE VIEW vm_host_info AS
select
VM_DATA_CENTER.VCENTER_ID as VCENTER_ID,
VM_HOST.DEVICE_ENCLOSURE_ID as HOST_ID,
VM_HOST.VM_DATACENTER_ID as DATACENTER_ID,
VM_HOST.NODE_WWN as HOST_NODE_WWN,
VM_HOST.HYPERVISOR_NAME,
VM_HOST.HYPERVISOR_TYPE,
VM_HOST.CPU_COUNT,
VM_HOST.CPU_TYPE,
VM_HOST.CPU_RESOURCES as HOST_CPU_RESOURCES,
VM_HOST.MEM_RESOURCES as HOST_MEM_RESOURCES,
VM_HOST.LICENSE_SERVER,
VM_HOST.BOOT_TIME as HOST_BOOT_TIME,
VM_HOST.CLUSTER_NAME as CLUSTER_NAME,
VM_VIRTUAL_MACHINE.ID as VM_ID,
VM_VIRTUAL_MACHINE.HYPERVISOR_VM_ID,
VM_VIRTUAL_MACHINE.NAME as VM_NAME,
VM_VIRTUAL_MACHINE.DESCRIPTION as VM_DESCRIPTION,
VM_VIRTUAL_MACHINE.OS as VM_OS,
VM_VIRTUAL_MACHINE.STATUS as VM_STATUS,
VM_VIRTUAL_MACHINE.VCPU_COUNT,
VM_VIRTUAL_MACHINE.CPU_RESOURCES as VM_CPU_RESOURCES,
VM_VIRTUAL_MACHINE.MEM_RESOURCES as VM_MEM_RESOURCES,
VM_VIRTUAL_MACHINE.IP_ADDRESS as VM_IP_ADDRESS,