Brocade Network Advisor IP User Manual v12.1.0 - Manual (Page 1510)

1456 Brocade Network Advisor IP User Manual
53-1002947-01
Database tables and fields
I
USER_NAME Captures the user information from audit Syslog
messages. Varchar 512
PORT_NAME Shows the PortName for the corresponding port. Varchar 255
MAC_ADDRESS 'Indicates the MAC address of the Access Point from
which this event is received. If the event is received
from the wireless controller or any other products, this
will be empty.'; varchar 64
TABLE 187 EVENT_INSTANCE
Field Definition Format Size
ID Unique generated database identifier. int
EVENT_POLICY_ID Foreign Key to Event_Policy Table int
EVENT_KEY A String Key string which identifies a specific instance
of an Event. varchar 64
STRING_PATTERN A Regular expression pattern string which can be used
to match an Event instance. varchar 1024
CATEGORY A small integer which identifies the Category of an
Event instance.
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.
The default value is 0. smallint
SEVERITY The Severity of the Event that is logged per Event
Policy
0- Unknown 1- Emergency 2- Alert 3- Critical 4- Error
5- Warning 6- Notice 7- Info 8- Debug.
The default value is 0. smallint
SEQUENCE_NUMBER The sequence number of an event instance that''s
specific to the policy.
The default value is 0. smallint
MSG_IDS Stores the Message ID(s) configured for Custom Event
Type varchar 512
TABLE 188 EVENT_POLICY_SOURCE_ENTRY
Field Definition Format Size
ID Unique generated database identifier. int
EVENT_POLICY_ID Foreign Key to Event_Policy Table int
MANAGEMENT_ELEMENT_ID A soft reference key to the Management Element ID.
Do not maintain it as a foreign key constraints.
The default value is 0.
int
INTERFACE_ID A soft reference key to the Interface ID. Do not
maintain it as a foreign key constraints.
The default value is 0. int
TABLE 186 EVENT_DETAILS (Continued)
Field Definition Format Size