Brocade Communications Systems IP250 user manual Eventinfo

Views I

EVENT.SOURCE_NAME as SOURCE_NAME,

EVENT.SOURCE_ADDR as SOURCE_ADDR,

EVENT.LAST_OCCURRENCE_HOST_TIME as LAST_OCCURRENCE_HOST_TIME, EVENT.FIRST_OCCURRENCE_HOST_TIME as FIRST_OCCURRENCE_HOST_TIME, EVENT.EVENT_COUNT as EVENT_COUNT,

EVENT.EVENT_KEY as EVENT_KEY, EVENT.EVENT_AUDIT as AUDIT, EVENT.RESOLVED as RESOLVED, EVENT.ACKED_TIME as ACKED_TIME, EVENT.EVENT_ACTION_ID as EVENT_ACTION_ID, EVENT.DEVICE_GROUP_ID as DEVICE_GROUP_ID, EVENT.PORT_GROUP_ID as PORT_GROUP_ID,

EVENT.SPECIAL_EVENT,

EVENT_ORIGIN.ID as ORIGIN,

EVENT_CATEGORY.ID as EVENT_CATEGORY,

EVENT_DESCRIPTION.DESCRIPTION as DESCRIPTION, EVENT_MODULE.ID as MODULE, EVENT_DETAILS.RAS_LOG_ID as RAS_LOG_ID, EVENT_DETAILS.PRODUCT_ADDRESS as PRODUCT_ADDRESS, EVENT_DETAILS.CONTRIBUTORS as CONTRIBUTORS, EVENT_DETAILS.NODE_WWN as NODE_WWN, EVENT_DETAILS.PORT_WWN as PORT_WWN, EVENT_DETAILS.OPERATIONAL_STATUS as OPERATIONAL_STATUS,

EVENT_DETAILS.FIRST_OCCURRENCE_SWITCH_TIME as FIRST_OCCURRENCE_SWITCH_TIME, EVENT_DETAILS.LAST_OCCURRENCE_SWITCH_TIME as LAST_OCCURRENCE_SWITCH_TIME, EVENT_DETAILS.VIRTUAL_FABRIC_ID as VIRTUAL_FABRIC_ID, EVENT_DETAILS.UNIT as UNIT,

EVENT_DETAILS.SLOT as SLOT,

EVENT_DETAILS.PORT as PORT,

EVENT_DETAILS.OID,

EVENT_DETAILS.USER_NAME as USER_NAME,

EVENT_CALL_HOME.EVENT_NUMBER as EVENT_NUMBER, EVENT_CALL_HOME.FRU_CODE as FRU_CODE, EVENT_CALL_HOME.REASON_CODE as REASON_CODE, EVENT_CALL_HOME.FRU_POSITION as FRU_POSITION, EVENT_DETAILS.INTERFACE_TYPE as INTERFACE_TYPE, EVENT_DETAILS.PORT_NAME as PORT_NAME,

EVENT_DETAILS.MAC_ADDRESS

from

EVENT

left outer join EVENT_ORIGIN on EVENT.EVENT_ORIGIN_ID = EVENT_ORIGIN.ID left outer join EVENT_CATEGORY on EVENT.EVENT_CATEGORY_ID =

EVENT_CATEGORY.ID

left outer join EVENT_MODULE on EVENT.EVENT_MODULE_ID = EVENT_MODULE.ID left outer join EVENT_DESCRIPTION on EVENT.EVENT_DESCRIPTION_ID =

EVENT_DESCRIPTION.ID

left outer join EVENT_DETAILS on EVENT.ID = EVENT_DETAILS.EVENT_ID left outer join EVENT_CALL_HOME on EVENT.ID = EVENT_CALL_HOME.EVENT_ID;

EVENT_INFO

create or replace view EVENT_INFO as select

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

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