1 # <a id="appendix"></a> Appendix
3 ## <a id="external-commands-list-detail"></a> External Commands List
5 Additional details can be found in the [Icinga 1.x Documentation](http://docs.icinga.org/latest/en/extcommands2.html)
7 Command name | Parameters | Description
8 ------------------------------------------|-----------------------------------|--------------------------
9 PROCESS_HOST_CHECK_RESULT | ;<host_name>;<status_code>;<plugin_output> (3) | -
10 PROCESS_SERVICE_CHECK_RESULT | ;<host_name>;<service_name>;<return_code>;<plugin_output> (4) | -
11 SCHEDULE_HOST_CHECK | ;<host_name>;<check_time> (2) | -
12 SCHEDULE_FORCED_HOST_CHECK | ;<host_name>;<check_time> (2) | -
13 SCHEDULE_SVC_CHECK | ;<host_name>;<service_name>;<check_time> (3) | -
14 SCHEDULE_FORCED_SVC_CHECK | ;<host_name>;<service_name>;<check_time> (3) | -
15 ENABLE_HOST_CHECK | ;<host_name> (1) | -
16 DISABLE_HOST_CHECK | ;<host_name> (1) | -
17 ENABLE_SVC_CHECK | ;<host_name>;<service_name> (2) | -
18 DISABLE_SVC_CHECK | ;<host_name>;<service_name> (2) | -
19 SHUTDOWN_PROCESS | - | -
20 RESTART_PROCESS | - | -
21 SCHEDULE_FORCED_HOST_SVC_CHECKS | ;<host_name>;<check_time> (2) | -
22 SCHEDULE_HOST_SVC_CHECKS | ;<host_name>;<check_time> (2) | -
23 ENABLE_HOST_SVC_CHECKS | ;<host_name> (1) | -
24 DISABLE_HOST_SVC_CHECKS | ;<host_name> (1) | -
25 ACKNOWLEDGE_SVC_PROBLEM | ;<host_name>;<service_name>;<sticky>;<notify>;<persistent>;<author>;<comment> (7) | Note: Icinga 2 treats all comments as persistent.
26 ACKNOWLEDGE_SVC_PROBLEM_EXPIRE | ;<host_name>;<service_name>;<sticky>;<notify>;<persistent>;<timestamp>;<author>;<comment> (8) | Note: Icinga 2 treats all comments as persistent.
27 REMOVE_SVC_ACKNOWLEDGEMENT | ;<host_name>;<service_name> (2) | -
28 ACKNOWLEDGE_HOST_PROBLEM | ;<host_name>;<sticky>;<notify>;<persistent>;<author>;<comment> (6) | Note: Icinga 2 treats all comments as persistent.
29 ACKNOWLEDGE_HOST_PROBLEM_EXPIRE | ;<host_name>;<sticky>;<notify>;<persistent>;<timestamp>;<author>;<comment> (7) | Note: Icinga 2 treats all comments as persistent.
30 REMOVE_HOST_ACKNOWLEDGEMENT | ;<host_name> (1) | -
31 DISABLE_HOST_FLAP_DETECTION | ;<host_name> (1) | -
32 ENABLE_HOST_FLAP_DETECTION | ;<host_name> (1) | -
33 DISABLE_SVC_FLAP_DETECTION | ;<host_name>;<service_name> (2) | -
34 ENABLE_SVC_FLAP_DETECTION | ;<host_name>;<service_name> (2) | -
35 ENABLE_HOSTGROUP_SVC_CHECKS | ;<hostgroup_name> (1) | -
36 DISABLE_HOSTGROUP_SVC_CHECKS | ;<hostgroup_name> (1) | -
37 ENABLE_SERVICEGROUP_SVC_CHECKS | ;<servicegroup_name> (1) | -
38 DISABLE_SERVICEGROUP_SVC_CHECKS | ;<servicegroup_name> (1) | -
39 ENABLE_PASSIVE_HOST_CHECKS | ;<host_name> (1) | -
40 DISABLE_PASSIVE_HOST_CHECKS | ;<host_name> (1) | -
41 ENABLE_PASSIVE_SVC_CHECKS | ;<host_name>;<service_name> (2) | -
42 DISABLE_PASSIVE_SVC_CHECKS | ;<host_name>;<service_name> (2) | -
43 ENABLE_SERVICEGROUP_PASSIVE_SVC_CHECKS | ;<servicegroup_name> (1) | -
44 DISABLE_SERVICEGROUP_PASSIVE_SVC_CHECKS | ;<servicegroup_name> (1) | -
45 ENABLE_HOSTGROUP_PASSIVE_SVC_CHECKS | ;<hostgroup_name> (1) | -
46 DISABLE_HOSTGROUP_PASSIVE_SVC_CHECKS | ;<hostgroup_name> (1) | -
47 PROCESS_FILE | ;<file_name>;<delete> (2) | -
48 SCHEDULE_SVC_DOWNTIME | ;<host_name>;<service_name>;<start_time>;<end_time>;<fixed>;<trigger_id>;<duration>;<author>;<comment> (9) | -
49 DEL_SVC_DOWNTIME | ;<downtime_id> (1) | -
50 SCHEDULE_HOST_DOWNTIME | ;<host_name>;<start_time>;<end_time>;<fixed>;<trigger_id>;<duration>;<author>;<comment> (8) | -
51 DEL_HOST_DOWNTIME | ;<downtime_id> (1) | -
52 SCHEDULE_HOST_SVC_DOWNTIME | ;<host_name>;<start_time>;<end_time>;<fixed>;<trigger_id>;<duration>;<author>;<comment> (8) | -
53 SCHEDULE_HOSTGROUP_HOST_DOWNTIME | ;<hostgroup_name>;<start_time>;<end_time>;<fixed>;<trigger_id>;<duration>;<author>;<comment> (8) | -
54 SCHEDULE_HOSTGROUP_SVC_DOWNTIME | ;<hostgroup_name>;<start_time>;<end_time>;<fixed>;<trigger_id>;<duration>;<author>;<comment> (8) | -
55 SCHEDULE_SERVICEGROUP_HOST_DOWNTIME | ;<servicegroup_name>;<start_time>;<end_time>;<fixed>;<trigger_id>;<duration>;<author>;<comment> (8) | -
56 SCHEDULE_SERVICEGROUP_SVC_DOWNTIME | ;<servicegroup_name>;<start_time>;<end_time>;<fixed>;<trigger_id>;<duration>;<author>;<comment> (8) | -
57 ADD_HOST_COMMENT | ;<host_name>;<persistent>;<author>;<comment> (4) | Note: Icinga 2 treats all comments as persistent.
58 DEL_HOST_COMMENT | ;<comment_id> (1) | -
59 ADD_SVC_COMMENT | ;<host_name>;<service_name>;<persistent>;<author>;<comment> (5) | Note: Icinga 2 treats all comments as persistent.
60 DEL_SVC_COMMENT | ;<comment_id> (1) | -
61 DEL_ALL_HOST_COMMENTS | ;<host_name> (1) | -
62 DEL_ALL_SVC_COMMENTS | ;<host_name>;<service_name> (2) | -
63 SEND_CUSTOM_HOST_NOTIFICATION | ;<host_name>;<options>;<author>;<comment> (4) | -
64 SEND_CUSTOM_SVC_NOTIFICATION | ;<host_name>;<service_name>;<options>;<author>;<comment> (5) | -
65 DELAY_HOST_NOTIFICATION | ;<host_name>;<notification_time> (2) | -
66 DELAY_SVC_NOTIFICATION | ;<host_name>;<service_name>;<notification_time> (3) | -
67 ENABLE_HOST_NOTIFICATIONS | ;<host_name> (1) | -
68 DISABLE_HOST_NOTIFICATIONS | ;<host_name> (1) | -
69 ENABLE_SVC_NOTIFICATIONS | ;<host_name>;<service_name> (2) | -
70 DISABLE_SVC_NOTIFICATIONS | ;<host_name>;<service_name> (2) | -
71 DISABLE_HOSTGROUP_HOST_CHECKS | ;<hostgroup_name> (1) | -
72 DISABLE_HOSTGROUP_PASSIVE_HOST_CHECKS | ;<hostgroup_name> (1) | -
73 DISABLE_SERVICEGROUP_HOST_CHECKS | ;<servicegroup_name> (1) | -
74 DISABLE_SERVICEGROUP_PASSIVE_HOST_CHECKS | ;<servicegroup_name> (1) | -
75 ENABLE_HOSTGROUP_HOST_CHECKS | ;<hostgroup_name> (1) | -
76 ENABLE_HOSTGROUP_PASSIVE_HOST_CHECKS | ;<hostgroup_name> (1) | -
77 ENABLE_SERVICEGROUP_HOST_CHECKS | ;<servicegroup_name> (1) | -
78 ENABLE_SERVICEGROUP_PASSIVE_HOST_CHECKS | ;<servicegroup_name> (1) | -
79 ENABLE_NOTIFICATIONS | - | -
80 DISABLE_NOTIFICATIONS | - | -
81 ENABLE_FLAP_DETECTION | - | -
82 DISABLE_FLAP_DETECTION | - | -
83 ENABLE_EVENT_HANDLERS | - | -
84 DISABLE_EVENT_HANDLERS | - | -
85 ENABLE_PERFORMANCE_DATA | - | -
86 DISABLE_PERFORMANCE_DATA | - | -
87 START_EXECUTING_HOST_CHECKS | - | -
88 STOP_EXECUTING_HOST_CHECKS | - | -
89 START_EXECUTING_SVC_CHECKS | - | -
90 STOP_EXECUTING_SVC_CHECKS | - | -
91 CHANGE_SVC_MODATTR | ;<host_name>;<service_name>;<value> (3) | -
92 CHANGE_HOST_MODATTR | ;<host_name>;<value> (2) | -
93 CHANGE_USER_MODATTR | ;<user_name>;<value> (2) | -
94 CHANGE_CHECKCOMMAND_MODATTR | ;<checkcommand_name>;<value> (2) | -
95 CHANGE_EVENTCOMMAND_MODATTR | ;<eventcommand_name>;<value> (2) | -
96 CHANGE_NOTIFICATIONCOMMAND_MODATTR | ;<notificationcommand_name>;<value> (2) | -
97 CHANGE_NORMAL_SVC_CHECK_INTERVAL | ;<host_name>;<service_name>;<check_interval> (3) | -
98 CHANGE_NORMAL_HOST_CHECK_INTERVAL | ;<host_name>;<check_interval> (2) | -
99 CHANGE_RETRY_SVC_CHECK_INTERVAL | ;<host_name>;<service_name>;<check_interval> (3) | -
100 CHANGE_RETRY_HOST_CHECK_INTERVAL | ;<host_name>;<check_interval> (2) | -
101 ENABLE_HOST_EVENT_HANDLER | ;<host_name> (1) | -
102 DISABLE_HOST_EVENT_HANDLER | ;<host_name> (1) | -
103 ENABLE_SVC_EVENT_HANDLER | ;<host_name>;<service_name> (2) | -
104 DISABLE_SVC_EVENT_HANDLER | ;<host_name>;<service_name> (2) | -
105 CHANGE_HOST_EVENT_HANDLER | ;<host_name>;<event_command_name> (2) | -
106 CHANGE_SVC_EVENT_HANDLER | ;<host_name>;<service_name>;<event_command_name> (3) | -
107 CHANGE_HOST_CHECK_COMMAND | ;<host_name>;<check_command_name> (2) | -
108 CHANGE_SVC_CHECK_COMMAND | ;<host_name>;<service_name>;<check_command_name> (3) | -
109 CHANGE_MAX_HOST_CHECK_ATTEMPTS | ;<host_name>;<check_attempts> (2) | -
110 CHANGE_MAX_SVC_CHECK_ATTEMPTS | ;<host_name>;<service_name>;<check_attempts> (3) | -
111 CHANGE_HOST_CHECK_TIMEPERIOD | ;<host_name>;<timeperiod_name> (2) | -
112 CHANGE_SVC_CHECK_TIMEPERIOD | ;<host_name>;<service_name>;<timeperiod_name> | -
113 CHANGE_CUSTOM_HOST_VAR | ;<host_name>;<var_name>;<var_value> (3) | -
114 CHANGE_CUSTOM_SVC_VAR | ;<host_name>;<service_name>;<var_name>;<var_value> (4) | -
115 CHANGE_CUSTOM_USER_VAR | ;<user_name>;<var_name>;<var_value> (3) | -
116 CHANGE_CUSTOM_CHECKCOMMAND_VAR | ;<check_command_name>;<var_name>;<var_value> (3) | -
117 CHANGE_CUSTOM_EVENTCOMMAND_VAR | ;<event_command_name>;<var_name>;<var_value> (3) | -
118 CHANGE_CUSTOM_NOTIFICATIONCOMMAND_VAR | ;<notification_command_name>;<var_name>;<var_value> (3) | -
119 ENABLE_HOSTGROUP_HOST_NOTIFICATIONS | ;<hostgroup_name> (1) | -
120 ENABLE_HOSTGROUP_SVC_NOTIFICATIONS | ;<hostgroup_name> (1) | -
121 DISABLE_HOSTGROUP_HOST_NOTIFICATIONS | ;<hostgroup_name> (1) | -
122 DISABLE_HOSTGROUP_SVC_NOTIFICATIONS | ;<hostgroup_name> (1) | -
123 ENABLE_SERVICEGROUP_HOST_NOTIFICATIONS | ;<servicegroup_name> (1) | -
124 DISABLE_SERVICEGROUP_HOST_NOTIFICATIONS | ;<servicegroup_name> (1) | -
125 ENABLE_SERVICEGROUP_SVC_NOTIFICATIONS | ;<servicegroup_name> (1) | -
126 DISABLE_SERVICEGROUP_SVC_NOTIFICATIONS | ;<servicegroup_name> (1) | -
129 ## <a id="schemas"></a> Schemas
131 By convention `CheckCommand`, `EventCommand`, and `NotificationCommand` objects
132 are exported using a prefix. This is mandatory for unique objects in the
136 ------------------------|------------------------
137 CheckCommand | check_
138 EventCommand | event_
139 NotificationCommand | notification_
141 ### <a id="schema-status-files"></a> Status Files
143 Status files used by Icinga 1.x Classic UI: `status.dat`, `objects.cache`.
145 Icinga 2 specific extensions:
147 * host and service objects support 'check_source' (added in Classic UI 1.10.0)
148 * command objects support custom variables (added in Classic UI 1.11.2)
149 * host and service objects support 'is_reachable' (added in Classic UI 1.11.3)
150 * 2.2 adds custom attributes with arrays and dictionaries. They are dumped as JSON encoded string and `_is_json`
151 is set as additional custom variable in `objects.cache`.
153 ### <a id="schema-db-ido"></a> DB IDO Schema
155 There is a detailed documentation for the Icinga IDOUtils 1.x
156 database schema available on [http://docs.icinga.org/latest/en/db_model.html]
158 #### <a id="schema-db-ido-extensions"></a> DB IDO Schema Extensions
160 Icinga 2 specific extensions are shown below:
162 New tables: `endpoints`, `endpointstatus`
164 Table | Column | Type | Default | Description
165 --------------------|--------------------|----------|---------|-------------
166 endpoints | endpoint_object_id | bigint | NULL | FK: objects table
167 endpoints | identity | TEXT | NULL | endpoint name
168 endpoints | node | TEXT | NULL | local node name
170 Table | Column | Type | Default | Description
171 --------------------|--------------------|----------|---------|-------------
172 endpointstatus | endpoint_object_id | bigint | NULL | FK: objects table
173 endpointstatus | identity | TEXT | NULL | endpoint name
174 endpointstatus | node | TEXT | NULL | local node name
175 endpointstatus | is_connected | smallint | 0 | update on endpoint connect/disconnect
179 Table | Column | Type | Default | Description
180 --------------------|-------------------------|----------|---------|-------------
181 all status/history | endpoint_object_id | bigint | NULL | FK: objects table
182 servicestatus | check_source | TEXT | NULL | node name where check was executed
183 hoststatus | check_source | TEXT | NULL | node name where check was executed
184 statehistory | check_source | TEXT | NULL | node name where check was executed
185 servicestatus | is_reachable | integer | NULL | object reachability
186 hoststatus | is_reachable | integer | NULL | object reachability
187 logentries | object_id | bigint | NULL | FK: objects table (service associated with column)
188 {host,service}group | notes | TEXT | NULL | -
189 {host,service}group | notes_url | TEXT | NULL | -
190 {host,service}group | action_url | TEXT | NULL | -
191 customvariable* | is_json | integer | 0 | Defines whether `varvalue` is a json encoded string from custom attributes, or not
193 Additional command custom variables populated from 'vars' dictionary.
194 Additional global custom variables populated from 'Vars' constant (object_id is NULL).
196 ### <a id="schema-livestatus"></a> Livestatus Schema
198 #### <a id="schema-livestatus-extensions"></a> Livestatus Schema Extensions
200 Icinga 2 specific extensions are shown below:
202 New table: `endpoints`
205 ----------|--------------
209 endpoints | is_connected
214 ----------|--------------
216 services | is_reachable
218 services | cv_is_json
219 contacts | cv_is_json
221 services | check_source
223 downtimes | trigger_time
224 commands | custom_variable_names
225 commands | custom_variable_values
226 commands | custom_variables
227 commands | modified_attributes
228 commands | modified_attributes_list
229 status | custom_variable_names
230 status | custom_variable_values
231 status | custom_variables
233 Command custom variables reflect the local 'vars' dictionary.
234 Status custom variables reflect the global 'Vars' constant.
236 #### <a id="schema-livestatus-hosts-table-attributes"></a> Livestatus Hosts Table Attributes
239 ----------------------|-----------|-------------------------
241 display_name | string | .
242 alias | string | same as display_name.
244 address6 | string | NEW in Icinga.
245 check_command | string | .
246 check_command_expanded | string | .
247 event_handler | string | .
248 notification_period | string | host with notifications: period.
249 check_period | string | .
251 notes_expanded | string | .
252 notes_url | string | .
253 notes_url_expanded | string | .
254 action_url | string | .
255 action_url_expanded | string | .
256 plugin_output | string | .
257 perf_data | string | .
258 icon_image | string | .
259 icon_image_expanded | string | .
260 icon_image_alt | stirng | .
261 statusmap_image | string | .
262 long_plugin_output | string | .
263 max_check_attempts | int | .
264 flap_detection_enabled | int | .
265 check_freshness | int | .
266 process_performance_data | int | .
267 accept_passive_checks | int | .
268 event_handler_enabled | int | .
269 acknowledgement_type | int | Only 0 or 1.
272 last_hard_state | int | .
273 current_attempt | int | .
274 last_notification | int | host with notifications: last notification.
275 next_notification | int | host with notifications: next notification.
277 last_hard_state_change | int | .
278 has_been_checked | int | .
279 current_notification_number | int | host with notifications: number.
280 total_services | int | .
281 checks_enabled | int | .
282 notifications_enabled | int | .
283 acknowledged | int | .
286 no_more_notifications | int | notification_interval == 0 && volatile == false.
288 last_state_change | int | .
289 last_time_up | int | .
290 last_time_down | int | .
291 last_time_unreachable | int | .
292 is_flapping | int | .
293 scheduled_downtime_depth | int | .
294 active_checks_enabled | int | .
295 modified_attributes | array | .
296 modified_attributes_list | array | .
297 check_interval | double | .
298 retry_interval | double | .
299 notification_interval | double | host with notifications: smallest interval.
300 low_flap_threshold | double | flapping_threshold
301 high_flap_threshold | double | flapping_threshold
303 execution_time | double | .
304 percent_state_change | double | flapping.
305 in_notification_period | int | host with notifications: matching period.
306 in_check_period | int | .
307 contacts | array | host with notifications, users and user groups.
308 downtimes | array | id.
309 downtimes_with_info | array | id+author+comment.
310 comments | array | id.
311 comments_with_info | array | id+author+comment.
312 comments_with_extra_info | array | id+author+comment+entry_type+entry_time.
313 custom_variable_names | array | .
314 custom_variable_values | array | .
315 custom_variables | array | Array of custom variable array pair.
316 parents | array | Direct host parents.
317 childs | array | Direct host children (Note: `childs` is inherited from the origin MK_Livestatus protocol).
318 num_services | int | .
319 worst_service_state | int | All services and their worst state.
320 num_services_ok | int | All services with Ok state.
321 num_services_warn | int | All services with Warning state.
322 num_services_crit | int | All services with Critical state.
323 num_services_unknown | int | All services with Unknown state.
324 worst_service_hard_state | int | All services and their worst hard state.
325 num_services_hard_ok | int | All services in a hard state with Ok state.
326 num_services_hard_warn | int | All services in a hard state with Warning state.
327 num_services_hard_crit | int | All services in a hard state with Critical state.
328 num_services_hard_unknown | int | All services in a hard state with Unknown state.
329 hard_state | int | Returns OK, if state is OK. Returns current state if now a hard state type. Returns last hard state otherwise.
330 staleness | int | Indicates time since last check normalized onto the check_interval.
331 groups | array | All hostgroups this host is a member of.
332 contact_groups | array | All usergroups associated with this host through notifications.
333 services | array | All services associated with this host.
334 services_with_state | array | All services associated with this host with state and hasbeenchecked.
335 services_with_info | array | All services associated with this host with state, hasbeenchecked and output.
337 Not supported: `initial_state`, `pending_flex_downtime`, `check_flapping_recovery_notification`,
338 `is_executing`, `check_options`, `obsess_over_host`, `first_notification_delay`, `x_3d`, `y_3d`, `z_3d`,
339 `x_2d`, `y_2d`, `filename`, `pnpgraph_present`.
341 #### <a id="schema-livestatus-hostgroups-table-attributes"></a> Livestatus Hostgroups Table Attributes
344 ----------------------|-----------|-------------------------
346 alias | string | `display_name` attribute.
348 notes_url | string | .
349 action_url | string | .
351 members_with_state | array | Host name and state.
352 worst_host_state | int | Of all group members.
353 num_hosts | int | In this group.
354 num_hosts_pending | int | .
355 num_hosts_up | int | .
356 num_hosts_down | int | .
357 num_hosts_unreach | int | .
358 num_services | int | Number of services associated with hosts in this hostgroup.
359 worst_services_state | int | .
360 num_services_pending | int | .
361 num_services_ok | int | .
362 num_services_warn | int | .
363 num_services_crit | int | .
364 num_services_unknown | int | .
365 worst_service_hard_state | int | .
366 num_services_hard_ok | int | .
367 num_services_hard_warn | int | .
368 num_services_hard_crit | int | .
369 num_services_hard_unknown | int | .
371 #### <a id="schema-livestatus-services-table-attributes"></a> Livestatus Services Table Attributes
374 ----------------------|-----------|-------------------------
375 description | string | .
376 display_name | string | .
377 alias | string | same as display_name.
378 check_command | string | .
379 check_command_expanded | string | .
380 event_handler | string | .
381 notification_period | string | host with notifications: period.
382 check_period | string | .
384 notes_expanded | string | .
385 notes_url | string | .
386 notes_url_expanded | string | .
387 action_url | string | .
388 action_url_expanded | string | .
389 plugin_output | string | .
390 perf_data | string | .
391 icon_image | string | .
392 icon_image_expanded | string | .
393 icon_image_alt | stirng | .
394 statusmap_image | string | .
395 long_plugin_output | string | .
396 max_check_attempts | int | .
397 flap_detection_enabled | int | .
398 check_freshness | int | .
399 process_performance_data | int | .
400 accept_passive_checks | int | .
401 event_handler_enabled | int | .
402 acknowledgement_type | int | Only 0 or 1.
405 last_hard_state | int | .
406 current_attempt | int | .
407 last_notification | int | service with notifications: last notification.
408 next_notification | int | service with notifications: next notification.
410 last_hard_state_change | int | .
411 has_been_checked | int | .
412 current_notification_number | int | service with notifications: number.
413 checks_enabled | int | .
414 notifications_enabled | int | .
415 acknowledged | int | .
418 no_more_notifications | int | notification_interval == 0 && volatile == false.
420 last_state_change | int | .
421 last_time_up | int | .
422 last_time_down | int | .
423 last_time_unreachable | int | .
424 is_flapping | int | .
425 scheduled_downtime_depth | int | .
426 active_checks_enabled | int | .
427 modified_attributes | array | .
428 modified_attributes_list | array | .
429 check_interval | double | .
430 retry_interval | double | .
431 notification_interval | double | service with notifications: smallest interval.
432 low_flap_threshold | double | flapping_threshold
433 high_flap_threshold | double | flapping_threshold
435 execution_time | double | .
436 percent_state_change | double | flapping.
437 in_notification_period | int | service with notifications: matching period.
438 in_check_period | int | .
439 contacts | array | service with notifications, users and user groups.
440 downtimes | array | id.
441 downtimes_with_info | array | id+author+comment.
442 comments | array | id.
443 comments_with_info | array | id+author+comment.
444 comments_with_extra_info | array | id+author+comment+entry_type+entry_time.
445 custom_variable_names | array | .
446 custom_variable_values | array | .
447 custom_variables | array | Array of custom variable array pair.
448 hard_state | int | Returns OK, if state is OK. Returns current state if now a hard state type. Returns last hard state otherwise.
449 staleness | int | Indicates time since last check normalized onto the check_interval.
450 groups | array | All hostgroups this host is a member of.
451 contact_groups | array | All usergroups associated with this host through notifications.
452 host_ | join | Prefix for attributes from implicit join with hosts table.
454 Not supported: `initial_state`, `is_executing`, `check_options`, `obsess_over_service`, `first_notification_delay`,
457 #### <a id="schema-livestatus-servicegroups-table-attributes"></a> Livestatus Servicegroups Table Attributes
460 ----------------------|-----------|-------------------------
462 alias | string | `display_name` attribute.
464 notes_url | string | .
465 action_url | string | .
466 members | array | CSV format uses `host|service` syntax.
467 members_with_state | array | Host, service, hoststate, servicestate.
468 worst_service_state | int | .
469 num_services | int | .
470 num_services_pending | int | .
471 num_services_ok | int | .
472 num_services_warn | int | .
473 num_services_crit | int | .
474 num_services_unknown | int | .
475 num_services_hard_ok | int | .
476 num_services_hard_warn | int | .
477 num_services_hard_crit | int | .
478 num_services_hard_unknown | int | .
480 #### <a id="schema-livestatus-contacts-table-attributes"></a> Livestatus Contacts Table Attributes
483 ----------------------|-----------|-------------------------
485 alias | string | `display_name` attribute.
488 host_notification_period | string | .
489 service_notification_period | string | .
490 host_notifications_enabled | int | .
491 service_notifications_enabled | int | .
492 in_host_notification_period | int | .
493 in_service_notification_period | int | .
494 custom_variable_names | array | .
495 custom_variable_values | array | .
496 custom_variables | array | Array of customvariable array pairs.
497 modified_attributes | array | .
498 modified_attributes_list | array | .
501 Not supported: `can_submit_commands`.
503 #### <a id="schema-livestatus-contactgroups-table-attributes"></a> Livestatus Contactgroups Table Attributes
506 ----------------------|-----------|-------------------------
508 alias | string | `display_name` attribute.
512 #### <a id="schema-livestatus-commands-table-attributes"></a> Livestatus Commands Table Attributes
515 ----------------------|-----------|-------------------------
516 name | string | 3 types of commands in Icinga 2.
520 #### <a id="schema-livestatus-status-table-attributes"></a> Livestatus Status Table Attributes
523 ----------------------|-----------|-------------------------
524 connections | int | Since application start.
525 connections_rate | double | .
526 service_checks | int | Since application start.
527 service_checks_rate | double | .
528 host_checks | int | Since application start.
529 host_checks_rate | double | .
530 external_commands | int | Since application start.
531 external_commands_rate | double | .
532 nagios_pid | string | Application PID.
533 enable_notifications | int | .
534 execute_service_checks | int | .
535 accept_passive_service_checks | int | .
536 execute_host_checks | int | .
537 accept_passive_host_checks | int | .
538 enable_event_handlers | int | .
539 check_service_freshness | int | .
540 check_host_freshness | int | .
541 enable_flap_detection | int | .
542 process_performance_data | int | .
543 check_external_commands | int | Always enabled.
544 program_start | int | In seconds.
545 last_command_check | int | Always.
546 interval_length | int | Compatibility mode: 60.
548 num_services | int | .
549 program_version | string | 2.0.
550 livestatus_active_connections | string | .
552 Not supported: `neb_callbacks`, `neb_callbacks_rate`, `requests`, `requests_rate`, `forks`, `forks_rate`,
553 `log_messages`, `log_messages_rate`, `livechecks`, `livechecks_rate`, `livecheck_overflows`,
554 `livecheck_overflows_rate`, `obsess_over_services`, `obsess_over_hosts`, `last_log_rotation`,
555 `external_command_buffer_slots`, `external_command_buffer_usage`, `external_command_buffer_max`,
556 `cached_log_messages`, `livestatus_queued_connections`, `livestatus_threads`.
559 #### <a id="schema-livestatus-comments-table-attributes"></a> Livestatus Comments Table Attributes
562 ----------------------|-----------|-------------------------
565 id | int | legacy_id.
566 entry_time | string | Seconds.
567 type | int | 1=host, 2=service.
569 persistent | int | Always.
570 source | string | Always external (1).
573 expire_time | string | Seconds.
574 service_ | join | Prefix for attributes from implicit join with services table.
575 host_ | join | Prefix for attributes from implicit join with hosts table.
578 #### <a id="schema-livestatus-downtimes-table-attributes"></a> Livestatus Downtimes Table Attributes
581 ----------------------|-----------|-------------------------
584 id | int | legacy_id.
585 entry_time | string | Seconds.
586 type | int | 1=active, 0=pending.
588 start_time | string | Seconds.
589 end_time | string | Seconds.
590 fixed | int | 0=flexible, 1=fixed.
592 triggered_by | int | legacy_id.
593 triggers | int | NEW in Icinga 2.
594 trigger_time | string | NEW in Icinga 2.
595 service_ | join | Prefix for attributes from implicit join with services table.
596 host_ | join | Prefix for attributes from implicit join with hosts table.
599 #### <a id="schema-livestatus-timeperiod-table-attributes"></a> Livestatus Timeperiod Table Attributes
602 ----------------------|-----------|-------------------------
604 alias | string | `display_name` attribute.
605 in | int | Current time is in timeperiod or not.
607 #### <a id="schema-livestatus-log-table-attributes"></a> Livestatus Log Table Attributes
610 ----------------------|-----------|-------------------------
611 time | int | Time of log event (unix timestamp).
612 lineno | int | Line number in `CompatLogger` log file.
613 class | int | Log message class: 0=info, 1=state, 2=program, 3=notification, 4=passive, 5=command.
614 message | string | Complete message line.
615 type | string | Text before the colon `:`.
616 options | string | Text after the colon `:`.
617 comment | string | Comment if available.
618 plugin_output | string | Check output if available.
619 state | int | Host or service state.
620 state_type | int | State type if available.
621 attempt | int | Current check attempt.
622 service_description | string | .
623 host_name | string | .
624 contact_name | string | .
625 command_name | string | .
626 current_service_ | join | Prefix for attributes from implicit join with services table.
627 current_host_ | join | Prefix for attributes from implicit join with hosts table.
628 current_contact_ | join | Prefix for attributes from implicit join with contacts table.
629 current_command_ | join | Prefix for attributes from implicit join with commands table.
631 #### <a id="schema-livestatus-statehist-table-attributes"></a> Livestatus Statehist Table Attributes
634 ----------------------|-----------|-------------------------
635 time | int | Time of log event (unix timestamp).
636 lineno | int | Line number in `CompatLogger` log file.
637 from | int | Start timestamp (unix timestamp).
638 until | int | End timestamp (unix timestamp).
639 duration | int | until-from.
640 duration_part | double | duration / query_part.
641 state | int | State: 0=ok, 1=warn, 2=crit, 3=unknown, -1=notmonitored.
642 host_down | int | Host associated with the service is down or not.
643 in_downtime | int | Host/service is in downtime.
644 in_host_downtime | int | Host associated with the service is in a downtime or not.
645 is_flapping | int | Host/service is flapping.
646 in_notification_period | int | Host/service notification periods match or not.
647 notification_period | string | Host/service notification period.
648 host_name | string | .
649 service_description | string | .
650 log_output | string | Log file output for this state.
651 duration_ok | int | until-from for OK state.
652 duration_part_ok | double | .
653 duration_warning | int | until-from for Warning state.
654 duration_part_warning | double | .
655 duration_critical | int | until-from for Critical state.
656 duration_part_critical | double | .
657 duration_unknown | int | until-from for Unknown state.
658 duration_part_unknown | double | .
659 duration_unmonitored | int | until-from for Not-Monitored state.
660 duration_part_unmonitored | double | .
661 current_service_ | join | Prefix for attributes from implicit join with services table.
662 current_host_ | join | Prefix for attributes from implicit join with hosts table.
664 Not supported: `debug_info`.