Implemented event policy saving to database
[public/netxms.git] / sql / events.in
CommitLineData
6c9e7d36
VK
1/*
2** System-defined events
b51c8c91
AK
3**
4** ex: syntax=sql
6c9e7d36 5*/
c1142e46 6
59f88625 7INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
c1142e46 8 (
3c468b80
VK
9 EVENT_NODE_ADDED, 'NX_NODE_ADDED',
10 EVENT_SEVERITY_INFO, 1,
c1142e46 11 'Node added',
77f69c9d
VK
12 'Generated when new node object added to the database.\n' CONCAT
13 'Parameters:\n' CONCAT
c1142e46
VK
14 ' No message-specific parameters'
15 );
59f88625 16INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
c1142e46 17 (
3c468b80
VK
18 EVENT_SUBNET_ADDED, 'NX_SUBNET_ADDED',
19 EVENT_SEVERITY_INFO, 0,
c1142e46 20 'Subnet added',
77f69c9d
VK
21 'Generated when new subnet object added to the database.\n' CONCAT
22 'Parameters:\n' CONCAT
c1142e46
VK
23 ' No message-specific parameters'
24 );
59f88625 25INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
c1142e46 26 (
3c468b80
VK
27 EVENT_INTERFACE_ADDED, 'NX_IF_ADDED',
28 EVENT_SEVERITY_INFO, 1,
6a402fbc 29 'Interface "%2" added (IP Addr: %3/%4, IfIndex: %5)',
77f69c9d
VK
30 'Generated when new interface object added to the database.\n' CONCAT
31 'Please note that source of event is node, not an interface itself.\n' CONCAT
32 'Parameters:\n' CONCAT
33 ' 1) Interface object ID\n' CONCAT
34 ' 2) Interface name\n' CONCAT
35 ' 3) Interface IP address\n' CONCAT
36 ' 4) Interface netmask\n' CONCAT
c1142e46
VK
37 ' 5) Interface index'
38 );
59f88625 39INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
071a9d0a 40 (
3c468b80
VK
41 EVENT_INTERFACE_UP, 'NX_IF_UP',
42 EVENT_SEVERITY_INFO, 1,
6a402fbc 43 'Interface "%2" changed state to UP (IP Addr: %3/%4, IfIndex: %5)',
77f69c9d
VK
44 'Generated when interface goes up.\n' CONCAT
45 'Please note that source of event is node, not an interface itself.\n' CONCAT
46 'Parameters:\n' CONCAT
47 ' 1) Interface object ID\n' CONCAT
48 ' 2) Interface name\n' CONCAT
49 ' 3) Interface IP address\n' CONCAT
50 ' 4) Interface netmask\n' CONCAT
071a9d0a
VK
51 ' 5) Interface index'
52 );
59f88625 53INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
071a9d0a 54 (
3c468b80
VK
55 EVENT_INTERFACE_DOWN, 'NX_IF_DOWN',
56 EVENT_SEVERITY_WARNING, 1,
6a402fbc 57 'Interface "%2" changed state to DOWN (IP Addr: %3/%4, IfIndex: %5)',
77f69c9d
VK
58 'Generated when interface goes down.\n' CONCAT
59 'Please note that source of event is node, not an interface itself.\n' CONCAT
60 'Parameters:\n' CONCAT
61 ' 1) Interface object ID\n' CONCAT
62 ' 2) Interface name\n' CONCAT
63 ' 3) Interface IP address\n' CONCAT
64 ' 4) Interface netmask\n' CONCAT
071a9d0a
VK
65 ' 5) Interface index'
66 );
59f88625 67INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
071a9d0a 68 (
3c468b80
VK
69 EVENT_NODE_NORMAL, 'NX_NODE_NORMAL',
70 EVENT_SEVERITY_INFO, 1,
071a9d0a 71 'Node status changed to NORMAL',
77f69c9d
VK
72 'Generated when node status changed to normal.\n' CONCAT
73 'Parameters:\n' CONCAT
071a9d0a
VK
74 ' 1) Previous node status'
75 );
59f88625 76INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
071a9d0a 77 (
9eb7685c
VK
78 EVENT_NODE_WARNING, 'NX_NODE_WARNING',
79 EVENT_SEVERITY_WARNING, 1,
80 'Node status changed to WARNING',
81 'Generated when node status changed to "Warning".\n' CONCAT
77f69c9d 82 'Parameters:\n' CONCAT
071a9d0a
VK
83 ' 1) Previous node status'
84 );
59f88625 85INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
071a9d0a 86 (
9eb7685c
VK
87 EVENT_NODE_MINOR, 'NX_NODE_MINOR',
88 EVENT_SEVERITY_MINOR, 1,
89 'Node status changed to MINOR',
90 'Generated when node status changed to "Minor Problem" (informational).\n' CONCAT
77f69c9d 91 'Parameters:\n' CONCAT
071a9d0a
VK
92 ' 1) Previous node status'
93 );
59f88625 94INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
071a9d0a 95 (
3c468b80
VK
96 EVENT_NODE_MAJOR, 'NX_NODE_MAJOR',
97 EVENT_SEVERITY_MAJOR, 1,
8bf20f8c 98 'Node status changed to MAJOR',
77f69c9d
VK
99 'Generated when node status changed to "Major Problem".\n' CONCAT
100 'Parameters:\n' CONCAT
071a9d0a
VK
101 ' 1) Previous node status'
102 );
59f88625 103INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
c1142e46 104 (
3c468b80
VK
105 EVENT_NODE_CRITICAL, 'NX_NODE_CRITICAL',
106 EVENT_SEVERITY_CRITICAL, 1,
071a9d0a 107 'Node status changed to CRITICAL',
77f69c9d
VK
108 'Generated when node status changed to critical.\n' CONCAT
109 'Parameters:\n' CONCAT
071a9d0a
VK
110 ' 1) Previous node status'
111 );
59f88625 112INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
071a9d0a 113 (
3c468b80
VK
114 EVENT_NODE_UNKNOWN, 'NX_NODE_UNKNOWN',
115 EVENT_SEVERITY_INFO, 1,
071a9d0a 116 'Node status changed to UNKNOWN',
77f69c9d
VK
117 'Generated when node status changed to unknown.\n' CONCAT
118 'Parameters:\n' CONCAT
071a9d0a
VK
119 ' 1) Previous node status'
120 );
59f88625 121INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
071a9d0a 122 (
3c468b80
VK
123 EVENT_NODE_UNMANAGED, 'NX_NODE_UNMANAGED',
124 EVENT_SEVERITY_INFO, 1,
071a9d0a 125 'Node status changed to UNMANAGED',
77f69c9d
VK
126 'Generated when node status changed to unmanaged.\n' CONCAT
127 'Parameters:\n' CONCAT
071a9d0a 128 ' 1) Previous node status'
c1142e46 129 );
59f88625 130INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
ba1ececc 131 (
3c468b80
VK
132 EVENT_NODE_FLAGS_CHANGED, 'NX_NODE_CAP_CHANGED',
133 EVENT_SEVERITY_INFO, 0,
ba1ececc 134 'Node capabilities changed (Old: %1; New: %2)',
77f69c9d
VK
135 'Generated when node capabilities changed.\n' CONCAT
136 'Parameters:\n' CONCAT
137 ' 1) Old capabilities' CONCAT
ba1ececc
VK
138 ' 2) New capabilities'
139 );
59f88625 140INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
ba1ececc 141 (
3c468b80
VK
142 EVENT_SNMP_FAIL, 'NX_SNMP_UNREACHEABLE',
143 EVENT_SEVERITY_INFO, 0,
ba1ececc 144 'SNMP agent is not responding',
77f69c9d
VK
145 'Generated when node''s SNMP agent is not responding.\n' CONCAT
146 'Parameters:\n' CONCAT
ba1ececc
VK
147 ' No message-specific parameters'
148 );
59f88625 149INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
ba1ececc 150 (
3c468b80
VK
151 EVENT_AGENT_FAIL, 'NX_AGENT_UNREACHEABLE',
152 EVENT_SEVERITY_INFO, 0,
ba1ececc 153 'Native agent is not responding',
77f69c9d
VK
154 'Generated when node''s native agent is not responding.\n' CONCAT
155 'Parameters:\n' CONCAT
ba1ececc
VK
156 ' No message-specific parameters'
157 );
59f88625 158INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
dfd34016 159 (
3c468b80
VK
160 EVENT_INTERFACE_DELETED, 'NX_IF_DELETED',
161 EVENT_SEVERITY_INFO, 1,
6a402fbc 162 'Interface "%2" deleted (IP Addr: %3/%4, IfIndex: %1)',
3c468b80 163 'Generated when interface object deleted from the database.\n' CONCAT
77f69c9d
VK
164 'Please note that source of event is node, not an interface itself.\n' CONCAT
165 'Parameters:\n' CONCAT
166 ' 1) Interface index\n' CONCAT
167 ' 2) Interface name\n' CONCAT
168 ' 3) Interface IP address\n' CONCAT
ac13a9dd 169 ' 4) Interface netmask'
dfd34016 170 );
2fa71464
VK
171INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
172 (
173 EVENT_THRESHOLD_REACHED, 'NX_THRESHOLD_REACHED',
174 EVENT_SEVERITY_WARNING, 1,
175 'Threshold reached for parameter %1 (Threshold value: %2; Actual value: %3)',
176 'Generated when threshold value reached for specific data collection item.\n' CONCAT
177 'Parameters:\n' CONCAT
178 ' 1) Item name\n' CONCAT
179 ' 2) Threshold value\n' CONCAT
180 ' 3) Actual value'
181 );
182INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
183 (
184 EVENT_THRESHOLD_REARMED, 'NX_THRESHOLD_REARMED',
185 EVENT_SEVERITY_INFO, 0,
186 'Threshold rearmed for parameter %1',
187 'Generated when threshold check is rearmed for specific data collection item.\n' CONCAT
188 'Parameters:\n' CONCAT
189 ' 1) Item name'
190 );
191INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
192 (
193 EVENT_SUBNET_DELETED, 'NX_SUBNET_DELETED',
194 EVENT_SEVERITY_INFO, 0,
195 'Subnet deleted',
196 'Generated when subnet object deleted from the database.\n' CONCAT
197 'Parameters:\n' CONCAT
198 ' No message-specific parameters'
199 );
59f88625 200INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
6a402fbc 201 (
3c468b80
VK
202 EVENT_THREAD_HANGS, 'NX_SYS_THREAD_HANG',
203 EVENT_SEVERITY_CRITICAL, 1,
6a402fbc 204 'Thread "%1" is not responding',
77f69c9d
VK
205 'Generated when one of the system threads hangs or stops unexpectedly.\n' CONCAT
206 'Parameters:\n' CONCAT
6a402fbc
VK
207 ' 1) Thread name'
208 );