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

2262 Brocade Network Advisor SAN + IP User Manual
53-1002949-01
Views
I
SOURCE_SWITCH_PORT.VIRTUAL_SWITCH_ID = SOURCE_VIRTUAL_SWITCH.ID and
SOURCE_SWITCH_PORT.CATEGORY = 1 and
SOURCE_SWITCH_PORT.USER_PORT_NUMBER = ISL.SOURCE_PORT_NUMBER and
DEST_FABRIC_MEMBER.FABRIC_ID = ISL.FABRIC_ID and
DEST_VIRTUAL_SWITCH.ID = DEST_FABRIC_MEMBER.VIRTUAL_SWITCH_ID and
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