Brocade Network Advisor Documentation Updates v11.1.x (53-1002363-03, August 2011)

122 Brocade Network Advisor Documentation Updates
53-1002363-02
Database tables and fields
E
TABLE 234 EVENT_CATEGORY
Field Definition Format Size
ID 0 - Unknown
1 - Product Event
2 - Link Incident Event
3 - Product Audit Event
4 - Product Status Event
5 - Security Event
6 - User Action Event
7 - Management Server Event
int
DESCRIPTION varchar 50
TABLE 235 EVENT_DESCRIPTION
Field Definition Format Size
ID int
DESCRIPTION varchar 1024
TABLE 236 EVENT_DETAILS
Field Definition Format Size
ID int
EVENT_ID int
FIRST_OCCURRENCE_SWI
TCH_TIME
timestamp
LAST_OCCURRENCE_SWIT
CH_TIME
timestamp
CONTRIBUTORS Populated only for SAN events varchar 512
OPERATIONAL_STATUS Populated only for SAN events - check the constants varchar 255
NODE_WWN Populated only for SAN events varchar 23
PORT_WWN Populated only for SAN events varchar 23
OID varchar 50
VIRTUAL_FABRIC_ID Virtual Fabric Id of the switch smallint
UNIT From INM EVENT_MAIN table smallint
SLOT From INM EVENT_MAIN table int
PORT From INM EVENT_MAIN table int
PRODUCT_ADDRESS varchar
RAS_LOG_ID Reference to RAS_LOG table. This will be used to
retrieve Probable cause and Recommended cause
information in addition to showing MESSAGE_ID
information retrieved from SAN switches.
varchar