Brocade Communications Systems IP250 user manual Vrconnmoduleportinfo, Vrconnnpivinfo

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,

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