User's Manual

1426 Brocade Network Advisor IP User Manual
53-1003056-01
Database tables and fields
I
STATUS Administrative status of the Event Policy
0 - disabled 1- enabled
smallint
LAST_MODIFIED_TIME 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';
timestamp
SEVERITY The Event Policy Sub Type
Escalation (0), Resolving (1), Flapping (2),Repeating
(3).
The default value is 0.
smallint
MESSAGE varchar 256
SUB_TYPE The Event Policy Sub Type
Escalation (0), Resolving (1), Flapping (2),Repeating
(3)
smallint
EVENT_ORIGIN 0- SNMP Trap 1- Application Event 2- Pseudo Event 3-
Snort 4- Pseudo Event 5- Custom Event
smallint
PROPERTIES The property string which is used to define various
parameters that are associated with an Event Policy
such as flapping time and durations etc
varchar 2048
TABLE 123 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
DEVICE_GROUP_ID A reference key to the Device Group
Do not maintain it as a foreign key constraints.
The default value is 0.
int
PORT_GROUP_ID A reference key to the Port Group
Do not maintain it as a foreign key constraints.
The default value is 0.
int
SOURCE_SELECTION_TYPE Option selected to give Source Information
• 0- IPAddress/Node wwn/Name provided
• 1- Source selected from available list of
sources.
The default value is 0.
smallint
IP_ADDRESS IP address of source varchar 1024
TABLE 122 EVENT_POLICY (Continued)
Field Definition Format Size