HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 189
Event_details_info, Source_switch_port.virtual_switch_id = Source_virtual_switch.id
![]() |
View all HP Brocade 8/12c manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 189 highlights
Views E 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 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, 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_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_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 from EVENT Brocade Network Advisor Documentation Updates 181 53-1002363-02
![](/manual_guide/products/hewlettpackard-brocade-812c-brocade-network-advisor-documentation-updates-v111x-53100236303-2011-4c13200/189.png)