Brocade Network Advisor IP User Manual v12.1.0 - Manual (Page 1742)

1688 Brocade Network Advisor IP User Manual
53-1002947-01
Views
I
inner join
VR_CONN_DOMAIN on
VR_CONN_DOMAIN.GUID = VR_CONN_SERVER_PROFILE.BAY_ENCLOSURE_UUID
inner join
VCEM_PROFILE on
VCEM_PROFILE.ID = VR_CONN_SERVER_PROFILE.VCEM_PROFILE_ID
inner join
VR_CONN_MODULE on
VR_CONN_MODULE.VR_CONN_DOMAIN_ID = VR_CONN_DOMAIN.ID and
VR_CONN_MODULE.IO_BAY = VR_CONN_FC_CONNECTION.CONNECTION_BAY
inner join
VR_CONN_MODULE_PORT on
VR_CONN_MODULE_PORT.VR_CONN_MODULE_ID = VR_CONN_MODULE.ID and
VR_CONN_MODULE_PORT.POSITION_ = VR_CONN_FC_CONNECTION.PORT_NUMBER
left outer join
VIRTUAL_SWITCH on
VIRTUAL_SWITCH.WWN = VR_CONN_MODULE.WWN
left outer join
SWITCH_PORT on
SWITCH_PORT.WWN = VR_CONN_MODULE_PORT.WWN
left outer join
DEVICE_PORT on
DEVICE_PORT.WWN = VR_CONN_WWN.PORT_ADDRESS
left outer join
DEVICE_NODE on
DEVICE_NODE.WWN = VR_CONN_WWN.NODE_ADDRESS
left outer join
USER_DEFINED_DEVICE_DETAIL on
USER_DEFINED_DEVICE_DETAIL.WWN = VR_CONN_WWN.PORT_ADDRESS;
VMM_DISCOVERED_MAC_INFO
create or replace view VMM_DISCOVERED_MAC_INFO AS
select
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,
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