Brocade Communications Systems IP250 user manual Devportmacaddrmapinfo, Islconnectioninfo, Islinfo

I Views

DEVICE_PORT_GIGE_PORT_LINK.DEVICE_PORT_ID = DEVICE_PORT.ID;

DEV_PORT_MAC_ADDR_MAP_INFO

create or replace view DEV_PORT_MAC_ADDR_MAP_INFO as select

DEVICE_PORT_MAC_ADDRESS_MAP.DEVICE_PORT_ID, DEVICE_PORT_MAC_ADDRESS_MAP.MAC_ADDRESS, DEVICE_NODE.ID as DEVICE_NODE_ID,

DEVICE_NODE.FABRIC_ID, DEVICE_PORT.TRUSTED, DEVICE_PORT.CREATION_TIME, DEVICE_PORT.MISSING, DEVICE_PORT.MISSING_TIME

from

DEVICE_PORT_MAC_ADDRESS_MAP, DEVICE_PORT,

DEVICE_NODE where

DEVICE_PORT_MAC_ADDRESS_MAP.DEVICE_PORT_ID = DEVICE_PORT.ID and DEVICE_PORT.NODE_ID = DEVICE_NODE.ID;

ISL_CONNECTION_INFO

create or replace view ISL_CONNECTION_INFO as select

distinct ISL_CONNECTION.ID, ISL_CONNECTION.FABRIC_ID, ISL_CONNECTION.SOURCE_SWITCH_PORT_ID, ISL_CONNECTION.TARGET_SWITCH_PORT_ID, ISL_CONNECTION.COST, ISL_CONNECTION.TYPE, ISL_CONNECTION.TRUSTED, ISL_CONNECTION.MISSING, ISL_CONNECTION.MISSING_TIME, ISL_CONNECTION.CREATION_TIME, ISL_CONNECTION.TRUNKED,

SOURCE_SWITCH_PORT.VIRTUAL_SWITCH_ID as SOURCE_SWITCH_ID,

SOURCE_SWITCH_PORT.USER_PORT_NUMBER as SOURCE_SWITCH_PORT_NUMBER, DEST_SWITCH_PORT.VIRTUAL_SWITCH_ID as DEST_SWITCH_ID, DEST_SWITCH_PORT.USER_PORT_NUMBER as DEST_SWITCH_PORT_NUMBER

from

ISL_CONNECTION,

SWITCH_PORT SOURCE_SWITCH_PORT, SWITCH_PORT DEST_SWITCH_PORT

where

ISL_CONNECTION.SOURCE_SWITCH_PORT_ID = SOURCE_SWITCH_PORT.ID and ISL_CONNECTION.TARGET_SWITCH_PORT_ID = DEST_SWITCH_PORT.ID;

ISL_INFO

create or replace view ISL_INFO as select distinct

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