Brocade Communications Systems IP250 user manual Vmmdiscoveredmacinfo

I Views

VR_CONN_DOMAIN.ID as VIRTUAL_CONNECT_DOMAIN_ID,

VR_CONN_MODULE.ID as VIRTUAL_CONNECT_MODULE_ID,

VR_CONN_MODULE_PORT.ID as VIRTUAL_CONNECT_MODULE_PORT_ID, VIRTUAL_SWITCH.ID as VIRTUAL_SWITCH_ID, coalesce(SWITCH_PORT.WWN, VR_CONN_MODULE_PORT.WWN) as UPLINK_PORT_WWN, coalesce(SWITCH_PORT.PORT_NUMBER, VR_CONN_MODULE_PORT.POSITION_) as

UPLINK_PORT_NUMBER, DEVICE_PORT.ID as DEVICE_PORT_ID,

DEVICE_PORT.NUMBER as DEVICE_PORT_NUMBER, DEVICE_PORT.TYPE as DEVICE_PORT_TYPE, DEVICE_NODE.ID as DEVICE_NODE_ID,

DEVICE_NODE.FABRIC_ID,

USER_DEFINED_DEVICE_DETAIL.NAME

from

VR_CONN_WWN inner join

VR_CONN_FC_CONNECTION on

VR_CONN_FC_CONNECTION.ID = VR_CONN_WWN.VR_CONN_FC_CONNECTION_ID inner join

VR_CONN_SERVER_PROFILE on VR_CONN_SERVER_PROFILE.ID =

VR_CONN_FC_CONNECTION.VR_CONN_SERVER_PROFILE_ID 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,

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