Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1907)

Brocade Network Advisor SAN User Manual 1855
53-1003154-01
Views
H
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
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