Brocade Communications Systems Network Advisor 12.3.0, User Manual

Page: 1896 / 1940

1844 Brocade Network Advisor SAN User Manual
53-1003154-01
Views
H
VM_VCENTER.ID as VCENTER_ID,
DEVICE_ENCLOSURE.ID AS HOST_DB_ID,
DEVICE_ENCLOSURE.IP_ADDRESS as HYPERVISOR_HOST,
VM_VIRTUAL_MACHINE.ID as VM_ID,
VM_VIRTUAL_MACHINE.IP_ADDRESS AS VM_IP_ADDRESS,
VM_VIRTUAL_MACHINE.HOSTNAME AS VM_HOST_NAME,
VM_VIRTUAL_MACHINE.UUID as VM_UUID,
VM_VIRTUAL_MACHINE.NAME as VM_NAME,
VM_PATH.NAME as PATH_NAME,
VM_PATH.HBA_PORT as ADAPTER_PORT_WWN,
VM_PATH.TARGET_PORT as TARGET_PORT_WWN,
VM_STORAGE.NAME as LUN_CAN_NAME,
VM_PATH.FS_TYPE,
VM_VIRTUAL_MACHINE.HYPERVISOR_VM_ID,
DEVICE_ENCLOSURE.MANAGED_ELEMENT_ID AS HOST_ME_ID,
DEVICE_ENCLOSURE.IP_ADDRESS AS HOST_IP_ADDRESS,
DEVICE_ENCLOSURE.HOST_NAME AS HYPERVISOR_HOST_NAME,
FABRIC.NAME as FABRIC_NAME,
VIRTUAL_SWITCH.NAME as VIRTUAL_NAME,
SWITCH_PORT.STATUS as SWITCH_PORT_STATUS,
SWITCH_PORT.ID as SWITCH_PORT_ID,
SWITCH_PORT.PORT_ID,
SWITCH_PORT.PORT_NUMBER,
SWITCH_PORT.SLOT_NUMBER,
USER_DEFINED_DEVICE_DETAIL.NAME as ADAPTER_PORT_NAME,
VM_PATH.FABRIC_ID,
VM_PATH.VM_PORT_WWN,
VM_STORAGE.MODEL,
VM_STORAGE.VENDOR
from
DEVICE_PORT
LEFT JOIN USER_DEFINED_DEVICE_DETAIL
on DEVICE_PORT.WWN = USER_DEFINED_DEVICE_DETAIL.WWN,
CORE_SWITCH,
SWITCH_PORT,
VIRTUAL_SWITCH,
DEVICE_NODE,
FABRIC,
DEVICE_PORT_MAC_ADDRESS_MAP,
GIGE_PORT,
VM_STORAGE,
VM_PATH,
DEVICE_ENCLOSURE,
VM_VIRTUAL_MACHINE,
VM_VCENTER,
VM_DATA_CENTER,
VM_HOST
where
VM_PATH.HBA_PORT = DEVICE_PORT.WWN
and VM_PATH.VM_ID = VM_VIRTUAL_MACHINE.ID
and VM_PATH.STORAGE_ID = VM_STORAGE.ID
and VM_STORAGE.HOST_ID = DEVICE_ENCLOSURE.ID
and DEVICE_ENCLOSURE.ID = VM_HOST.DEVICE_ENCLOSURE_ID
and DEVICE_ENCLOSURE.ID = VM_VIRTUAL_MACHINE.HOST_ID
and VM_HOST.VM_DATACENTER_ID = VM_DATA_CENTER.ID
and VM_DATA_CENTER.VCENTER_ID = VM_VCENTER.ID
and DEVICE_PORT.ID = DEVICE_PORT_MAC_ADDRESS_MAP.DEVICE_PORT_ID
and DEVICE_PORT_MAC_ADDRESS_MAP.MAC_ADDRESS::TEXT =
GIGE_PORT.REMOTE_MAC_ADDRESS::TEXT
and GIGE_PORT.SWITCH_PORT_ID = SWITCH_PORT.ID