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

38 Brocade Network Advisor Documentation Updates
53-1002363-02
Database tables and fields
E
EVENT_NUMBER Sequence number of the event. int
EVENT_COUNT Number of occurrences of the event. int
AUDIT Audit file of the syslog message. varchar 10
FIRST_OCCURENCE_
SWITCH_TIME
First occurrence switch time. timestamp
LAST_OCCURENCE_
SWITCH_TIME
Last occurrence switch time. timestamp
FIRST_OCCURENCE_
HOST_TIME
Last occurrence switch time. timestamp
LAST_OCCURENCE_HOST_
TIME
Last occurrence host time. timestamp
MODULE Module of the event. varchar 10
MESSAGE_ID Message ID of the event. varchar 20
DESCRIPTION Description of the event. varchar 512
PROBABLE_CAUSE Probable root cause of the event. varchar 512
RECOMMENDED_ACTION Recommended action for the event. varchar 512
CONTRIBUTORS Contributors of the syslog event. varchar 512
TABLE 59 EVENT
Field Definition Format Size
ID* int
ME_ID Weak reference to MANAGED_ELEMENT_ID present in
MANAGED_ELEMENT table. This can be a null and
hence maintained as a weak reference.
int
SEVERITY Default value is 7. int
AREA Indicates whether the event corresponds to
SAN/IP/Application/SAN and IP.
Default value is 0.
smallint
ACKNOWLEDGED 0 =Unack.
1 =Ack
Default value is 0.
smallint
SOURCE_NAME Name of the source from which the event originated. varchar 255
SOURCE_ADDR Source's IP address. varchar 50
EVENT_ORIGIN_ID int
EVENT_CATEGORY_ID int
EVENT_MODULE_ID int
EVENT_DESCRIPTION_ID Weak reference to ID in EVENT_DESCRIPTION table. int
LAST_OCCURRENCE_HOST
_TIME
Last occurrence host time; this is set to GMT time. timestamp
TABLE 58 SYSLOG_EVENT (Continued)
Field Definition Format Size