Brocade Communications Systems IP250 user manual Vmhostinfo, Vmluninfo

I Views

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,
VM_VIRTUAL_MACHINE.HOSTNAME		as VM_HOSTNAME,
VM_VIRTUAL_MACHINE.BOOT_TIME		as VM_BOOT_TIME,
VM_VIRTUAL_MACHINE.DATASTORE_NAME,
VM_VIRTUAL_MACHINE.DATASTORE_LOCATION,
VM_VIRTUAL_MACHINE.NODE_WWN		as VM_NODE_WWN
from
VM_DATA_CENTER,
VM_HOST
left join VM_VIRTUAL_MACHINE

on VM_HOST.DEVICE_ENCLOSURE_ID = VM_VIRTUAL_MACHINE.HOST_ID

where

VM_DATA_CENTER.ID = VM_HOST.VM_DATACENTER_ID;

VM_LUN_INFO

create or replace view VM_LUN_INFO as select

VM_STORAGE.HOST_ID,

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