Brocade Communications Systems Network Advisor 12.3.0, User Manual

Page: 1906 / 1940

1854 Brocade Network Advisor SAN User Manual
53-1003154-01
Views
H
left outer join
VIRTUAL_SWITCH on
VIRTUAL_SWITCH.WWN = VR_CONN_MODULE.WWN;
VR_CONN_NPIV_INFO
create or replace view VR_CONN_NPIV_INFO as
select
VR_CONN_WWN.ID,
VR_CONN_WWN.VR_CONN_FC_CONNECTION_ID,
VR_CONN_WWN.PORT_ADDRESS as PORT_WWN,
VR_CONN_WWN.NODE_ADDRESS as NODE_WWN,
VR_CONN_SERVER_PROFILE.NAME as SERVER_PROFILE_NAME,
VR_CONN_SERVER_PROFILE.BAY_NAME,
coalesce(VR_CONN_SERVER_PROFILE.BAY_NUMBER,
VR_CONN_FC_CONNECTION.CONNECTION_BAY) as BAY_NUMBER,
VR_CONN_SERVER_PROFILE.VIRTUAL_SERIAL_NUMBER,
VCEM_PROFILE.ID as VCEM_PROFILE_ID,
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