Brocade Communications Systems IP250 user manual Isltrunkinfo

Views I

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,

SWITCH_PORT.SPEED_TYPE

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

ISL_TRUNK_GROUP, ISL_INFO,

CORE_SWITCH SOURCE_CORE_SWITCH, CORE_SWITCH DEST_CORE_SWITCH,

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