Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

Brocade Network Advisor SAN User Manual 1181
53-1002167-01
Views
E
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,
CLUSTER.NAME as CLUSTER_NAME,
CLUSTER.IP_ADDRESS as CLUSTER_ADDRESS,
VIRTUAL_MACHINE.ID as VM_ID,
VIRTUAL_MACHINE.HYPERVISOR_VM_ID,
VIRTUAL_MACHINE.NAME as VM_NAME,
VIRTUAL_MACHINE.DESCRIPTION as VM_DESCRIPTION,
VIRTUAL_MACHINE.OS as VM_OS,
VIRTUAL_MACHINE.STATUS as VM_STATUS,
VIRTUAL_MACHINE.VCPU_COUNT,
VIRTUAL_MACHINE.CPU_RESOURCES as VM_CPU_RESOURCES,
VIRTUAL_MACHINE.MEM_RESOURCES as VM_MEM_RESOURCES,
VIRTUAL_MACHINE.IP_ADDRESS as VM_IP_ADDRESS,
VIRTUAL_MACHINE.HOSTNAME as VM_HOSTNAME,
VIRTUAL_MACHINE.BOOT_TIME as VM_BOOT_TIME,
VIRTUAL_MACHINE.DATASTORE_NAME,
VIRTUAL_MACHINE.DATASTORE_LOCATION,
VIRTUAL_MACHINE.NODE_WWN as VM_NODE_WWN
from
VM_HOST
left outer join (CLUSTER join CLUSTER_MEMBER on CLUSTER_MEMBER.CLUSTER_ID =
CLUSTER.ID)
on CLUSTER_MEMBER.DEVICE_ENCLOSURE_ID = VM_HOST.ID
left outer join VIRTUAL_MACHINE
on VM_HOST.ID = VIRTUAL_MACHINE.HOST_ID;
VM_LUN_INFO
create or replace view VM_LUN_INFO as
select
VM_LUN.HOST_ID,
VM_LUN.ID as LUN_ID,
VM_LUN.NAME as LUN_NAME,
VM_LUN.NODE_WWN,
VM_LUN.VENDOR,
VM_LUN.MODEL,
VM_LUN.SERIAL_NUMBER,
VM_LUN.TYPE,
VM_LUN.CAPACITY,
VM_LUN.STATUS as LUN_STATUS,
VM_LUN.PATH_POLICY,
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_WWN,
VM_PATH.VM_PORT_WWN,
VM_PATH.TARGET_PORT_WWN,
VM_PATH.HBA_NODE_WWN,
VM_PATH.VM_NODE_WWN,
VM_PATH.TARGET_NODE_WWN,
VM_PATH.HBA_NAME,
VM_PATH.USAGE as PATH_USAGE,
VM_PATH.ENABLED as PATH_ENABLED,