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

Page 2362

Brocade Network Advisor SAN + IP User Manual

2325

53-1002949-01

Views

VM_DV_PORT_GROUP.NAME as PGRP_NAME,

VM_DV_SWITCH.NAME as VSWITCH_NAME,

VNIC_DV_PORT.NAME as DVPORT_NAME,

VM_PHYSICAL_NIC.DEVICE_NAME as PNIC_NAME,

VM_PHYSICAL_NIC.MAC_ADDRESS as PNIC_MAC,

DEVICE.SYS_NAME as SWITCH_NAME,

DEVICE.IP_ADDRESS as SWITCH_IP,

PHYSICAL_PORT.PORT_NUM as SWITCH_PORT,

INTERFACE.PORT_STATUS as SWITCH_PORT_STATUS

from

VM_HOST

left join VM_VIRTUAL_MACHINE on VM_HOST.DEVICE_ENCLOSURE_ID =

VM_VIRTUAL_MACHINE.HOST_ID,

VM_VIRTUAL_ETHERNET_ADAPTER,

VM_DV_PORT VNIC_DV_PORT,

VM_DV_PORT PNIC_DV_PORT,

VM_DV_PORT_GROUP,

VM_DV_SWITCH,

VM_PHYSICAL_NIC,

VM_HOST_END_DEV_CONNECTIVITY,

INTERFACE,

DEVICE,

PHYSICAL_INTERFACE,

PHYSICAL_PORT

where

VM_VIRTUAL_MACHINE.ID = VM_VIRTUAL_ETHERNET_ADAPTER.VIRTUAL_MACHINE_ID and

VM_VIRTUAL_ETHERNET_ADAPTER.VM_DV_PORT_ID is not null and

VM_VIRTUAL_ETHERNET_ADAPTER.VM_DV_PORT_ID = VNIC_DV_PORT.ID and

VNIC_DV_PORT.VM_DV_PORT_GROUP_ID = VM_DV_PORT_GROUP.ID and

VNIC_DV_PORT.VM_DV_SWITCH_ID = VM_DV_SWITCH.ID and

PNIC_DV_PORT.VM_DV_SWITCH_ID = VM_DV_SWITCH.ID and

PNIC_DV_PORT.ID = VM_PHYSICAL_NIC.VM_DV_PORT_ID and

VM_PHYSICAL_NIC.ID = VM_HOST_END_DEV_CONNECTIVITY.VM_PHYSICAL_NIC_ID and

VM_HOST_END_DEV_CONNECTIVITY.INTERFACE_ID = INTERFACE.INTERFACE_ID and

INTERFACE.DEVICE_ID = DEVICE.DEVICE_ID and

VM_HOST_END_DEV_CONNECTIVITY.INTERFACE_ID = PHYSICAL_INTERFACE.INTERFACE_ID

and

PHYSICAL_INTERFACE.PHYSICAL_PORT_ID = PHYSICAL_PORT.PHYSICAL_PORT_ID

union all

select

VM_HOST.HYPERVISOR_NAME as VHOST_NAME,

VM_VIRTUAL_MACHINE.NAME as VM_NAME,

VM_VIRTUAL_MACHINE.HYPERVISOR_VM_ID as VM_ID,

VM_VIRTUAL_ETHERNET_ADAPTER.MAC_ADDRESS as VNIC_MAC,

VM_STD_VSWITCH_PORT_GROUP.NAME as PGRP_NAME,

VM_STANDARD_VIRTUAL_SWITCH.NAME as VSWITCH_NAME,

null as DVPORT_NAME,