Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

1156 Brocade Network Advisor SAN User Manual
53-1002167-01
Views
E
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,