I Views

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.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.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.USER_NAME as USER_NAME,

EVENT_DETAILS.PORT_NAME as PORT_NAME,

EVENT_DETAILS.MAC_ADDRESS

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

and

EVENT.EVENT_DESCRIPTION_ID = EVENT_DESCRIPTION.ID;

FABRIC_INFO

CREATE 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, FABRIC.CONTACT, FABRIC.LOCATION, FABRIC.DESCRIPTION, FABRIC.CREATION_TIME, FABRIC.LAST_SCAN_TIME, FABRIC.LAST_UPDATE_TIME, FABRIC.TRACK_CHANGES, FABRIC.TYPE, FABRIC.HAS_NOS_AG, FABRIC.USER_DEFINED_VALUE_1, FABRIC.USER_DEFINED_VALUE_2, FABRIC.USER_DEFINED_VALUE_3,

FABRIC.PRINCIPAL_SWITCH_WWN, FABRIC.ZONE_TRANSACTION_TIMEOUT, FABRIC.FABRIC_MODEL,

1622

Brocade Network Advisor IP User Manual

 

53-1003056-01

Page 1674
Image 1674
Brocade Communications Systems IP250 user manual Fabricinfo