Brocade Communications Systems IP250 Ethernetislinfo, Eventdetailsinfo, Fabric.Id = Isl.Fabricid

I Views

DEST_VIRTUAL_SWITCH.DOMAIN_ID = ISL.DEST_DOMAIN_ID and

DEST_SWITCH_PORT.VIRTUAL_SWITCH_ID = DEST_VIRTUAL_SWITCH.ID and

DEST_SWITCH_PORT.CATEGORY = 1 and

DEST_SWITCH_PORT.USER_PORT_NUMBER = ISL.DEST_PORT_NUMBER and

FABRIC.ID = ISL.FABRIC_ID;

ETHERNET_ISL_INFO

create or replace view ETHERNET_ISL_INFO as select

ETHERNET_ISL.ID as ETHERNET_ISL_ID,

ETHERNET_ISL.SOURCE_PORT_ID, ETHERNET_ISL.DEST_PORT_ID,

ETHERNET_ISL.TRUSTED, ETHERNET_ISL.CREATION_TIME, ETHERNET_ISL.MISSING, ETHERNET_ISL.MISSING_TIME,

SOURCE_SWITCH_PORT.VIRTUAL_SWITCH_ID as SOURCE_SWITCH_ID, SOURCE_SWITCH_PORT.USER_PORT_NUMBER as SOURCE_PORT_NUMBER, SOURCE_SWITCH_PORT.TYPE as SOURCE_PORT_TYPE, SOURCE_VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID as SOURCE_VIRTUAL_FABRIC_ID, DEST_SWITCH_PORT.VIRTUAL_SWITCH_ID as DEST_SWITCH_ID, DEST_SWITCH_PORT.USER_PORT_NUMBER as DEST_PORT_NUMBER, DEST_SWITCH_PORT.TYPE as DEST_PORT_TYPE, DEST_VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID as DEST_VIRTUAL_FABRIC_ID

from

ETHERNET_ISL,

GIGE_PORT SOURCE_GIGE_PORT, VIRTUAL_SWITCH SOURCE_VIRTUAL_SWITCH,

SWITCH_PORT SOURCE_SWITCH_PORT,

GIGE_PORT DEST_GIGE_PORT, VIRTUAL_SWITCH DEST_VIRTUAL_SWITCH,

SWITCH_PORT DEST_SWITCH_PORT where

SOURCE_GIGE_PORT.ID = ETHERNET_ISL.SOURCE_PORT_ID and SOURCE_GIGE_PORT.SWITCH_PORT_ID = SOURCE_SWITCH_PORT.ID and SOURCE_SWITCH_PORT.VIRTUAL_SWITCH_ID = SOURCE_VIRTUAL_SWITCH.ID and DEST_GIGE_PORT.ID = ETHERNET_ISL.DEST_PORT_ID and DEST_GIGE_PORT.SWITCH_PORT_ID = DEST_SWITCH_PORT.ID and

DEST_SWITCH_PORT.VIRTUAL_SWITCH_ID = DEST_VIRTUAL_SWITCH.ID;

EVENT_DETAILS_INFO

create or replace view EVENT_DETAILS_INFO (ID, ME_ID, SEVERITY, AREA,

ACKNOWLEDGED, SOURCE_NAME, SOURCE_ADDR, LAST_OCCURRENCE_HOST_TIME,

FIRST_OCCURRENCE_HOST_TIME, EVENT_COUNT, EVENT_KEY, AUDIT, RESOLVED, ACKED_TIME, EVENT_ACTION_ID, DEVICE_GROUP_ID, PORT_GROUP_ID, SPECIAL_EVENT, ORIGIN, EVENT_CATEGORY, DESCRIPTION, MODULE, RAS_LOG_ID, PRODUCT_ADDRESS, CONTRIBUTORS, NODE_WWN, PORT_WWN, OPERATIONAL_STATUS, FIRST_OCCURRENCE_SWITCH_TIME, LAST_OCCURRENCE_SWITCH_TIME, VIRTUAL_FABRIC_ID, UNIT, SLOT, PORT, OID, USER_NAME, EVENT_NUMBER, FRU_CODE, REASON_CODE, FRU_POSITION, INTERFACE_TYPE, PORT_NAME, MAC_ADDRESS) as

select

EVENT.ID as ID, EVENT.ME_ID as ME_ID, EVENT.SEVERITY as SEVERITY, EVENT.AREA as AREA, EVENT.ACKNOWLEDGED as ACKNOWLEDGED,

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