Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2314)

Brocade Network Advisor SAN + IP User Manual 2277
53-1002949-01
Views
I
ISL_TRUNK_GROUP_MEMBER_INFO
CREATE VIEW isl_trunk_group_member_info AS
select
ISL_TRUNK_GROUP.ID,
ISL_TRUNK_GROUP.VIRTUAL_SWITCH_ID,
ISL_TRUNK_GROUP.MASTER_USER_PORT,
ISL_TRUNK_MEMBER.MISSING,
ISL_TRUNK_MEMBER.TRUSTED,
ISL_TRUNK_MEMBER.MISSING_TIME,
ISL_TRUNK_MEMBER.PORT_NUMBER,
SWITCH_PORT.WWN,
SWITCH_PORT.TYPE,
SWITCH_PORT.STATUS,
SWITCH_PORT.SPEED,
SWITCH_PORT.ID as SWITCH_PORT_ID
from
ISL_TRUNK_GROUP,
ISL_TRUNK_MEMBER,
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 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