Brocade Network Advisor SAN + IP User Manual v12.1.0 User Manual

Page 2344

Brocade Network Advisor SAN + IP User Manual

2307

53-1002949-01

Views

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.SWITCH_PORT_WWN = SWITCH_PORT.WWN

and SWITCH_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID

and VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID

and DEVICE_PORT.NODE_ID = DEVICE_NODE.ID

and DEVICE_NODE.FABRIC_ID = FABRIC.ID

union all

select

VM_VCENTER.HOST AS VCENTER_HOST,

DEVICE_PORT.SWITCH_PORT_WWN,

DEVICE_PORT.DOMAIN_ID,

device_port.id as device_port_id,

DEVICE_PORT.NUMBER,

CORE_SWITCH.IP_ADDRESS,

CORE_SWITCH.NAME as CORE_NAME,

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,