- Implemented interface for SMS drivers
[public/netxms.git] / sql / events.in
1 /*
2 ** System-defined events
3 **
4 ** ex: syntax=sql
5 */
6
7 #define THRESHOLD_EVENT_PARAMS \
8 ' 1) Parameter name#0D#0A 2) Item description#0D#0A 3) Threshold value#0D#0A 4) Actual value#0D#0A 5) Data collection item ID#0D#0A 6) Instance'
9
10
11 /*
12 ** System events
13 */
14
15 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
16 (
17 EVENT_NODE_ADDED, 'SYS_NODE_ADDED',
18 EVENT_SEVERITY_NORMAL, 1,
19 'Node added',
20 'Generated when new node object added to the database.#0D#0A' CONCAT
21 'Parameters:#0D#0A' CONCAT
22 ' No message-specific parameters'
23 );
24 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
25 (
26 EVENT_SUBNET_ADDED, 'SYS_SUBNET_ADDED',
27 EVENT_SEVERITY_NORMAL, 0,
28 'Subnet added',
29 'Generated when new subnet object added to the database.#0D#0A' CONCAT
30 'Parameters:#0D#0A' CONCAT
31 ' No message-specific parameters'
32 );
33 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
34 (
35 EVENT_INTERFACE_ADDED, 'SYS_IF_ADDED',
36 EVENT_SEVERITY_NORMAL, 1,
37 'Interface "%2" added (IP Addr: %3/%4, IfIndex: %5)',
38 'Generated when new interface object added to the database.#0D#0A' CONCAT
39 'Please note that source of event is node, not an interface itself.#0D#0A' CONCAT
40 'Parameters:#0D#0A' CONCAT
41 ' 1) Interface object ID#0D#0A' CONCAT
42 ' 2) Interface name#0D#0A' CONCAT
43 ' 3) Interface IP address#0D#0A' CONCAT
44 ' 4) Interface netmask#0D#0A' CONCAT
45 ' 5) Interface index'
46 );
47 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
48 (
49 EVENT_INTERFACE_UP, 'SYS_IF_UP',
50 EVENT_SEVERITY_NORMAL, 1,
51 'Interface "%2" changed state to UP (IP Addr: %3/%4, IfIndex: %5)',
52 'Generated when interface goes up.#0D#0A' CONCAT
53 'Please note that source of event is node, not an interface itself.#0D#0A' CONCAT
54 'Parameters:#0D#0A' CONCAT
55 ' 1) Interface object ID#0D#0A' CONCAT
56 ' 2) Interface name#0D#0A' CONCAT
57 ' 3) Interface IP address#0D#0A' CONCAT
58 ' 4) Interface netmask#0D#0A' CONCAT
59 ' 5) Interface index'
60 );
61 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
62 (
63 EVENT_INTERFACE_DOWN, 'SYS_IF_DOWN',
64 EVENT_SEVERITY_WARNING, 1,
65 'Interface "%2" changed state to DOWN (IP Addr: %3/%4, IfIndex: %5)',
66 'Generated when interface goes down.#0D#0A' CONCAT
67 'Please note that source of event is node, not an interface itself.#0D#0A' CONCAT
68 'Parameters:#0D#0A' CONCAT
69 ' 1) Interface object ID#0D#0A' CONCAT
70 ' 2) Interface name#0D#0A' CONCAT
71 ' 3) Interface IP address#0D#0A' CONCAT
72 ' 4) Interface netmask#0D#0A' CONCAT
73 ' 5) Interface index'
74 );
75 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
76 (
77 EVENT_NODE_NORMAL, 'SYS_NODE_NORMAL',
78 EVENT_SEVERITY_NORMAL, 1,
79 'Node status changed to NORMAL',
80 'Generated when node status changed to normal.#0D#0A' CONCAT
81 'Parameters:#0D#0A' CONCAT
82 ' 1) Previous node status'
83 );
84 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
85 (
86 EVENT_NODE_WARNING, 'SYS_NODE_WARNING',
87 EVENT_SEVERITY_WARNING, 1,
88 'Node status changed to WARNING',
89 'Generated when node status changed to "Warning".#0D#0A' CONCAT
90 'Parameters:#0D#0A' CONCAT
91 ' 1) Previous node status'
92 );
93 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
94 (
95 EVENT_NODE_MINOR, 'SYS_NODE_MINOR',
96 EVENT_SEVERITY_MINOR, 1,
97 'Node status changed to MINOR',
98 'Generated when node status changed to "Minor Problem" (informational).#0D#0A' CONCAT
99 'Parameters:#0D#0A' CONCAT
100 ' 1) Previous node status'
101 );
102 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
103 (
104 EVENT_NODE_MAJOR, 'SYS_NODE_MAJOR',
105 EVENT_SEVERITY_MAJOR, 1,
106 'Node status changed to MAJOR',
107 'Generated when node status changed to "Major Problem".#0D#0A' CONCAT
108 'Parameters:#0D#0A' CONCAT
109 ' 1) Previous node status'
110 );
111 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
112 (
113 EVENT_NODE_CRITICAL, 'SYS_NODE_CRITICAL',
114 EVENT_SEVERITY_CRITICAL, 1,
115 'Node status changed to CRITICAL',
116 'Generated when node status changed to critical.#0D#0A' CONCAT
117 'Parameters:#0D#0A' CONCAT
118 ' 1) Previous node status'
119 );
120 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
121 (
122 EVENT_NODE_UNKNOWN, 'SYS_NODE_UNKNOWN',
123 EVENT_SEVERITY_NORMAL, 1,
124 'Node status changed to UNKNOWN',
125 'Generated when node status changed to unknown.#0D#0A' CONCAT
126 'Parameters:#0D#0A' CONCAT
127 ' 1) Previous node status'
128 );
129 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
130 (
131 EVENT_NODE_UNMANAGED, 'SYS_NODE_UNMANAGED',
132 EVENT_SEVERITY_NORMAL, 1,
133 'Node status changed to UNMANAGED',
134 'Generated when node status changed to unmanaged.#0D#0A' CONCAT
135 'Parameters:#0D#0A' CONCAT
136 ' 1) Previous node status'
137 );
138 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
139 (
140 EVENT_NODE_FLAGS_CHANGED, 'SYS_NODE_CAP_CHANGED',
141 EVENT_SEVERITY_NORMAL, 0,
142 'Node capabilities changed (Old: %1; New: %2)',
143 'Generated when node capabilities changed.#0D#0A' CONCAT
144 'Parameters:#0D#0A' CONCAT
145 ' 1) Old capabilities#0D#0A' CONCAT
146 ' 2) New capabilities'
147 );
148 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
149 (
150 EVENT_SNMP_FAIL, 'SYS_SNMP_UNREACHEABLE',
151 EVENT_SEVERITY_WARNING, 0,
152 'SNMP agent is not responding',
153 'Generated when node#27s SNMP agent is not responding.#0D#0A' CONCAT
154 'Parameters:#0D#0A' CONCAT
155 ' No message-specific parameters'
156 );
157 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
158 (
159 EVENT_AGENT_FAIL, 'SYS_AGENT_UNREACHEABLE',
160 EVENT_SEVERITY_WARNING, 0,
161 'Native agent is not responding',
162 'Generated when node#27s native agent is not responding.#0D#0A' CONCAT
163 'Parameters:#0D#0A' CONCAT
164 ' No message-specific parameters'
165 );
166 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
167 (
168 EVENT_INTERFACE_DELETED, 'SYS_IF_DELETED',
169 EVENT_SEVERITY_NORMAL, 1,
170 'Interface "%2" deleted (IP Addr: %3/%4, IfIndex: %1)',
171 'Generated when interface object deleted from the database.#0D#0A' CONCAT
172 'Please note that source of event is node, not an interface itself.#0D#0A' CONCAT
173 'Parameters:#0D#0A' CONCAT
174 ' 1) Interface index#0D#0A' CONCAT
175 ' 2) Interface name#0D#0A' CONCAT
176 ' 3) Interface IP address#0D#0A' CONCAT
177 ' 4) Interface netmask'
178 );
179 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
180 (
181 EVENT_THRESHOLD_REACHED, 'SYS_THRESHOLD_REACHED',
182 EVENT_SEVERITY_WARNING, 1,
183 'Threshold reached for data collection item #22%2#22 (Parameter: %1; Threshold value: %3; Actual value: %4)',
184 'Generated when threshold value reached for specific data collection item.#0D#0A' CONCAT
185 'Parameters:#0D#0A' CONCAT
186 THRESHOLD_EVENT_PARAMS
187 );
188 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
189 (
190 EVENT_THRESHOLD_REARMED, 'SYS_THRESHOLD_REARMED',
191 EVENT_SEVERITY_NORMAL, 1,
192 'Threshold rearmed for data collection item %2 (Parameter: %1)',
193 'Generated when threshold check is rearmed for specific data collection item.#0D#0A' CONCAT
194 'Parameters:#0D#0A' CONCAT
195 ' 1) Parameter name#0D#0A' CONCAT
196 ' 2) Item description#0D#0A' CONCAT
197 ' 3) Data collection item ID'
198 );
199 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
200 (
201 EVENT_SUBNET_DELETED, 'SYS_SUBNET_DELETED',
202 EVENT_SEVERITY_NORMAL, 0,
203 'Subnet deleted',
204 'Generated when subnet object deleted from the database.#0D#0A' CONCAT
205 'Parameters:#0D#0A' CONCAT
206 ' No message-specific parameters'
207 );
208 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
209 (
210 EVENT_THREAD_HANGS, 'SYS_THREAD_HANG',
211 EVENT_SEVERITY_CRITICAL, 1,
212 'Thread "%1" is not responding',
213 'Generated when one of the system threads hangs or stops unexpectedly.#0D#0A' CONCAT
214 'Parameters:#0D#0A' CONCAT
215 ' 1) Thread name'
216 );
217 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
218 (
219 EVENT_THREAD_RUNNING, 'SYS_THREAD_RUNNING',
220 EVENT_SEVERITY_NORMAL, 1,
221 'Thread "%1" was returned to running state',
222 'Generated when one of the system threads which previously hangs or stops unexpectedly was returned to running state.#0D#0A' CONCAT
223 'Parameters:#0D#0A' CONCAT
224 ' 1) Thread name'
225 );
226 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
227 (
228 EVENT_SMTP_FAILURE, 'SYS_SMTP_FAILURE',
229 EVENT_SEVERITY_WARNING, 1,
230 'Unable to send e-mail to <%3>: %2',
231 'Generated when server is unable to send e-mail.#0D#0A' CONCAT
232 'Parameters:#0D#0A' CONCAT
233 ' 1) Error code#0D#0A' CONCAT
234 ' 2) Error text#0D#0A' CONCAT
235 ' 3) Recipient address#0D#0A' CONCAT
236 ' 4) Mail subject'
237 );
238 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
239 (
240 EVENT_MAC_ADDR_CHANGED, 'SYS_MAC_ADDR_CHANGED',
241 EVENT_SEVERITY_WARNING, 1,
242 'MAC address for interface %3 changed from %4 to %5',
243 'Generated when server detects change of interface#27s MAC address.#0D#0A' CONCAT
244 'Parameters:#0D#0A' CONCAT
245 ' 1) Interface object ID#0D#0A' CONCAT
246 ' 2) Interface index#0D#0A' CONCAT
247 ' 3) Interface name#0D#0A' CONCAT
248 ' 4) Old MAC address#0D#0A' CONCAT
249 ' 5) New MAC address'
250 );
251 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
252 (
253 EVENT_INCORRECT_NETMASK, 'SYS_INCORRECT_NETMASK',
254 EVENT_SEVERITY_MINOR, 1,
255 'Invalid network mask %4 on interface "%3", should be %5',
256 'Generated when server detects invalid network mask on an interface.#0D#0A' CONCAT
257 'Parameters:#0D#0A' CONCAT
258 ' 1) Interface object ID#0D#0A' CONCAT
259 ' 2) Interface index#0D#0A' CONCAT
260 ' 3) Interface name#0D#0A' CONCAT
261 ' 4) Actual network mask on interface#0D#0A' CONCAT
262 ' 5) Correct network mask'
263 );
264 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
265 (
266 EVENT_NODE_DOWN, 'SYS_NODE_DOWN',
267 EVENT_SEVERITY_CRITICAL, 1,
268 'Node down',
269 'Generated when node is not responding to management server.#0D#0A' CONCAT
270 'Parameters:#0D#0A' CONCAT
271 ' No event-specific parameters'
272 );
273 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
274 (
275 EVENT_NODE_UP, 'SYS_NODE_UP',
276 EVENT_SEVERITY_NORMAL, 1,
277 'Node up',
278 'Generated when communication with the node re-established.#0D#0A' CONCAT
279 'Parameters:#0D#0A' CONCAT
280 ' No event-specific parameters'
281 );
282 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
283 (
284 EVENT_SERVICE_DOWN, 'SYS_SERVICE_DOWN',
285 EVENT_SEVERITY_MAJOR, 1,
286 'Network service "%1" is not responding',
287 'Generated when network service is not responding to management server as expected.#0D#0A' CONCAT
288 'Parameters:#0D#0A' CONCAT
289 ' 1) Service name#0D0A' CONCAT
290 ' 2) Service object ID#0D0A' CONCAT
291 ' 3) Service type'
292 );
293 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
294 (
295 EVENT_SERVICE_UP, 'SYS_SERVICE_UP',
296 EVENT_SEVERITY_NORMAL, 1,
297 'Network service "%1" returned to operational state',
298 'Generated when network service responds as expected after failure.#0D#0A' CONCAT
299 'Parameters:#0D#0A' CONCAT
300 ' 1) Service name#0D0A' CONCAT
301 ' 2) Service object ID#0D0A' CONCAT
302 ' 3) Service type'
303 );
304 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
305 (
306 EVENT_SERVICE_UNKNOWN, 'SYS_SERVICE_UNKNOWN',
307 EVENT_SEVERITY_WARNING, 1,
308 'Status of network service "%1" is unknown',
309 'Generated when management server is unable to determine state of the network service due to agent or server-to-agent communication failure.#0D#0A' CONCAT
310 'Parameters:#0D#0A' CONCAT
311 ' 1) Service name#0D0A' CONCAT
312 ' 2) Service object ID#0D0A' CONCAT
313 ' 3) Service type'
314 );
315 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
316 (
317 EVENT_SMS_FAILURE, 'SYS_SMS_FAILURE',
318 EVENT_SEVERITY_WARNING, 1,
319 'Unable to send SMS to phone %1',
320 'Generated when server is unable to send SMS.#0D#0A' CONCAT
321 'Parameters:#0D#0A' CONCAT
322 ' 1) Phone number'
323 );
324
325
326 /*
327 ** SNMP traps
328 */
329
330 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
331 (
332 EVENT_SNMP_UNMATCHED_TRAP, 'SNMP_UNMATCHED_TRAP',
333 EVENT_SEVERITY_NORMAL, 1,
334 'SNMP trap received: %1 (Parameters: %2)',
335 'Generated when system receives an SNMP trap without match in trap configuration table#0D#0A' CONCAT
336 'Parameters:#0D#0A' CONCAT
337 ' 1) SNMP trap OID#0D#0A' CONCAT
338 ' 2) Trap parameters'
339 );
340 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
341 (
342 EVENT_SNMP_COLD_START, 'SNMP_COLD_START',
343 EVENT_SEVERITY_NORMAL, 1,
344 'System was cold-started',
345 'Generated when system receives a coldStart SNMP trap#0D#0A' CONCAT
346 'Parameters:#0D#0A' CONCAT
347 ' 1) SNMP trap OID'
348 );
349 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
350 (
351 EVENT_SNMP_WARM_START, 'SNMP_WARM_START',
352 EVENT_SEVERITY_NORMAL, 1,
353 'System was warm-started',
354 'Generated when system receives a warmStart SNMP trap#0D#0A' CONCAT
355 'Parameters:#0D#0A' CONCAT
356 ' 1) SNMP trap OID'
357 );
358 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
359 (
360 EVENT_SNMP_LINK_DOWN, 'SNMP_LINK_DOWN',
361 EVENT_SEVERITY_MAJOR, 1,
362 'Link is down (interface index %2)',
363 'Generated when system receives a linkDown SNMP trap#0D#0A' CONCAT
364 'Parameters:#0D#0A' CONCAT
365 ' 1) SNMP trap OID#0D#0A' CONCAT
366 ' 2) Interface index'
367 );
368 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
369 (
370 EVENT_SNMP_LINK_UP, 'SNMP_LINK_UP',
371 EVENT_SEVERITY_NORMAL, 1,
372 'Link is up (interface index %2)',
373 'Generated when system receives a linkUp SNMP trap#0D#0A' CONCAT
374 'Parameters:#0D#0A' CONCAT
375 ' 1) SNMP trap OID#0D#0A' CONCAT
376 ' 2) Interface index'
377 );
378 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
379 (
380 EVENT_SNMP_AUTH_FAILURE, 'SNMP_AUTH_FAILURE',
381 EVENT_SEVERITY_WARNING, 1,
382 'SNMP authentication failure',
383 'Generated when system receives an authenticationFailure SNMP trap#0D#0A' CONCAT
384 'Parameters:#0D#0A' CONCAT
385 ' 1) SNMP trap OID'
386 );
387 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
388 (
389 EVENT_SNMP_EGP_NL, 'SNMP_EGP_NEIGHBOR_LOSS',
390 EVENT_SEVERITY_WARNING, 1,
391 'EGP neighbor loss',
392 'Generated when system receives an egpNeighborLoss SNMP trap#0D#0A' CONCAT
393 'Parameters:#0D#0A' CONCAT
394 ' 1) SNMP trap OID'
395 );
396
397
398 /*
399 ** Following is a set of predefined events for thresholds
400 ** These events can occupy ID space 4000 ... 4999
401 */
402
403 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
404 (
405 4000, 'DC_HIGH_CPU_UTIL',
406 EVENT_SEVERITY_MINOR, 1,
407 'CPU utilization exceeds allowed maximum of %3 (Current: %4)',
408 'Custom data collection threshold event.#0D#0A' CONCAT
409 'Parameters:#0D#0A' CONCAT
410 THRESHOLD_EVENT_PARAMS
411 );
412 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
413 (
414 4001, 'DC_HIGH_PROCLOAD',
415 EVENT_SEVERITY_MINOR, 1,
416 'Processor load average exceeds allowed maximum of %3 (Current: %4)',
417 'Custom data collection threshold event.#0D#0A' CONCAT
418 'Parameters:#0D#0A' CONCAT
419 THRESHOLD_EVENT_PARAMS
420 );
421 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
422 (
423 4002, 'DC_HOST_RESTARTED',
424 EVENT_SEVERITY_NORMAL, 1,
425 'Host was restarted within last 5 minutes',
426 'Custom data collection threshold event.#0D#0A' CONCAT
427 'Parameters:#0D#0A' CONCAT
428 THRESHOLD_EVENT_PARAMS
429 );
430 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
431 (
432 4003, 'DC_AGENT_RESTARTED',
433 EVENT_SEVERITY_NORMAL, 1,
434 'NetXMS agent was restarted within last 5 minutes',
435 'Custom data collection threshold event.#0D#0A' CONCAT
436 'Parameters:#0D#0A' CONCAT
437 THRESHOLD_EVENT_PARAMS
438 );
439 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
440 (
441 4004, 'DC_SERVICE_NOT_RUNNING',
442 EVENT_SEVERITY_MAJOR, 1,
443 'Service #22%6#22 is not running',
444 'Custom data collection threshold event.#0D#0A' CONCAT
445 'Parameters:#0D#0A' CONCAT
446 THRESHOLD_EVENT_PARAMS
447 );
448 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
449 (
450 4005, 'DC_MAILBOX_TOO_LARGE',
451 EVENT_SEVERITY_WARNING, 1,
452 'Mailbox #22%6#22 exceeds size limit (allowed size: %3; actual size: %4)',
453 'Custom data collection threshold event.#0D#0A' CONCAT
454 'Parameters:#0D#0A' CONCAT
455 THRESHOLD_EVENT_PARAMS
456 );
457 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
458 (
459 4006, 'DC_AGENT_VERSION_CHANGE',
460 EVENT_SEVERITY_NORMAL, 1,
461 'NetXMS agent version was changed from %3 to %4',
462 'Custom data collection threshold event.#0D#0A' CONCAT
463 'Parameters:#0D#0A' CONCAT
464 THRESHOLD_EVENT_PARAMS
465 );
466 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
467 (
468 4007, 'DC_HOSTNAME_CHANGE',
469 EVENT_SEVERITY_WARNING, 1,
470 'Host name was changed from %3 to %4',
471 'Custom data collection threshold event.#0D#0A' CONCAT
472 'Parameters:#0D#0A' CONCAT
473 THRESHOLD_EVENT_PARAMS
474 );
475 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
476 (
477 4008, 'DC_FILE_CHANGE',
478 EVENT_SEVERITY_WARNING, 1,
479 'File #22%6#22 was changed',
480 'Custom data collection threshold event.#0D#0A' CONCAT
481 'Parameters:#0D#0A' CONCAT
482 THRESHOLD_EVENT_PARAMS
483 );