- Initial DCI transformation support on server side
[public/netxms.git] / sql / events.in
1 /*
2 ** System-defined events
3 **
4 ** ex: syntax=sql
5 */
6
7 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
8 (
9 EVENT_NODE_ADDED, 'SYS_NODE_ADDED',
10 EVENT_SEVERITY_NORMAL, 1,
11 'Node added',
12 'Generated when new node object added to the database.#0D#0A' CONCAT
13 'Parameters:#0D#0A' CONCAT
14 ' No message-specific parameters'
15 );
16 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
17 (
18 EVENT_SUBNET_ADDED, 'SYS_SUBNET_ADDED',
19 EVENT_SEVERITY_NORMAL, 0,
20 'Subnet added',
21 'Generated when new subnet object added to the database.#0D#0A' CONCAT
22 'Parameters:#0D#0A' CONCAT
23 ' No message-specific parameters'
24 );
25 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
26 (
27 EVENT_INTERFACE_ADDED, 'SYS_IF_ADDED',
28 EVENT_SEVERITY_NORMAL, 1,
29 'Interface "%2" added (IP Addr: %3/%4, IfIndex: %5)',
30 'Generated when new interface object added to the database.#0D#0A' CONCAT
31 'Please note that source of event is node, not an interface itself.#0D#0A' CONCAT
32 'Parameters:#0D#0A' CONCAT
33 ' 1) Interface object ID#0D#0A' CONCAT
34 ' 2) Interface name#0D#0A' CONCAT
35 ' 3) Interface IP address#0D#0A' CONCAT
36 ' 4) Interface netmask#0D#0A' CONCAT
37 ' 5) Interface index'
38 );
39 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
40 (
41 EVENT_INTERFACE_UP, 'SYS_IF_UP',
42 EVENT_SEVERITY_NORMAL, 1,
43 'Interface "%2" changed state to UP (IP Addr: %3/%4, IfIndex: %5)',
44 'Generated when interface goes up.#0D#0A' CONCAT
45 'Please note that source of event is node, not an interface itself.#0D#0A' CONCAT
46 'Parameters:#0D#0A' CONCAT
47 ' 1) Interface object ID#0D#0A' CONCAT
48 ' 2) Interface name#0D#0A' CONCAT
49 ' 3) Interface IP address#0D#0A' CONCAT
50 ' 4) Interface netmask#0D#0A' CONCAT
51 ' 5) Interface index'
52 );
53 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
54 (
55 EVENT_INTERFACE_DOWN, 'SYS_IF_DOWN',
56 EVENT_SEVERITY_WARNING, 1,
57 'Interface "%2" changed state to DOWN (IP Addr: %3/%4, IfIndex: %5)',
58 'Generated when interface goes down.#0D#0A' CONCAT
59 'Please note that source of event is node, not an interface itself.#0D#0A' CONCAT
60 'Parameters:#0D#0A' CONCAT
61 ' 1) Interface object ID#0D#0A' CONCAT
62 ' 2) Interface name#0D#0A' CONCAT
63 ' 3) Interface IP address#0D#0A' CONCAT
64 ' 4) Interface netmask#0D#0A' CONCAT
65 ' 5) Interface index'
66 );
67 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
68 (
69 EVENT_NODE_NORMAL, 'SYS_NODE_NORMAL',
70 EVENT_SEVERITY_NORMAL, 1,
71 'Node status changed to NORMAL',
72 'Generated when node status changed to normal.#0D#0A' CONCAT
73 'Parameters:#0D#0A' CONCAT
74 ' 1) Previous node status'
75 );
76 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
77 (
78 EVENT_NODE_WARNING, 'SYS_NODE_WARNING',
79 EVENT_SEVERITY_WARNING, 1,
80 'Node status changed to WARNING',
81 'Generated when node status changed to "Warning".#0D#0A' CONCAT
82 'Parameters:#0D#0A' CONCAT
83 ' 1) Previous node status'
84 );
85 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
86 (
87 EVENT_NODE_MINOR, 'SYS_NODE_MINOR',
88 EVENT_SEVERITY_MINOR, 1,
89 'Node status changed to MINOR',
90 'Generated when node status changed to "Minor Problem" (informational).#0D#0A' CONCAT
91 'Parameters:#0D#0A' CONCAT
92 ' 1) Previous node status'
93 );
94 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
95 (
96 EVENT_NODE_MAJOR, 'SYS_NODE_MAJOR',
97 EVENT_SEVERITY_MAJOR, 1,
98 'Node status changed to MAJOR',
99 'Generated when node status changed to "Major Problem".#0D#0A' CONCAT
100 'Parameters:#0D#0A' CONCAT
101 ' 1) Previous node status'
102 );
103 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
104 (
105 EVENT_NODE_CRITICAL, 'SYS_NODE_CRITICAL',
106 EVENT_SEVERITY_CRITICAL, 1,
107 'Node status changed to CRITICAL',
108 'Generated when node status changed to critical.#0D#0A' CONCAT
109 'Parameters:#0D#0A' CONCAT
110 ' 1) Previous node status'
111 );
112 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
113 (
114 EVENT_NODE_UNKNOWN, 'SYS_NODE_UNKNOWN',
115 EVENT_SEVERITY_NORMAL, 1,
116 'Node status changed to UNKNOWN',
117 'Generated when node status changed to unknown.#0D#0A' CONCAT
118 'Parameters:#0D#0A' CONCAT
119 ' 1) Previous node status'
120 );
121 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
122 (
123 EVENT_NODE_UNMANAGED, 'SYS_NODE_UNMANAGED',
124 EVENT_SEVERITY_NORMAL, 1,
125 'Node status changed to UNMANAGED',
126 'Generated when node status changed to unmanaged.#0D#0A' CONCAT
127 'Parameters:#0D#0A' CONCAT
128 ' 1) Previous node status'
129 );
130 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
131 (
132 EVENT_NODE_FLAGS_CHANGED, 'SYS_NODE_CAP_CHANGED',
133 EVENT_SEVERITY_NORMAL, 0,
134 'Node capabilities changed (Old: %1; New: %2)',
135 'Generated when node capabilities changed.#0D#0A' CONCAT
136 'Parameters:#0D#0A' CONCAT
137 ' 1) Old capabilities#0D#0A' CONCAT
138 ' 2) New capabilities'
139 );
140 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
141 (
142 EVENT_SNMP_FAIL, 'SYS_SNMP_UNREACHEABLE',
143 EVENT_SEVERITY_NORMAL, 0,
144 'SNMP agent is not responding',
145 'Generated when node#27s SNMP agent is not responding.#0D#0A' CONCAT
146 'Parameters:#0D#0A' CONCAT
147 ' No message-specific parameters'
148 );
149 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
150 (
151 EVENT_AGENT_FAIL, 'SYS_AGENT_UNREACHEABLE',
152 EVENT_SEVERITY_NORMAL, 0,
153 'Native agent is not responding',
154 'Generated when node#27s native agent is not responding.#0D#0A' CONCAT
155 'Parameters:#0D#0A' CONCAT
156 ' No message-specific parameters'
157 );
158 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
159 (
160 EVENT_INTERFACE_DELETED, 'SYS_IF_DELETED',
161 EVENT_SEVERITY_NORMAL, 1,
162 'Interface "%2" deleted (IP Addr: %3/%4, IfIndex: %1)',
163 'Generated when interface object deleted from the database.#0D#0A' CONCAT
164 'Please note that source of event is node, not an interface itself.#0D#0A' CONCAT
165 'Parameters:#0D#0A' CONCAT
166 ' 1) Interface index#0D#0A' CONCAT
167 ' 2) Interface name#0D#0A' CONCAT
168 ' 3) Interface IP address#0D#0A' CONCAT
169 ' 4) Interface netmask'
170 );
171 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
172 (
173 EVENT_THRESHOLD_REACHED, 'SYS_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.#0D#0A' CONCAT
177 'Parameters:#0D#0A' CONCAT
178 ' 1) Item name#0D#0A' CONCAT
179 ' 2) Threshold value#0D#0A' CONCAT
180 ' 3) Actual value'
181 );
182 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
183 (
184 EVENT_THRESHOLD_REARMED, 'SYS_THRESHOLD_REARMED',
185 EVENT_SEVERITY_NORMAL, 0,
186 'Threshold rearmed for parameter %1',
187 'Generated when threshold check is rearmed for specific data collection item.#0D#0A' CONCAT
188 'Parameters:#0D#0A' CONCAT
189 ' 1) Item name'
190 );
191 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
192 (
193 EVENT_SUBNET_DELETED, 'SYS_SUBNET_DELETED',
194 EVENT_SEVERITY_NORMAL, 0,
195 'Subnet deleted',
196 'Generated when subnet object deleted from the database.#0D#0A' CONCAT
197 'Parameters:#0D#0A' CONCAT
198 ' No message-specific parameters'
199 );
200 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
201 (
202 EVENT_THREAD_HANGS, 'SYS_THREAD_HANG',
203 EVENT_SEVERITY_CRITICAL, 1,
204 'Thread "%1" is not responding',
205 'Generated when one of the system threads hangs or stops unexpectedly.#0D#0A' CONCAT
206 'Parameters:#0D#0A' CONCAT
207 ' 1) Thread name'
208 );
209 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
210 (
211 EVENT_THREAD_RUNNING, 'SYS_THREAD_RUNNING',
212 EVENT_SEVERITY_NORMAL, 1,
213 'Thread "%1" was returned to running state',
214 'Generated when one of the system threads which previously hangs or stops unexpectedly was returned to running state.#0D#0A' CONCAT
215 'Parameters:#0D#0A' CONCAT
216 ' 1) Thread name'
217 );
218 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
219 (
220 EVENT_SMTP_FAILURE, 'SYS_SMTP_FAILURE',
221 EVENT_SEVERITY_WARNING, 1,
222 'Unable to send e-mail to <%3>: %2',
223 'Generated when server is unable to send e-mail.#0D#0A' CONCAT
224 'Parameters:#0D#0A' CONCAT
225 ' 1) Error code#0D#0A' CONCAT
226 ' 2) Error text#0D#0A' CONCAT
227 ' 3) Recipient address#0D#0A' CONCAT
228 ' 4) Mail subject'
229 );
230
231
232 /*
233 ** Following is a set of predefined events for thresholds
234 ** These events can occupy ID space 4000 ... 4999
235 */
236
237 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
238 (
239 4000, 'DC_HIGH_CPU_UTIL',
240 EVENT_SEVERITY_MINOR, 1,
241 'CPU utilization exceeds allowed maximum of %2 (Current: %3)',
242 'Custom data collection threshold event.#0D#0A' CONCAT
243 'Parameters:#0D#0A' CONCAT
244 ' 1) Item name#0D#0A' CONCAT
245 ' 2) Threshold value#0D#0A' CONCAT
246 ' 3) Actual value'
247 );
248 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
249 (
250 4001, 'DC_HIGH_PROCLOAD',
251 EVENT_SEVERITY_MINOR, 1,
252 'Processor load average exceeds allowed maximum of %2 (Current: %3)',
253 'Custom data collection threshold event.#0D#0A' CONCAT
254 'Parameters:#0D#0A' CONCAT
255 ' 1) Item name#0D#0A' CONCAT
256 ' 2) Threshold value#0D#0A' CONCAT
257 ' 3) Actual value'
258 );
259 INSERT INTO events (event_id,name,severity,flags,message,description) VALUES
260 (
261 4002, 'DC_HOST_RESTARTED',
262 EVENT_SEVERITY_NORMAL, 1,
263 'Host has been restarted within last 5 minutes',
264 'Custom data collection threshold event.#0D#0A' CONCAT
265 'Parameters:#0D#0A' CONCAT
266 ' 1) Item name#0D#0A' CONCAT
267 ' 2) Threshold value#0D#0A' CONCAT
268 ' 3) Actual value'
269 );