HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 215

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, Brocade Network Advisor Documentation Updates 207 53-1002363-02