Fixed bug #0000003
[public/netxms.git] / sql / policy.in
1 /*
2 ** Default event processing policy
3 **
4 ** ex: syntax=sql
5 */
6
7 INSERT INTO event_policy (rule_id,flags,comments,alarm_message,alarm_severity,alarm_key,alarm_ack_key)
8 VALUES (0,7944,'Show alarm when node status isn#27t NORMAL',
9 '%m',5,'NODE_STATUS_%i','NODE_STATUS_%i');
10 INSERT INTO event_policy (rule_id,flags,comments,alarm_message,alarm_severity,alarm_key,alarm_ack_key)
11 VALUES (1,7944,'Acknowlege node status alarms when node status changes to NORMAL',
12 '%m',6,'#00','NODE_STATUS_%i');
13 INSERT INTO event_policy (rule_id,flags,comments,alarm_message,alarm_severity,alarm_key,alarm_ack_key)
14 VALUES (2,7944,'Generate alarm when incorrect network mask detected on interface',
15 '%m',2,'BAD_NETMASK_%i_%2','BAD_NETMASK_%i_%2');
16
17 INSERT INTO policy_event_list (rule_id,event_code) VALUES (0,EVENT_NODE_WARNING);
18 INSERT INTO policy_event_list (rule_id,event_code) VALUES (0,EVENT_NODE_MINOR);
19 INSERT INTO policy_event_list (rule_id,event_code) VALUES (0,EVENT_NODE_MAJOR);
20 INSERT INTO policy_event_list (rule_id,event_code) VALUES (0,EVENT_NODE_CRITICAL);
21 INSERT INTO policy_event_list (rule_id,event_code) VALUES (0,EVENT_NODE_UNKNOWN);
22 INSERT INTO policy_event_list (rule_id,event_code) VALUES (0,EVENT_NODE_UNMANAGED);
23 INSERT INTO policy_event_list (rule_id,event_code) VALUES (1,EVENT_NODE_NORMAL);
24 INSERT INTO policy_event_list (rule_id,event_code) VALUES (2,EVENT_INCORRECT_NETMASK);