Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

Brocade Network Advisor SAN User Manual 1013
53-1002167-01
Database tables and fields
E
EVENT_COUNT Number of occurrences of the event..
Default value is 1.
int
RESOLVED Resolution status of the event.
Default value is 0.
smallint
ACKED_TIME Time at which the event is acknowledged. Timestamp
FIRST_OCCURRENCE_HOST
_TIME
First occurrence host time; this is set to GMT time. timestamp 10
EVENT_AUDIT Flag to indicate if the event is audited. varchar 255
EVENT_KEY This field is a combination of ModuleName and
EventNumber which is unique within the given module.
varchar
EVENT_ACTION_ID Weak reference to ACTION ID present in
EVENT_ACTION table. This can be a null and hence
maintained as a weak reference.
int
DEVICE_GROUP_ID Weak reference to DEVICE GROUP ID present in
DEVICE_GROUP table. This can be a null and hence
maintained as a weak reference.
int
PORT_GROUP_ID Weak reference to PORT_GROUP ID present in
PORT_GROUP table. This can be a null and hence
maintained as a weak reference.
int
TABLE 128 RAS_LOG
Field Definition Format Size
MSG_ID* Message ID of the event. varchar 15
MODULE_ID Module ID of the event. varchar 10
SEVERITY Severity of the event. varchar 10
CAUSE Probable root cause for the event. varchar 4096
ACTION Recommended action for the event. varchar 4096
OLD_MSG_ID Old message ID. varchar 45
TABLE 129 EVENT_NOTIFICATION
Field Definition Format Size
ID* int
STATUS Status of Event Notification. value will be 0 if disabled,
1 otherwise.
Default value is 0.
smallint
SERVER_NAME E-mail (SMTP) server name. varchar 256
REPLY_ADDRESS Reply E-mail address. varchar 50
SEND_ADDRESS E-mail address for which a Test E-mail notification is to
be sent.
varchar 512
SMTP_PORT SMTP Port number.
Default value is 25.
int
TABLE 127 EVENT (Continued)
Field Definition Format Size