- Added parameter System.ServiceState(*)
[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) Parameter#27s argument'
9
10
11 /*
12 ** System events
13 */
14
15 INSERT INTO events (event_id,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 events (event_id,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 events (event_id,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 events (event_id,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 events (event_id,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 events (event_id,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 events (event_id,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 events (event_id,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 events (event_id,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 events (event_id,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 events (event_id,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 events (event_id,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 events (event_id,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 events (event_id,name,severity,flags,message,description) VALUES
149 (
150 EVENT_SNMP_FAIL, 'SYS_SNMP_UNREACHEABLE',
151 EVENT_SEVERITY_NORMAL, 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 events (event_id,name,severity,flags,message,description) VALUES
158 (
159 EVENT_AGENT_FAIL, 'SYS_AGENT_UNREACHEABLE',
160 EVENT_SEVERITY_NORMAL, 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 events (event_id,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 events (event_id,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 events (event_id,name,severity,flags,message,description) VALUES
189 (
190 EVENT_THRESHOLD_REARMED, 'SYS_THRESHOLD_REARMED',
191 EVENT_SEVERITY_NORMAL, 0,
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'
197 );
198 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
199 (
200 EVENT_SUBNET_DELETED, 'SYS_SUBNET_DELETED',
201 EVENT_SEVERITY_NORMAL, 0,
202 'Subnet deleted',
203 'Generated when subnet object deleted from the database.#0D#0A' CONCAT
204 'Parameters:#0D#0A' CONCAT
205 ' No message-specific parameters'
206 );
207 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
208 (
209 EVENT_THREAD_HANGS, 'SYS_THREAD_HANG',
210 EVENT_SEVERITY_CRITICAL, 1,
211 'Thread "%1" is not responding',
212 'Generated when one of the system threads hangs or stops unexpectedly.#0D#0A' CONCAT
213 'Parameters:#0D#0A' CONCAT
214 ' 1) Thread name'
215 );
216 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
217 (
218 EVENT_THREAD_RUNNING, 'SYS_THREAD_RUNNING',
219 EVENT_SEVERITY_NORMAL, 1,
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 );
225 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
226 (
227 EVENT_SMTP_FAILURE, 'SYS_SMTP_FAILURE',
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 );
237 INSERT 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 );
250 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
251 (
252 EVENT_INCORRECT_NETMASK, 'SYS_INCORRECT_NETMASK',
253 EVENT_SEVERITY_MINOR, 1,
254 'Invalid network mask %4 on interface "%3", should be %5',
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 );
263
264
265 /*
266 ** Following is a set of predefined events for thresholds
267 ** These events can occupy ID space 4000 ... 4999
268 */
269
270 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
271 (
272 4000, 'DC_HIGH_CPU_UTIL',
273 EVENT_SEVERITY_MINOR, 1,
274 'CPU utilization exceeds allowed maximum of %3 (Current: %4)',
275 'Custom data collection threshold event.#0D#0A' CONCAT
276 'Parameters:#0D#0A' CONCAT
277 THRESHOLD_EVENT_PARAMS
278 );
279 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
280 (
281 4001, 'DC_HIGH_PROCLOAD',
282 EVENT_SEVERITY_MINOR, 1,
283 'Processor load average exceeds allowed maximum of %3 (Current: %4)',
284 'Custom data collection threshold event.#0D#0A' CONCAT
285 'Parameters:#0D#0A' CONCAT
286 THRESHOLD_EVENT_PARAMS
287 );
288 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
289 (
290 4002, 'DC_HOST_RESTARTED',
291 EVENT_SEVERITY_NORMAL, 1,
292 'Host was restarted within last 5 minutes',
293 'Custom data collection threshold event.#0D#0A' CONCAT
294 'Parameters:#0D#0A' CONCAT
295 THRESHOLD_EVENT_PARAMS
296 );
297 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
298 (
299 4003, 'DC_AGENT_RESTARTED',
300 EVENT_SEVERITY_NORMAL, 1,
301 'NetXMS agent was restarted within last 5 minutes',
302 'Custom data collection threshold event.#0D#0A' CONCAT
303 'Parameters:#0D#0A' CONCAT
304 THRESHOLD_EVENT_PARAMS
305 );
306 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
307 (
308 4004, 'DC_SERVICE_NOT_RUNNING',
309 EVENT_SEVERITY_MAJOR, 1,
310 'Service "%5" is not running',
311 'Custom data collection threshold event.#0D#0A' CONCAT
312 'Parameters:#0D#0A' CONCAT
313 THRESHOLD_EVENT_PARAMS
314 );