HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 46

E Database tables and fields TABLE 58 Field SYSLOG_EVENT (Continued) Definition EVENT_NUMBER Sequence number of the event. EVENT_COUNT Number of occurrences of the event. AUDIT Audit file of the syslog message. FIRST_OCCURENCE_ SWITCH_TIME First occurrence switch time. LAST_OCCURENCE_ SWITCH_TIME Last occurrence switch time. FIRST_OCCURENCE_ HOST_TIME Last occurrence switch time. LAST_OCCURENCE_HOST_ Last occurrence host time. TIME MODULE Module of the event. MESSAGE_ID Message ID of the event. DESCRIPTION Description of the event. PROBABLE_CAUSE Probable root cause of the event. RECOMMENDED_ACTION Recommended action for the event. CONTRIBUTORS Contributors of the syslog event. Format Size int int varchar 10 timestamp timestamp timestamp timestamp varchar 10 varchar 20 varchar 512 varchar 512 varchar 512 varchar 512 TABLE 59 Field EVENT Definition Format Size ID* int ME_ID Weak reference to MANAGED_ELEMENT_ID present in int MANAGED_ELEMENT table. This can be a null and hence maintained as a weak reference. 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 Last occurrence host time; this is set to GMT time. _TIME timestamp 38 Brocade Network Advisor Documentation Updates 53-1002363-02