HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 190
Event_info, Fabric_info, Left Outer Join Event_call_home On Event.id = Event_call_home.event_id
View all HP Brocade 8/12c manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 190 highlights
E Views 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, 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_AUDIT as AUDIT, EVENT.EVENT_ACTION_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.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 from EVENT left join EVENT_DETAILS on EVENT.ID = EVENT_DETAILS.EVENT_ID, EVENT_ORIGIN, EVENT_CATEGORY, EVENT_MODULE, EVENT_DESCRIPTION where EVENT.EVENT_ORIGIN_ID = EVENT_ORIGIN.ID and EVENT.EVENT_CATEGORY_ID = EVENT_CATEGORY.ID and EVENT.EVENT_MODULE_ID = EVENT_MODULE.ID FABRIC_INFO create or replace view FABRIC_INFO as select FABRIC.ID, FABRIC.SAN_ID, FABRIC.SEED_SWITCH_WWN, FABRIC.NAME, FABRIC.ACTIVE_ZONESET_NAME, FABRIC.MANAGEMENT_STATE, FABRIC.LAST_FABRIC_CHANGED, FABRIC.SECURE, FABRIC.AD_ENVIRONMENT, FABRIC.MANAGED, 182 Brocade Network Advisor Documentation Updates 53-1002363-02