Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

1200 Brocade Network Advisor SAN User Manual
53-1002696-01
Database tables and fields
H
EVENT_ORIGIN_ID Database ID of the event origin such as Trap, Syclog
etc referring to EVENT_ORIGIN metadata.
int
EVENT_CATEGORY_ID Database ID of the event category referring to
EVENT_CATEGORY metadata.
int
EVENT_MODULE_ID Database ID of the event module referring to
EVENT_MODULE metadata.
int
EVENT_DESCRIPTION_ID Indicates the identifier of the event description in the
EVENT_DESCRIPTION table.
int
LAST_OCCURRENCE_HOST
_TIME
Indicates the BNA server timestamp when this event
occurred last.
timestamp
EVENT_COUNT Indicates the number of occurrences of the event.
Count indicates the number of times the same event
occurred in a given ten minute window.
int
RESOLVED This field indicates whether an event is resolved due to
another matching event or based on user action.
Possible values: Unresolved – 0, Resolved – 1.
smallint
ACKED_TIME Indicates the timestamp when the event was
acknowledged.
Timestamp
FIRST_OCCURRENCE_HOST
_TIME
Indicates the BNA server timestamp when the event
occurred for the first time.
timestamp 10
EVENT_AUDIT 'Indicates whether this is an audit event or not. varchar 255
EVENT_KEY Unique key for the event. This is a string message key
represents message ID from events originated from
switch or the predefined message Id for application
events in BNA.
varchar
EVENT_ACTION_ID Reference to the ID in the EVENT_POLICY table.
Represents the event action policy that was
responsible for generating this event.
int
DEVICE_GROUP_ID Reference to the DEVICE_GROUP_ID in the
DEVICE_GROUP table.
int
PORT_GROUP_ID Reference to the ID in the PORT_GROUP table. int
SPECIAL_EVENT 'Indicates whether the event is marked as special
event or not. Not a Special event-0, Special event-1.
smallint
TABLE 100 EVENT_CALL_HOME
Field Definition Format Size
ID Unique generated database identifier. int
EVENT_ID Database ID of the EVENT instance. int
EVENT_NUMBER Indicates the Event Number for the event from the
Events.html of the associated product .
int
FRU_CODE Indicates the Field Replaceable Unit code of the Call
Home event.
int
TABLE 99 EVENT (Continued)
Field Definition Format Size