Brocade Network Advisor IP User Manual 1673
53-1003056-01
Views I
DEVICE_NODE on
DEVICE_NODE.WWN = VR_CONN_MODULE.WWN
left outer join
FABRIC on
DEVICE_NODE.FABRIC_ID = FABRIC.ID;
VR_CONN_MODULE_PORT_INFO
create or replace view VR_CONN_MODULE_PORT_INFO as
select
VR_CONN_MODULE_PORT.ID,
VR_CONN_MODULE_PORT.VR_CONN_MODULE_ID,
VR_CONN_MODULE_PORT.WWN,
VR_CONN_MODULE_PORT.POSITION_,
VR_CONN_MODULE_PORT.FABRIC_NAME,
VR_CONN_MODULE_PORT.SPEED,
VR_CONN_MODULE_PORT.STATUS,
VR_CONN_MODULE_PORT.LAST_STATUS,
VR_CONN_MODULE_PORT.REMOTE_NODE_WWN,
VR_CONN_MODULE_PORT.CREATION_TIME,
VR_CONN_MODULE_PORT.LAST_UPDATE_TIME,
VR_CONN_MODULE.IO_BAY,
VR_CONN_DOMAIN.ID as VR_CONN_DOMAIN_ID,
VCEM_PROFILE.ID as VCEM_PROFILE_ID,
SWITCH_PORT.ID as SWITCH_PORT_ID,
VIRTUAL_SWITCH.ID as VIRTUAL_SWITCH_ID
from
VR_CONN_MODULE_PORT
inner join
VR_CONN_MODULE on
VR_CONN_MODULE.ID = VR_CONN_MODULE_PORT.VR_CONN_MODULE_ID
inner join
VR_CONN_DOMAIN on
VR_CONN_DOMAIN.ID = VR_CONN_MODULE.VR_CONN_DOMAIN_ID
inner join
VCEM_PROFILE on
VCEM_PROFILE.ID = VR_CONN_DOMAIN.VCEM_PROFILE_ID
left outer join
SWITCH_PORT on
SWITCH_PORT.WWN = VR_CONN_MODULE_PORT.WWN
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,