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

Brocade Network Advisor SAN User Manual 1807
53-1003154-01
Views
H
SWITCH_PORT
where
ISL_TRUNK_GROUP.id = ISL_TRUNK_MEMBER.GROUP_ID
and ISL_TRUNK_GROUP.VIRTUAL_SWITCH_ID = SWITCH_PORT.VIRTUAL_SWITCH_ID
and ISL_TRUNK_MEMBER.PORT_NUMBER= SWITCH_PORT.USER_PORT_NUMBER;
ISL_TRUNK_INFO
create or replace view ISL_TRUNK_INFO as
select
ISL_TRUNK_GROUP.ID,
ISL_TRUNK_GROUP.TRUSTED,
ISL_TRUNK_GROUP.MISSING,
ISL_TRUNK_GROUP.MISSING_TIME,
ISL_TRUNK_GROUP.MEMBER_TRACKING_STATUS,
ISL_INFO.COST,
ISL_INFO.TYPE,
ISL_INFO.SOURCE_PORT_NUMBER,
ISL_INFO.SOURCE_SWITCH_ID,
ISL_INFO.MISSING_REASON,
SOURCE_CORE_SWITCH.IP_ADDRESS as SOURCE_SWITCH_IP_ADDRESS,
SOURCE_VIRTUAL_SWITCH.WWN as SOURCE_SWITCH_WWN,
SOURCE_VIRTUAL_SWITCH.MANAGEMENT_STATE as SOURCE_SWITCH_MANAGEMENT_STATE,
SOURCE_VIRTUAL_SWITCH.MONITORED as SOURCE_SWITCH_MONITORED,
ISL_INFO.SOURCE_DOMAIN_ID as MASTER_PORT,
ISL_INFO.SOURCE_SWITCH_NAME,
ISL_INFO.SOURCE_SWITCH_PORT_ID,
ISL_INFO.DEST_PORT_NUMBER,
ISL_INFO.DEST_SWITCH_ID,
DEST_CORE_SWITCH.IP_ADDRESS as DEST_SWITCH_IP_ADDRESS,
DEST_VIRTUAL_SWITCH.WWN as DEST_SWITCH_WWN,
DEST_VIRTUAL_SWITCH.MANAGEMENT_STATE as DEST_SWITCH_MANAGEMENT_STATE,
DEST_VIRTUAL_SWITCH.MONITORED as DEST_SWITCH_MONITORED,
ISL_INFO.SOURCE_SWITCH_PORT_WWN,
ISL_INFO.DEST_DOMAIN_ID as REMOTE_MASTER_PORT,
ISL_INFO.DEST_SWITCH_NAME,
ISL_INFO.DEST_SWITCH_PORT_ID
from
ISL_TRUNK_GROUP,
ISL_INFO,
CORE_SWITCH SOURCE_CORE_SWITCH,
CORE_SWITCH DEST_CORE_SWITCH,
VIRTUAL_SWITCH SOURCE_VIRTUAL_SWITCH,
VIRTUAL_SWITCH DEST_VIRTUAL_SWITCH
where
ISL_INFO.SOURCE_SWITCH_ID = ISL_TRUNK_GROUP.VIRTUAL_SWITCH_ID
and ISL_INFO.SOURCE_PORT_NUMBER = ISL_TRUNK_GROUP.MASTER_USER_PORT
and ISL_INFO.SOURCE_SWITCH_ID = SOURCE_VIRTUAL_SWITCH.ID
and SOURCE_VIRTUAL_SWITCH.CORE_SWITCH_ID = SOURCE_CORE_SWITCH.ID
and ISL_INFO.DEST_SWITCH_ID = DEST_VIRTUAL_SWITCH.ID
and DEST_VIRTUAL_SWITCH.CORE_SWITCH_ID = DEST_CORE_SWITCH.ID;
L2_NEIGHBOR_INFO
create or replace view L2_NEIGHBOR_INFO as
select