Brocade Network Advisor IP User Manual v12.1.0 - Manual (Page 1736)

1682 Brocade Network Advisor IP User Manual
53-1002947-01
Views
I
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,
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,