Brocade Communications Systems IP250 user manual Vmvirtualethernetadapterinfo

Views I

VM_VIRTUAL_MACHINE.NAME AS VIRTUAL_MACHINE_NAME, VM_VCENTER_MEMBER.HOST_NAME,

VM_VCENTER.NAME AS VCENTER_NAME

from

VM_VIRTUAL_ETHERNET_ADAPTER, VM_VIRTUAL_MACHINE, VM_VCENTER_MEMBER, VM_VCENTER

where

VM_VIRTUAL_ETHERNET_ADAPTER.VIRTUAL_MACHINE_ID = VM_VIRTUAL_MACHINE.ID AND VM_VIRTUAL_MACHINE.HOST_ID = VM_VCENTER_MEMBER.VM_HOST_ID

AND VM_VCENTER_MEMBER.VM_VCENTER_ID = VM_VCENTER.ID

union all select

VM_HOST_VIRTUAL_NIC.MAC AS MAC_ADDRESS,

VM_HOST_VIRTUAL_NIC.DEVICE_NAME AS DISPLAY_LABEL,

VM_HOST_VIRTUAL_NIC.PORT_GROUP_KEY AS PORT_GROUP_NAME, NULL::UNKNOWN AS VIRTUAL_MACHINE_NAME, VM_VCENTER_MEMBER.HOST_NAME,

VM_VCENTER.NAME AS VCENTER_NAME

from

VM_HOST_VIRTUAL_NIC,

VM_VCENTER_MEMBER, VM_VCENTER

where

VM_HOST_VIRTUAL_NIC.VM_HOST_ID = VM_VCENTER_MEMBER.VM_HOST_ID AND VM_VCENTER_MEMBER.VM_VCENTER_ID = VM_VCENTER.ID

union all select

VM_PHYSICAL_NIC.MAC_ADDRESS,

VM_PHYSICAL_NIC.DEVICE_NAME, NULL::UNKNOWN AS PORT_GROUP_NAME, NULL::UNKNOWN AS VIRTUAL_MACHINE_NAME, VM_VCENTER_MEMBER.HOST_NAME, VM_VCENTER.NAME AS VCENTER_NAME

from

VM_PHYSICAL_NIC, VM_VCENTER_MEMBER, VM_VCENTER

where

VM_PHYSICAL_NIC.VM_HOST_ID = VM_VCENTER_MEMBER.VM_HOST_ID AND VM_VCENTER_MEMBER.VM_VCENTER_ID = VM_VCENTER.ID;

VM_VIRTUAL_ETHERNET_ADAPTER_INFO

create or replace view VM_VIRTUAL_ETHERNET_ADAPTER_INFO as select

VM_VIRTUAL_ETHERNET_ADAPTER.ID,

VM_VIRTUAL_ETHERNET_ADAPTER.MAC_ADDRESS, VM_VIRTUAL_ETHERNET_ADAPTER.DISPLAY_LABEL, VM_VIRTUAL_ETHERNET_ADAPTER.PORT_GROUP_NAME, VM_VIRTUAL_MACHINE.NAME as VIRTUAL_MACHINE_NAME,

VM_VCENTER_MEMBER.HOST_NAME,

VM_VCENTER.NAME as VCENTER_NAME

From

VM_VIRTUAL_ETHERNET_ADAPTER,

Brocade Network Advisor IP User Manual	1675
53-1003056-01