- Starting version 0.1.6
[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
b900a78b
VK
7#define THRESHOLD_EVENT_PARAMS \
8 ' 1) Parameter name#0D#0A 2) Item description#0D#0A 3) Threshold value#0D#0A 4) Actual value'
9
10
11/*
12** System events
13*/
14
59f88625 15INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
c1142e46 16 (
333ece94
VK
17 EVENT_NODE_ADDED, 'SYS_NODE_ADDED',
18 EVENT_SEVERITY_NORMAL, 1,
c1142e46 19 'Node added',
e42108f0
VK
20 'Generated when new node object added to the database.#0D#0A' CONCAT
21 'Parameters:#0D#0A' CONCAT
c1142e46
VK
22 ' No message-specific parameters'
23 );
59f88625 24INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
c1142e46 25 (
333ece94
VK
26 EVENT_SUBNET_ADDED, 'SYS_SUBNET_ADDED',
27 EVENT_SEVERITY_NORMAL, 0,
c1142e46 28 'Subnet added',
e42108f0
VK
29 'Generated when new subnet object added to the database.#0D#0A' CONCAT
30 'Parameters:#0D#0A' CONCAT
c1142e46
VK
31 ' No message-specific parameters'
32 );
59f88625 33INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
c1142e46 34 (
333ece94
VK
35 EVENT_INTERFACE_ADDED, 'SYS_IF_ADDED',
36 EVENT_SEVERITY_NORMAL, 1,
6a402fbc 37 'Interface "%2" added (IP Addr: %3/%4, IfIndex: %5)',
e42108f0
VK
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
c1142e46
VK
45 ' 5) Interface index'
46 );
59f88625 47INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
071a9d0a 48 (
333ece94
VK
49 EVENT_INTERFACE_UP, 'SYS_IF_UP',
50 EVENT_SEVERITY_NORMAL, 1,
6a402fbc 51 'Interface "%2" changed state to UP (IP Addr: %3/%4, IfIndex: %5)',
e42108f0
VK
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
071a9d0a
VK
59 ' 5) Interface index'
60 );
59f88625 61INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
071a9d0a 62 (
333ece94 63 EVENT_INTERFACE_DOWN, 'SYS_IF_DOWN',
3c468b80 64 EVENT_SEVERITY_WARNING, 1,
6a402fbc 65 'Interface "%2" changed state to DOWN (IP Addr: %3/%4, IfIndex: %5)',
e42108f0
VK
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
071a9d0a
VK
73 ' 5) Interface index'
74 );
59f88625 75INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
071a9d0a 76 (
333ece94
VK
77 EVENT_NODE_NORMAL, 'SYS_NODE_NORMAL',
78 EVENT_SEVERITY_NORMAL, 1,
071a9d0a 79 'Node status changed to NORMAL',
e42108f0
VK
80 'Generated when node status changed to normal.#0D#0A' CONCAT
81 'Parameters:#0D#0A' CONCAT
071a9d0a
VK
82 ' 1) Previous node status'
83 );
59f88625 84INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
071a9d0a 85 (
333ece94 86 EVENT_NODE_WARNING, 'SYS_NODE_WARNING',
9eb7685c
VK
87 EVENT_SEVERITY_WARNING, 1,
88 'Node status changed to WARNING',
e42108f0
VK
89 'Generated when node status changed to "Warning".#0D#0A' CONCAT
90 'Parameters:#0D#0A' CONCAT
071a9d0a
VK
91 ' 1) Previous node status'
92 );
59f88625 93INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
071a9d0a 94 (
333ece94 95 EVENT_NODE_MINOR, 'SYS_NODE_MINOR',
9eb7685c
VK
96 EVENT_SEVERITY_MINOR, 1,
97 'Node status changed to MINOR',
e42108f0
VK
98 'Generated when node status changed to "Minor Problem" (informational).#0D#0A' CONCAT
99 'Parameters:#0D#0A' CONCAT
071a9d0a
VK
100 ' 1) Previous node status'
101 );
59f88625 102INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
071a9d0a 103 (
333ece94 104 EVENT_NODE_MAJOR, 'SYS_NODE_MAJOR',
3c468b80 105 EVENT_SEVERITY_MAJOR, 1,
8bf20f8c 106 'Node status changed to MAJOR',
e42108f0
VK
107 'Generated when node status changed to "Major Problem".#0D#0A' CONCAT
108 'Parameters:#0D#0A' CONCAT
071a9d0a
VK
109 ' 1) Previous node status'
110 );
59f88625 111INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
c1142e46 112 (
333ece94 113 EVENT_NODE_CRITICAL, 'SYS_NODE_CRITICAL',
3c468b80 114 EVENT_SEVERITY_CRITICAL, 1,
071a9d0a 115 'Node status changed to CRITICAL',
e42108f0
VK
116 'Generated when node status changed to critical.#0D#0A' CONCAT
117 'Parameters:#0D#0A' CONCAT
071a9d0a
VK
118 ' 1) Previous node status'
119 );
59f88625 120INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
071a9d0a 121 (
333ece94
VK
122 EVENT_NODE_UNKNOWN, 'SYS_NODE_UNKNOWN',
123 EVENT_SEVERITY_NORMAL, 1,
071a9d0a 124 'Node status changed to UNKNOWN',
e42108f0
VK
125 'Generated when node status changed to unknown.#0D#0A' CONCAT
126 'Parameters:#0D#0A' CONCAT
071a9d0a
VK
127 ' 1) Previous node status'
128 );
59f88625 129INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
071a9d0a 130 (
333ece94
VK
131 EVENT_NODE_UNMANAGED, 'SYS_NODE_UNMANAGED',
132 EVENT_SEVERITY_NORMAL, 1,
071a9d0a 133 'Node status changed to UNMANAGED',
e42108f0
VK
134 'Generated when node status changed to unmanaged.#0D#0A' CONCAT
135 'Parameters:#0D#0A' CONCAT
071a9d0a 136 ' 1) Previous node status'
c1142e46 137 );
59f88625 138INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
ba1ececc 139 (
333ece94
VK
140 EVENT_NODE_FLAGS_CHANGED, 'SYS_NODE_CAP_CHANGED',
141 EVENT_SEVERITY_NORMAL, 0,
ba1ececc 142 'Node capabilities changed (Old: %1; New: %2)',
e42108f0
VK
143 'Generated when node capabilities changed.#0D#0A' CONCAT
144 'Parameters:#0D#0A' CONCAT
145 ' 1) Old capabilities#0D#0A' CONCAT
ba1ececc
VK
146 ' 2) New capabilities'
147 );
59f88625 148INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
ba1ececc 149 (
333ece94
VK
150 EVENT_SNMP_FAIL, 'SYS_SNMP_UNREACHEABLE',
151 EVENT_SEVERITY_NORMAL, 0,
ba1ececc 152 'SNMP agent is not responding',
e42108f0
VK
153 'Generated when node#27s SNMP agent is not responding.#0D#0A' CONCAT
154 'Parameters:#0D#0A' CONCAT
ba1ececc
VK
155 ' No message-specific parameters'
156 );
59f88625 157INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
ba1ececc 158 (
333ece94
VK
159 EVENT_AGENT_FAIL, 'SYS_AGENT_UNREACHEABLE',
160 EVENT_SEVERITY_NORMAL, 0,
ba1ececc 161 'Native agent is not responding',
e42108f0
VK
162 'Generated when node#27s native agent is not responding.#0D#0A' CONCAT
163 'Parameters:#0D#0A' CONCAT
ba1ececc
VK
164 ' No message-specific parameters'
165 );
59f88625 166INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
dfd34016 167 (
333ece94
VK
168 EVENT_INTERFACE_DELETED, 'SYS_IF_DELETED',
169 EVENT_SEVERITY_NORMAL, 1,
6a402fbc 170 'Interface "%2" deleted (IP Addr: %3/%4, IfIndex: %1)',
e42108f0
VK
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
ac13a9dd 177 ' 4) Interface netmask'
dfd34016 178 );
2fa71464
VK
179INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
180 (
333ece94 181 EVENT_THRESHOLD_REACHED, 'SYS_THRESHOLD_REACHED',
2fa71464 182 EVENT_SEVERITY_WARNING, 1,
b900a78b 183 'Threshold reached for data collection item #22%2#22 (Parameter: %1; Threshold value: %3; Actual value: %4)',
e42108f0
VK
184 'Generated when threshold value reached for specific data collection item.#0D#0A' CONCAT
185 'Parameters:#0D#0A' CONCAT
b900a78b 186 THRESHOLD_EVENT_PARAMS
2fa71464
VK
187 );
188INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
189 (
333ece94
VK
190 EVENT_THRESHOLD_REARMED, 'SYS_THRESHOLD_REARMED',
191 EVENT_SEVERITY_NORMAL, 0,
b900a78b 192 'Threshold rearmed for data collection item %2 (Parameter: %1)',
e42108f0
VK
193 'Generated when threshold check is rearmed for specific data collection item.#0D#0A' CONCAT
194 'Parameters:#0D#0A' CONCAT
b900a78b
VK
195 ' 1) Parameter name#0D#0A' CONCAT
196 ' 2) Item description'
2fa71464
VK
197 );
198INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
199 (
333ece94
VK
200 EVENT_SUBNET_DELETED, 'SYS_SUBNET_DELETED',
201 EVENT_SEVERITY_NORMAL, 0,
2fa71464 202 'Subnet deleted',
e42108f0
VK
203 'Generated when subnet object deleted from the database.#0D#0A' CONCAT
204 'Parameters:#0D#0A' CONCAT
2fa71464
VK
205 ' No message-specific parameters'
206 );
59f88625 207INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
6a402fbc 208 (
333ece94 209 EVENT_THREAD_HANGS, 'SYS_THREAD_HANG',
3c468b80 210 EVENT_SEVERITY_CRITICAL, 1,
6a402fbc 211 'Thread "%1" is not responding',
e42108f0
VK
212 'Generated when one of the system threads hangs or stops unexpectedly.#0D#0A' CONCAT
213 'Parameters:#0D#0A' CONCAT
6a402fbc
VK
214 ' 1) Thread name'
215 );
a97797f8
VK
216INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
217 (
333ece94
VK
218 EVENT_THREAD_RUNNING, 'SYS_THREAD_RUNNING',
219 EVENT_SEVERITY_NORMAL, 1,
a97797f8
VK
220 'Thread "%1" was returned to running state',
221 'Generated when one of the system threads which previously hangs or stops unexpectedly was returned to running state.#0D#0A' CONCAT
222 'Parameters:#0D#0A' CONCAT
223 ' 1) Thread name'
224 );
b86ba1c0
VK
225INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
226 (
333ece94 227 EVENT_SMTP_FAILURE, 'SYS_SMTP_FAILURE',
b86ba1c0
VK
228 EVENT_SEVERITY_WARNING, 1,
229 'Unable to send e-mail to <%3>: %2',
230 'Generated when server is unable to send e-mail.#0D#0A' CONCAT
231 'Parameters:#0D#0A' CONCAT
232 ' 1) Error code#0D#0A' CONCAT
233 ' 2) Error text#0D#0A' CONCAT
234 ' 3) Recipient address#0D#0A' CONCAT
235 ' 4) Mail subject'
236 );
b50f1100
VK
237INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
238 (
239 EVENT_MAC_ADDR_CHANGED, 'SYS_MAC_ADDR_CHANGED',
240 EVENT_SEVERITY_WARNING, 1,
241 'MAC address for interface %3 changed from %4 to %5',
242 'Generated when server detects change of interface#27s MAC address.#0D#0A' CONCAT
243 'Parameters:#0D#0A' CONCAT
244 ' 1) Interface object ID#0D#0A' CONCAT
245 ' 2) Interface index#0D#0A' CONCAT
246 ' 3) Interface name#0D#0A' CONCAT
247 ' 4) Old MAC address#0D#0A' CONCAT
248 ' 5) New MAC address'
249 );
28fbe2be
VK
250INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
251 (
252 EVENT_INCORRECT_NETMASK, 'SYS_INCORRECT_NETMASK',
253 EVENT_SEVERITY_MINOR, 1,
205acaf4 254 'Invalid network mask %4 on interface "%3", should be %5',
28fbe2be
VK
255 'Generated when server detects invalid network mask on an interface.#0D#0A' CONCAT
256 'Parameters:#0D#0A' CONCAT
257 ' 1) Interface object ID#0D#0A' CONCAT
258 ' 2) Interface index#0D#0A' CONCAT
259 ' 3) Interface name#0D#0A' CONCAT
260 ' 4) Actual network mask on interface#0D#0A' CONCAT
261 ' 5) Correct network mask'
262 );
333ece94
VK
263
264
265/*
266** Following is a set of predefined events for thresholds
267** These events can occupy ID space 4000 ... 4999
268*/
269
270INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
271 (
272 4000, 'DC_HIGH_CPU_UTIL',
273 EVENT_SEVERITY_MINOR, 1,
b900a78b 274 'CPU utilization exceeds allowed maximum of %3 (Current: %4)',
333ece94
VK
275 'Custom data collection threshold event.#0D#0A' CONCAT
276 'Parameters:#0D#0A' CONCAT
b900a78b 277 THRESHOLD_EVENT_PARAMS
333ece94
VK
278 );
279INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
280 (
281 4001, 'DC_HIGH_PROCLOAD',
282 EVENT_SEVERITY_MINOR, 1,
b900a78b 283 'Processor load average exceeds allowed maximum of %3 (Current: %4)',
333ece94
VK
284 'Custom data collection threshold event.#0D#0A' CONCAT
285 'Parameters:#0D#0A' CONCAT
b900a78b 286 THRESHOLD_EVENT_PARAMS
333ece94
VK
287 );
288INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
289 (
290 4002, 'DC_HOST_RESTARTED',
291 EVENT_SEVERITY_NORMAL, 1,
292 'Host has been restarted within last 5 minutes',
293 'Custom data collection threshold event.#0D#0A' CONCAT
294 'Parameters:#0D#0A' CONCAT
b900a78b 295 THRESHOLD_EVENT_PARAMS
333ece94 296 );