X-Git-Url: https://granicus.if.org/sourcecode?a=blobdiff_plain;f=doc%2F9-appendix.md;h=beaea1680b544b8f9c11c4f70bb2062b3c4da585;hb=657a328ba4939d70889789a695d051e6ad33654c;hp=9c81c02c9b9e0e3519c987068b30c3fe2d14a67d;hpb=d13871e2337317f10c9b3b8ec2e04d2a4d6d9da0;p=icinga2 diff --git a/doc/9-appendix.md b/doc/9-appendix.md index 9c81c02c9..beaea1680 100644 --- a/doc/9-appendix.md +++ b/doc/9-appendix.md @@ -1,317 +1,142 @@ # Appendix -## Icinga Template Library - -### Overview - -The Icinga Template Library (ITL) implements standard templates and object -definitions for commonly used services. - -You can include the ITL by using the `include` directive in your configuration -file: - - include - -### Generic Templates - -These templates are imported by the provided example configuration. - -#### plugin-check-command - -Check command template for plugins executed by Icinga 2. - -The `plugin-check-command` check command does not support any vars. - -#### plugin-check-command - -Check command template for notification scripts executed by Icinga 2. - -The `plugin-notification-command` check command does not support any vars. - -#### plugin-check-command - -Check command template for event handler scripts executed by Icinga 2. - -The `plugin-event-command` check command does not support any vars. - -### Check Commands - -These check commands are embedded into Icinga 2 and do not require any external -plugin scripts. - -#### icinga - -Check command for the built-in `icinga` check. This check returns performance -data for the current Icinga instance. - -The `icinga` check command does not support any vars. - -#### cluster - -Check command for the built-in `cluster` check. This check returns performance -data for the current Icinga instance and connected endpoints. - -The `cluster` check command does not support any vars. - - - -## Plugin Check Commands - -### Overview - -The Plugin Check Commands provides example configuration for plugin check commands -provided by the the Monitoring Plugins project. - -You can include the plugin check command definitions by using the `include` -directive in your configuration file: - - include - -The plugin check commands assume that there's a global constant named `PluginDir` -which contains the path of the plugins from the Monitoring Plugins project. - - -#### ping4 - -Check command object for the `check_ping` plugin. - -Custom Attributes: - -Name | Description -----------------|-------------- -ping_address | **Optional.** The host's IPv4 address. Defaults to "$address$". -ping_wrta | **Optional.** The RTA warning threshold in milliseconds. Defaults to 100. -ping_wpl | **Optional.** The packet loss warning threshold in %. Defaults to 5. -ping_crta | **Optional.** The RTA critical threshold in milliseconds. Defaults to 200. -ping_cpl | **Optional.** The packet loss critical threshold in %. Defaults to 15. -ping_packets | **Optional.** The number of packets to send. Defaults to 5. -ping_timeout | **Optional.** The plugin timeout in seconds. Defaults to 0 (no timeout). - -#### ping6 - -Check command object for the `check_ping` plugin. - -Custom Attributes: - -Name | Description -----------------|-------------- -ping_address | **Optional.** The host's IPv6 address. Defaults to "$address6$". -ping_wrta | **Optional.** The RTA warning threshold in milliseconds. Defaults to 100. -ping_wpl | **Optional.** The packet loss warning threshold in %. Defaults to 5. -ping_crta | **Optional.** The RTA critical threshold in milliseconds. Defaults to 200. -ping_cpl | **Optional.** The packet loss critical threshold in %. Defaults to 15. -ping_packets | **Optional.** The number of packets to send. Defaults to 5. -ping_timeout | **Optional.** The plugin timeout in seconds. Defaults to 0 (no timeout). - -#### hostalive - -Check command object for the `check_ping` plugin with host check default values. - -Custom Attributes: - -Name | Description -----------------|-------------- -ping_address | **Optional.** The host's IPv4 address. Defaults to "$address$". -ping_wrta | **Optional.** The RTA warning threshold in milliseconds. Defaults to 3000. -ping_wpl | **Optional.** The packet loss warning threshold in %. Defaults to 80. -ping_crta | **Optional.** The RTA critical threshold in milliseconds. Defaults to 5000. -ping_cpl | **Optional.** The packet loss critical threshold in %. Defaults to 100. -ping_packets | **Optional.** The number of packets to send. Defaults to 5. -ping_timeout | **Optional.** The plugin timeout in seconds. Defaults to 0 (no timeout). - -#### dummy - -Check command object for the `check_dummy` plugin. - -Custom Attributes: - -Name | Description -----------------|-------------- -dummy_state | **Optional.** The state. Can be one of 0 (ok), 1 (warning), 2 (critical) and 3 (unknown). Defaults to 0. -dummy_text | **Optional.** Plugin output. Defaults to "Check was successful.". - -#### passive - -Specialised check command object for passive checks executing the `check_dummy` plugin with appropriate default values. - -Custom Attributes: - -Name | Description -----------------|-------------- -dummy_state | **Optional.** The state. Can be one of 0 (ok), 1 (warning), 2 (critical) and 3 (unknown). Defaults to 3. -dummy_text | **Optional.** Plugin output. Defaults to "No Passive Check Result Received.". - -#### tcp - -Check command object for the `check_tcp` plugin. - -Custom Attributes: - -Name | Description -----------------|-------------- -tcp_address | **Optional.** The host's address. Defaults to "$address$". -tcp_port | **Required.** The port that should be checked. - -#### udp - -Check command object for the `check_udp` plugin. - -Custom Attributes: - -Name | Description -----------------|-------------- -udp_address | **Optional.** The host's address. Defaults to "$address$". -udp_port | **Required.** The port that should be checked. - -#### http - -Check command object for the `check_http` plugin. - -Custom Attributes: - -Name | Description --------------------|-------------- -http_address | **Optional.** The host's address. Defaults to "$address". -http_vhost | **Optional.** The virtual host that should be sent in the "Host" header. -http_uri | **Optional.** The request URI. -http_port | **Optional.** The TCP port. Defaults to 80 when not using SSL, 443 otherwise. -http_ssl | **Optional.** Whether to use SSL. Defaults to false. -http_warn_time | **Optional.** The warning threshold. -http_critical_time | **Optional.** The critical threshold. - -#### smtp - -Check command object for the `check_smtp` plugin. - -Custom Attributes: - -Name | Description ----------------------|-------------- -smtp_address | **Optional.** The host's address. Defaults to "$address$". - -#### ssmtp - -Check command object for the `check_ssmtp` plugin. - -Custom Attributes: - -Name | Description -----------------|-------------- -ssmtp_address | **Required.** The host's address. Defaults to "$address$". -ssmtp_port | **Optional.** The port that should be checked. Defaults to 465. - -#### ntp_time - -Check command object for the `check_ntp_time` plugin. - -Custom Attributes: - -Name | Description -----------------|-------------- -ntp_address | **Optional.** The host's address. Defaults to "$address$". - -#### ssh - -Check command object for the `check_ssh` plugin. - -Custom Attributes: - -Name | Description -----------------|-------------- -ssh_address | **Optional.** The host's address. Defaults to "$address$". -ssh_port | **Optional.** The port that should be checked. Defaults to 22. - -#### disk - -Check command object for the `check_disk` plugin. - -Custom Attributes: - -Name | Description -----------------|-------------- -disk_wfree | **Optional.** The free space warning threshold in %. Defaults to 20. -disk_cfree | **Optional.** The free space critical threshold in %. Defaults to 10. - -#### users - -Check command object for the `check_disk` plugin. - -Custom Attributes: - -Name | Description -----------------|-------------- -users_wgreater | **Optional.** The user count warning threshold. Defaults to 20. -users_cgreater | **Optional.** The user count critical threshold. Defaults to 50. - -#### procs - -Check command object for the `check_procs` plugin. - -Custom Attributes: - -Name | Description -----------------|-------------- -procs_wgreater | **Optional.** The process count warning threshold. Defaults to 250. -procs_cgreater | **Optional.** The process count critical threshold. Defaults to 400. - -#### swap - -Check command object for the `check_swap` plugin. - -Custom Attributes: - -Name | Description -----------------|-------------- -swap_wfree | **Optional.** The free swap space warning threshold in %. Defaults to 50. -swap_cfree | **Optional.** The free swap space critical threshold in %. Defaults to 25. - -#### load - -Check command object for the `check_load` plugin. - -Custom Attributes: - -Name | Description -----------------|-------------- -load_wload1 | **Optional.** The 1-minute warning threshold. Defaults to 5. -load_wload5 | **Optional.** The 5-minute warning threshold. Defaults to 4. -load_wload15 | **Optional.** The 15-minute warning threshold. Defaults to 3. -load_cload1 | **Optional.** The 1-minute critical threshold. Defaults to 10. -load_cload5 | **Optional.** The 5-minute critical threshold. Defaults to 6. -load_cload15 | **Optional.** The 15-minute critical threshold. Defaults to 4. - -#### snmp - -Check command object for the `check_snmp` plugin. - -Custom Attributes: - -Name | Description -----------------|-------------- -snmp_address | **Optional.** The host's address. Defaults to "$address$". -snmp_oid | **Required.** The SNMP OID. -snmp_community | **Optional.** The SNMP community. Defaults to "public". - -#### snmp-uptime - -Check command object for the `check_snmp` plugin. - -Custom Attributes: +## External Commands List -Name | Description -----------------|-------------- -snmp_address | **Optional.** The host's address. Defaults to "$address$". -snmp_oid | **Optional.** The SNMP OID. Defaults to "1.3.6.1.2.1.1.3.0". -snmp_community | **Optional.** The SNMP community. Defaults to "public". +Additional details can be found in the [Icinga 1.x Documentation](http://docs.icinga.org/latest/en/extcommands2.html) -#### apt + Command name | Parameters | Description + ------------------------------------------|-----------------------------------|-------------------------- + PROCESS_HOST_CHECK_RESULT | ;<host_name>;<status_code>;<plugin_output> (3) | - + PROCESS_SERVICE_CHECK_RESULT | ;<host_name>;<service_name>;<return_code>;<plugin_output> (4) | - + SCHEDULE_HOST_CHECK | ;<host_name>;<check_time> (2) | - + SCHEDULE_FORCED_HOST_CHECK | ;<host_name>;<check_time> (2) | - + SCHEDULE_SVC_CHECK | ;<host_name>;<service_name>;<check_time> (3) | - + SCHEDULE_FORCED_SVC_CHECK | ;<host_name>;<service_name>;<check_time> (3) | - + ENABLE_HOST_CHECK | ;<host_name> (1) | - + DISABLE_HOST_CHECK | ;<host_name> (1) | - + ENABLE_SVC_CHECK | ;<host_name>;<service_name> (2) | - + DISABLE_SVC_CHECK | ;<host_name>;<service_name> (2) | - + SHUTDOWN_PROCESS | - | - + RESTART_PROCESS | - | - + SCHEDULE_FORCED_HOST_SVC_CHECKS | ;<host_name>;<check_time> (2) | - + SCHEDULE_HOST_SVC_CHECKS | ;<host_name>;<check_time> (2) | - + ENABLE_HOST_SVC_CHECKS | ;<host_name> (1) | - + DISABLE_HOST_SVC_CHECKS | ;<host_name> (1) | - + ACKNOWLEDGE_SVC_PROBLEM | ;<host_name>;<service_name>;<sticky>;<notify>;<persistent>;<author>;<comment> (7) | Note: Icinga 2 treats all comments as persistent. + ACKNOWLEDGE_SVC_PROBLEM_EXPIRE | ;<host_name>;<service_name>;<sticky>;<notify>;<persistent>;<timestamp>;<author>;<comment> (8) | Note: Icinga 2 treats all comments as persistent. + REMOVE_SVC_ACKNOWLEDGEMENT | ;<host_name>;<service_name> (2) | - + ACKNOWLEDGE_HOST_PROBLEM | ;<host_name>;<sticky>;<notify>;<persistent>;<author>;<comment> (6) | Note: Icinga 2 treats all comments as persistent. + ACKNOWLEDGE_HOST_PROBLEM_EXPIRE | ;<host_name>;<sticky>;<notify>;<persistent>;<timestamp>;<author>;<comment> (7) | Note: Icinga 2 treats all comments as persistent. + REMOVE_HOST_ACKNOWLEDGEMENT | ;<host_name> (1) | - + DISABLE_HOST_FLAP_DETECTION | ;<host_name> (1) | - + ENABLE_HOST_FLAP_DETECTION | ;<host_name> (1) | - + DISABLE_SVC_FLAP_DETECTION | ;<host_name>;<service_name> (2) | - + ENABLE_SVC_FLAP_DETECTION | ;<host_name>;<service_name> (2) | - + ENABLE_HOSTGROUP_SVC_CHECKS | ;<hostgroup_name> (1) | - + DISABLE_HOSTGROUP_SVC_CHECKS | ;<hostgroup_name> (1) | - + ENABLE_SERVICEGROUP_SVC_CHECKS | ;<servicegroup_name> (1) | - + DISABLE_SERVICEGROUP_SVC_CHECKS | ;<servicegroup_name> (1) | - + ENABLE_PASSIVE_HOST_CHECKS | ;<host_name> (1) | - + DISABLE_PASSIVE_HOST_CHECKS | ;<host_name> (1) | - + ENABLE_PASSIVE_SVC_CHECKS | ;<host_name>;<service_name> (2) | - + DISABLE_PASSIVE_SVC_CHECKS | ;<host_name>;<service_name> (2) | - + ENABLE_SERVICEGROUP_PASSIVE_SVC_CHECKS | ;<servicegroup_name> (1) | - + DISABLE_SERVICEGROUP_PASSIVE_SVC_CHECKS | ;<servicegroup_name> (1) | - + ENABLE_HOSTGROUP_PASSIVE_SVC_CHECKS | ;<hostgroup_name> (1) | - + DISABLE_HOSTGROUP_PASSIVE_SVC_CHECKS | ;<hostgroup_name> (1) | - + PROCESS_FILE | ;<file_name>;<delete> (2) | - + SCHEDULE_SVC_DOWNTIME | ;<host_name>;<service_name>;<start_time>;<end_time>;<fixed>;<trigger_id>;<duration>;<author>;<comment> (9) | - + DEL_SVC_DOWNTIME | ;<downtime_id> (1) | - + SCHEDULE_HOST_DOWNTIME | ;<host_name>;<start_time>;<end_time>;<fixed>;<trigger_id>;<duration>;<author>;<comment> (8) | - + DEL_HOST_DOWNTIME | ;<downtime_id> (1) | - + SCHEDULE_HOST_SVC_DOWNTIME | ;<host_name>;<start_time>;<end_time>;<fixed>;<trigger_id>;<duration>;<author>;<comment> (8) | - + SCHEDULE_HOSTGROUP_HOST_DOWNTIME | ;<hostgroup_name>;<start_time>;<end_time>;<fixed>;<trigger_id>;<duration>;<author>;<comment> (8) | - + SCHEDULE_HOSTGROUP_SVC_DOWNTIME | ;<hostgroup_name>;<start_time>;<end_time>;<fixed>;<trigger_id>;<duration>;<author>;<comment> (8) | - + SCHEDULE_SERVICEGROUP_HOST_DOWNTIME | ;<servicegroup_name>;<start_time>;<end_time>;<fixed>;<trigger_id>;<duration>;<author>;<comment> (8) | - + SCHEDULE_SERVICEGROUP_SVC_DOWNTIME | ;<servicegroup_name>;<start_time>;<end_time>;<fixed>;<trigger_id>;<duration>;<author>;<comment> (8) | - + ADD_HOST_COMMENT | ;<host_name>;<persistent>;<author>;<comment> (4) | Note: Icinga 2 treats all comments as persistent. + DEL_HOST_COMMENT | ;<comment_id> (1) | - + ADD_SVC_COMMENT | ;<host_name>;<service_name>;<persistent>;<author>;<comment> (5) | Note: Icinga 2 treats all comments as persistent. + DEL_SVC_COMMENT | ;<comment_id> (1) | - + DEL_ALL_HOST_COMMENTS | ;<host_name> (1) | - + DEL_ALL_SVC_COMMENTS | ;<host_name>;<service_name> (2) | - + SEND_CUSTOM_HOST_NOTIFICATION | ;<host_name>;<options>;<author>;<comment> (4) | - + SEND_CUSTOM_SVC_NOTIFICATION | ;<host_name>;<service_name>;<options>;<author>;<comment> (5) | - + DELAY_HOST_NOTIFICATION | ;<host_name>;<notification_time> (2) | - + DELAY_SVC_NOTIFICATION | ;<host_name>;<service_name>;<notification_time> (3) | - + ENABLE_HOST_NOTIFICATIONS | ;<host_name> (1) | - + DISABLE_HOST_NOTIFICATIONS | ;<host_name> (1) | - + ENABLE_SVC_NOTIFICATIONS | ;<host_name>;<service_name> (2) | - + DISABLE_SVC_NOTIFICATIONS | ;<host_name>;<service_name> (2) | - + DISABLE_HOSTGROUP_HOST_CHECKS | ;<hostgroup_name> (1) | - + DISABLE_HOSTGROUP_PASSIVE_HOST_CHECKS | ;<hostgroup_name> (1) | - + DISABLE_SERVICEGROUP_HOST_CHECKS | ;<servicegroup_name> (1) | - + DISABLE_SERVICEGROUP_PASSIVE_HOST_CHECKS | ;<servicegroup_name> (1) | - + ENABLE_HOSTGROUP_HOST_CHECKS | ;<hostgroup_name> (1) | - + ENABLE_HOSTGROUP_PASSIVE_HOST_CHECKS | ;<hostgroup_name> (1) | - + ENABLE_SERVICEGROUP_HOST_CHECKS | ;<servicegroup_name> (1) | - + ENABLE_SERVICEGROUP_PASSIVE_HOST_CHECKS | ;<servicegroup_name> (1) | - + ENABLE_NOTIFICATIONS | - | - + DISABLE_NOTIFICATIONS | - | - + ENABLE_FLAP_DETECTION | - | - + DISABLE_FLAP_DETECTION | - | - + ENABLE_EVENT_HANDLERS | - | - + DISABLE_EVENT_HANDLERS | - | - + ENABLE_PERFORMANCE_DATA | - | - + DISABLE_PERFORMANCE_DATA | - | - + START_EXECUTING_HOST_CHECKS | - | - + STOP_EXECUTING_HOST_CHECKS | - | - + START_EXECUTING_SVC_CHECKS | - | - + STOP_EXECUTING_SVC_CHECKS | - | - + CHANGE_SVC_MODATTR | ;<host_name>;<service_name>;<value> (3) | - + CHANGE_HOST_MODATTR | ;<host_name>;<value> (2) | - + CHANGE_USER_MODATTR | ;<user_name>;<value> (2) | - + CHANGE_CHECKCOMMAND_MODATTR | ;<checkcommand_name>;<value> (2) | - + CHANGE_EVENTCOMMAND_MODATTR | ;<eventcommand_name>;<value> (2) | - + CHANGE_NOTIFICATIONCOMMAND_MODATTR | ;<notificationcommand_name>;<value> (2) | - + CHANGE_NORMAL_SVC_CHECK_INTERVAL | ;<host_name>;<service_name>;<check_interval> (3) | - + CHANGE_NORMAL_HOST_CHECK_INTERVAL | ;<host_name>;<check_interval> (2) | - + CHANGE_RETRY_SVC_CHECK_INTERVAL | ;<host_name>;<service_name>;<check_interval> (3) | - + CHANGE_RETRY_HOST_CHECK_INTERVAL | ;<host_name>;<check_interval> (2) | - + ENABLE_HOST_EVENT_HANDLER | ;<host_name> (1) | - + DISABLE_HOST_EVENT_HANDLER | ;<host_name> (1) | - + ENABLE_SVC_EVENT_HANDLER | ;<host_name>;<service_name> (2) | - + DISABLE_SVC_EVENT_HANDLER | ;<host_name>;<service_name> (2) | - + CHANGE_HOST_EVENT_HANDLER | ;<host_name>;<event_command_name> (2) | - + CHANGE_SVC_EVENT_HANDLER | ;<host_name>;<service_name>;<event_command_name> (3) | - + CHANGE_HOST_CHECK_COMMAND | ;<host_name>;<check_command_name> (2) | - + CHANGE_SVC_CHECK_COMMAND | ;<host_name>;<service_name>;<check_command_name> (3) | - + CHANGE_MAX_HOST_CHECK_ATTEMPTS | ;<host_name>;<check_attempts> (2) | - + CHANGE_MAX_SVC_CHECK_ATTEMPTS | ;<host_name>;<service_name>;<check_attempts> (3) | - + CHANGE_HOST_CHECK_TIMEPERIOD | ;<host_name>;<timeperiod_name> (2) | - + CHANGE_SVC_CHECK_TIMEPERIOD | ;<host_name>;<service_name>;<timeperiod_name> | - + CHANGE_CUSTOM_HOST_VAR | ;<host_name>;<var_name>;<var_value> (3) | - + CHANGE_CUSTOM_SVC_VAR | ;<host_name>;<service_name>;<var_name>;<var_value> (4) | - + CHANGE_CUSTOM_USER_VAR | ;<user_name>;<var_name>;<var_value> (3) | - + CHANGE_CUSTOM_CHECKCOMMAND_VAR | ;<check_command_name>;<var_name>;<var_value> (3) | - + CHANGE_CUSTOM_EVENTCOMMAND_VAR | ;<event_command_name>;<var_name>;<var_value> (3) | - + CHANGE_CUSTOM_NOTIFICATIONCOMMAND_VAR | ;<notification_command_name>;<var_name>;<var_value> (3) | - + ENABLE_HOSTGROUP_HOST_NOTIFICATIONS | ;<hostgroup_name> (1) | - + ENABLE_HOSTGROUP_SVC_NOTIFICATIONS | ;<hostgroup_name> (1) | - + DISABLE_HOSTGROUP_HOST_NOTIFICATIONS | ;<hostgroup_name> (1) | - + DISABLE_HOSTGROUP_SVC_NOTIFICATIONS | ;<hostgroup_name> (1) | - + ENABLE_SERVICEGROUP_HOST_NOTIFICATIONS | ;<servicegroup_name> (1) | - + DISABLE_SERVICEGROUP_HOST_NOTIFICATIONS | ;<servicegroup_name> (1) | - + ENABLE_SERVICEGROUP_SVC_NOTIFICATIONS | ;<servicegroup_name> (1) | - + DISABLE_SERVICEGROUP_SVC_NOTIFICATIONS | ;<servicegroup_name> (1) | - -Check command for the `check_apt` plugin. -The `apt` check command does not support any vars. +## Schemas +By convention `CheckCommand`, `EventCommand`, and `NotificationCommand` objects +are exported using a prefix. This is mandatory for unique objects in the +command tables. -## Schemas +Object | Prefix +------------------------|------------------------ +CheckCommand | check_ +EventCommand | event_ +NotificationCommand | notification_ ### Status Files @@ -322,8 +147,10 @@ Icinga 2 specific extensions: * host and service objects support 'check_source' (added in Classic UI 1.10.0) * command objects support custom variables (added in Classic UI 1.11.2) * host and service objects support 'is_reachable' (added in Classic UI 1.11.3) +* 2.2 adds custom attributes with arrays and dictionaries. They are dumped as JSON encoded string and `_is_json` +is set as additional custom variable in `objects.cache`. -### DB IDO +### DB IDO Schema There is a detailed documentation for the Icinga IDOUtils 1.x database schema available on [http://docs.icinga.org/latest/en/db_model.html] @@ -361,130 +188,12 @@ New columns: {host,service}group | notes | TEXT | NULL | - {host,service}group | notes_url | TEXT | NULL | - {host,service}group | action_url | TEXT | NULL | - + customvariable* | is_json | integer | 0 | Defines whether `varvalue` is a json encoded string from custom attributes, or not Additional command custom variables populated from 'vars' dictionary. Additional global custom variables populated from 'Vars' constant (object_id is NULL). - -### Livestatus - - -#### Livestatus Tables - - Table | Join |Description - --------------|-----------|---------------------------- - hosts |   | host config and status attributes, services counter - hostgroups |   | hostgroup config, status attributes and host/service counters - services | hosts | service config and status attributes - servicegroups |   | servicegroup config, status attributes and service counters - contacts |   | contact config and status attributes - contactgroups |   | contact config, members - commands |   | command name and line - status |   | programstatus, config and stats - comments | services | status attributes - downtimes | services | status attributes - timeperiods |   | name and is inside flag - endpoints |   | config and status attributes - log | services, hosts, contacts, commands | parses [compatlog](#objecttype-compatlogger) and shows log attributes - statehist | hosts, services | parses [compatlog](#objecttype-compatlogger) and aggregates state change attributes - -The `commands` table is populated with `CheckCommand`, `EventCommand` and `NotificationCommand` objects. - - -#### Livestatus Table Attributes - -A detailed list which table attributes are supported can be found here: [https://wiki.icinga.org/display/icinga2/Livestatus#Livestatus-Attributes] - - -#### Livestatus GET Queries - - $ echo -e 'GET services' | netcat 127.0.0.1 6558 - - $ cat servicegroups < Livestatus COMMAND Queries - -A list of available external commands and their parameters can be found [here](#external-commands-list-detail) - - $ echo -e 'COMMAND ' | netcat 127.0.0.1 6558 - - -#### Livestatus Filters - -and, or, negate - - Operator | Negate | Description - ----------|------------------------ - = | != | Euqality - ~ | !~ | Regex match - =~ | !=~ | Euqality ignoring case - ~~ | !~~ | Regex ignoring case - > | | Less than - < | | Greater than - >= | | Less than or equal - <= | | Greater than or equal - - -#### Livestatus Stats - -Schema: "Stats: aggregatefunction aggregateattribute" - - Aggregate Function | Description - -------------------|-------------- - sum |   - min |   - max |   - avg | sum / count - std | standard deviation - suminv | sum (1 / value) - avginv | suminv / count - count | ordinary default for any stats query if not aggregate function defined - -Example: - - GET hosts - Filter: has_been_checked = 1 - Filter: check_type = 0 - Stats: sum execution_time - Stats: sum latency - Stats: sum percent_state_change - Stats: min execution_time - Stats: min latency - Stats: min percent_state_change - Stats: max execution_time - Stats: max latency - Stats: max percent_state_change - OutputFormat: json - ResponseHeader: fixed16 - -#### Livestatus Output - -* CSV - -CSV Output uses two levels of array seperators: The members array separator -is a comma (1st level) while extra info and host|service relation separator -is a pipe (2nd level). - -Seperators can be set using ASCII codes like: - - Separators: 10 59 44 124 - -* JSON - -Default separators. - -#### Livestatus Error Codes - - Code | Description - ----------|-------------- - 200 | OK - 404 | Table does not exist - 452 | Exception on query +### Livestatus Schema #### Livestatus Schema Extensions @@ -505,6 +214,10 @@ New columns: ----------|-------------- hosts | is_reachable services | is_reachable + hosts | cv_is_json + services | cv_is_json + contacts | cv_is_json + hosts | check_source services | check_source downtimes | triggers downtimes | trigger_time @@ -520,128 +233,432 @@ New columns: Command custom variables reflect the local 'vars' dictionary. Status custom variables reflect the global 'Vars' constant. - -## External Commands List - -Additional details can be found in the [Icinga 1.x Documentation](http://docs.icinga.org/latest/en/extcommands2.html) - - Command name | Parameters | Description - ------------------------------------------|-----------------------------------|-------------------------- - PROCESS_HOST_CHECK_RESULT | ;;; (3) | - - PROCESS_SERVICE_CHECK_RESULT | ;;;; (4) | - - SCHEDULE_HOST_CHECK | ;; (2) | - - SCHEDULE_FORCED_HOST_CHECK | ;; (2) | - - SCHEDULE_SVC_CHECK | ;;; (3) | - - SCHEDULE_FORCED_SVC_CHECK | ;;; (3) | - - ENABLE_HOST_CHECK | ; (1) | - - DISABLE_HOST_CHECK | ; (1) | - - ENABLE_SVC_CHECK | ;; (2) | - - DISABLE_SVC_CHECK | ;; (2) | - - SHUTDOWN_PROCESS | (0) | - - RESTART_PROCESS | (0) | - - SCHEDULE_FORCED_HOST_SVC_CHECKS | ;; (2) | - - SCHEDULE_HOST_SVC_CHECKS | ;; (2) | - - ENABLE_HOST_SVC_CHECKS | ; (1) | - - DISABLE_HOST_SVC_CHECKS | ; (1) | - - ACKNOWLEDGE_SVC_PROBLEM | ;;;;;;; (7) | Note: Icinga 2 treats all comments as persistent. - ACKNOWLEDGE_SVC_PROBLEM_EXPIRE | ;;;;;;;; (8) | Note: Icinga 2 treats all comments as persistent. - REMOVE_SVC_ACKNOWLEDGEMENT | ;; (2) | - - ACKNOWLEDGE_HOST_PROBLEM | ;;;;;; (6) | Note: Icinga 2 treats all comments as persistent. - ACKNOWLEDGE_HOST_PROBLEM_EXPIRE | ;;;;;;; (7) | Note: Icinga 2 treats all comments as persistent. - REMOVE_HOST_ACKNOWLEDGEMENT | ; (1) | - - DISABLE_HOST_FLAP_DETECTION | ; (1) | - - ENABLE_HOST_FLAP_DETECTION | ; (1) | - - DISABLE_SVC_FLAP_DETECTION | ;; (2) | - - ENABLE_SVC_FLAP_DETECTION | ;; (2) | - - ENABLE_HOSTGROUP_SVC_CHECKS | ; (1) | - - DISABLE_HOSTGROUP_SVC_CHECKS | ; (1) | - - ENABLE_SERVICEGROUP_SVC_CHECKS | ; (1) | - - DISABLE_SERVICEGROUP_SVC_CHECKS | ; (1) | - - ENABLE_PASSIVE_HOST_CHECKS | ; (1) | - - DISABLE_PASSIVE_HOST_CHECKS | ; (1) | - - ENABLE_PASSIVE_SVC_CHECKS | ;; (2) | - - DISABLE_PASSIVE_SVC_CHECKS | ;; (2) | - - ENABLE_SERVICEGROUP_PASSIVE_SVC_CHECKS | ; (1) | - - DISABLE_SERVICEGROUP_PASSIVE_SVC_CHECKS | ; (1) | - - ENABLE_HOSTGROUP_PASSIVE_SVC_CHECKS | ; (1) | - - DISABLE_HOSTGROUP_PASSIVE_SVC_CHECKS | ; (1) | - - PROCESS_FILE | ;; (2) | - - SCHEDULE_SVC_DOWNTIME | ;;;;;;;;; (9) | - - DEL_SVC_DOWNTIME | ; (1) | - - SCHEDULE_HOST_DOWNTIME | ;;;;;;;; (8) | - - DEL_HOST_DOWNTIME | ; (1) | - - SCHEDULE_HOST_SVC_DOWNTIME | ;;;;;;;; (8) | - - SCHEDULE_HOSTGROUP_HOST_DOWNTIME | ;;;;;;;; (8) | - - SCHEDULE_HOSTGROUP_SVC_DOWNTIME | ;;;;;;;; (8) | - - SCHEDULE_SERVICEGROUP_HOST_DOWNTIME | ;;;;;;;; (8) | - - SCHEDULE_SERVICEGROUP_SVC_DOWNTIME | ;;;;;;;; (8) | - - ADD_HOST_COMMENT | ;;;; (4) | Note: Icinga 2 treats all comments as persistent. - DEL_HOST_COMMENT | ; (1) | - - ADD_SVC_COMMENT | ;;;;; (5) | Note: Icinga 2 treats all comments as persistent. - DEL_SVC_COMMENT | ; (1) | - - DEL_ALL_HOST_COMMENTS | ; (1) | - - DEL_ALL_SVC_COMMENTS | ;; (2) | - - SEND_CUSTOM_HOST_NOTIFICATION | ;;;; (4) | - - SEND_CUSTOM_SVC_NOTIFICATION | ;;;;; (5) | - - DELAY_HOST_NOTIFICATION | ;; (2) | - - DELAY_SVC_NOTIFICATION | ;;; (3) | - - ENABLE_HOST_NOTIFICATIONS | ; (1) | - - DISABLE_HOST_NOTIFICATIONS | ; (1) | - - ENABLE_SVC_NOTIFICATIONS | ;; (2) | - - DISABLE_SVC_NOTIFICATIONS | ;; (2) | - - DISABLE_HOSTGROUP_HOST_CHECKS | ; (1) | - - DISABLE_HOSTGROUP_PASSIVE_HOST_CHECKS | ; (1) | - - DISABLE_SERVICEGROUP_HOST_CHECKS | ; (1) | - - DISABLE_SERVICEGROUP_PASSIVE_HOST_CHECKS | ; (1) | - - ENABLE_HOSTGROUP_HOST_CHECKS | ; (1) | - - ENABLE_HOSTGROUP_PASSIVE_HOST_CHECKS | ; (1) | - - ENABLE_SERVICEGROUP_HOST_CHECKS | ; (1) | - - ENABLE_SERVICEGROUP_PASSIVE_HOST_CHECKS | ; (1) | - - ENABLE_NOTIFICATIONS | (0) | - - DISABLE_NOTIFICATIONS | (0) | - - ENABLE_FLAP_DETECTION | (0) | - - DISABLE_FLAP_DETECTION | (0) | - - ENABLE_EVENT_HANDLERS | (0) | - - DISABLE_EVENT_HANDLERS | (0) | - - ENABLE_PERFORMANCE_DATA | (0) | - - DISABLE_PERFORMANCE_DATA | (0) | - - START_EXECUTING_HOST_CHECKS | (0) | - - STOP_EXECUTING_HOST_CHECKS | (0) | - - START_EXECUTING_SVC_CHECKS | (0) | - - STOP_EXECUTING_SVC_CHECKS | (0) | - - CHANGE_SVC_MODATTR | ;;; (3) | - - CHANGE_HOST_MODATTR | ;; (2) | - - CHANGE_USER_MODATTR | ;; (2) | - - CHANGE_CHECKCOMMAND_MODATTR | ;; (2) | - - CHANGE_EVENTCOMMAND_MODATTR | ;; (2) | - - CHANGE_NOTIFICATIONCOMMAND_MODATTR | ;; (2) | - - CHANGE_NORMAL_SVC_CHECK_INTERVAL | ;;; (3) | - - CHANGE_NORMAL_HOST_CHECK_INTERVAL | ;; (2) | - - CHANGE_RETRY_SVC_CHECK_INTERVAL | ;;; (3) | - - CHANGE_RETRY_HOST_CHECK_INTERVAL | ;; (2) | - - ENABLE_HOST_EVENT_HANDLER | ; (1) | - - DISABLE_HOST_EVENT_HANDLER | ; (1) | - - ENABLE_SVC_EVENT_HANDLER | ;; (2) | - - DISABLE_SVC_EVENT_HANDLER | ;; (2) | - - CHANGE_HOST_EVENT_HANDLER | ;; (2) | - - CHANGE_SVC_EVENT_HANDLER | ;;; (3) | - - CHANGE_HOST_CHECK_COMMAND | ;; (2) | - - CHANGE_SVC_CHECK_COMMAND | ;;; (3) | - - CHANGE_MAX_HOST_CHECK_ATTEMPTS | ;; (2) | - - CHANGE_MAX_SVC_CHECK_ATTEMPTS | ;;; (3) | - - CHANGE_HOST_CHECK_TIMEPERIOD | ;; (2) | - - CHANGE_SVC_CHECK_TIMEPERIOD | ;;; | - - CHANGE_CUSTOM_HOST_VAR | ;;; (3) | - - CHANGE_CUSTOM_SVC_VAR | ;;;; (4) | - - CHANGE_CUSTOM_USER_VAR | ;;; (3) | - - CHANGE_CUSTOM_CHECKCOMMAND_VAR | ;;; (3) | - - CHANGE_CUSTOM_EVENTCOMMAND_VAR | ;;; (3) | - - CHANGE_CUSTOM_NOTIFICATIONCOMMAND_VAR | ;;; (3) | - - ENABLE_HOSTGROUP_HOST_NOTIFICATIONS | ; (1) | - - ENABLE_HOSTGROUP_SVC_NOTIFICATIONS | ; (1) | - - DISABLE_HOSTGROUP_HOST_NOTIFICATIONS | ; (1) | - - DISABLE_HOSTGROUP_SVC_NOTIFICATIONS | ; (1) | - - ENABLE_SERVICEGROUP_HOST_NOTIFICATIONS | ; (1) | - - DISABLE_SERVICEGROUP_HOST_NOTIFICATIONS | ; (1) | - - ENABLE_SERVICEGROUP_SVC_NOTIFICATIONS | ; (1) | - - DISABLE_SERVICEGROUP_SVC_NOTIFICATIONS | ; (1) | - +#### Livestatus Hosts Table Attributes + + Key | Type | Note + ----------------------|-----------|------------------------- + name | string | . + display_name | string | . + alias | string | same as display_name. + address | string | . + address6 | string | NEW in Icinga. + check_command | string | . + check_command_expanded | string | . + event_handler | string | . + notification_period | string | host with notifications: period. + check_period | string | . + notes | string | . + notes_expanded | string | . + notes_url | string | . + notes_url_expanded | string | . + action_url | string | . + action_url_expanded | string | . + plugin_output | string | . + perf_data | string | . + icon_image | string | . + icon_image_expanded | string | . + icon_image_alt | stirng | . + statusmap_image | string | . + long_plugin_output | string | . + max_check_attempts | int | . + flap_detection_enabled | int | . + check_freshness | int | . + process_performance_data | int | . + accept_passive_checks | int | . + event_handler_enabled | int | . + acknowledgement_type | int | Only 0 or 1. + check_type | int | . + last_state | int | . + last_hard_state | int | . + current_attempt | int | . + last_notification | int | host with notifications: last notification. + next_notification | int | host with notifications: next notification. + next_check | int | . + last_hard_state_change | int | . + has_been_checked | int | . + current_notification_number | int | host with notifications: number. + total_services | int | . + checks_enabled | int | . + notifications_enabled | int | . + acknowledged | int | . + state | int | . + state_type | int | . + no_more_notifications | int | notification_interval == 0 && volatile == false. + last_check | int | . + last_state_change | int | . + last_time_up | int | . + last_time_down | int | . + last_time_unreachable | int | . + is_flapping | int | . + scheduled_downtime_depth | int | . + active_checks_enabled | int | . + modified_attributes | array | . + modified_attributes_list | array | . + check_interval | double | . + retry_interval | double | . + notification_interval | double | host with notifications: smallest interval. + low_flap_threshold | double | flapping_threshold + high_flap_threshold | double | flapping_threshold + latency | double | . + execution_time | double | . + percent_state_change | double | flapping. + in_notification_period | int | host with notifications: matching period. + in_check_period | int | . + contacts | array | host with notifications, users and user groups. + downtimes | array | id. + downtimes_with_info | array | id+author+comment. + comments | array | id. + comments_with_info | array | id+author+comment. + comments_with_extra_info | array | id+author+comment+entry_type+entry_time. + custom_variable_names | array | . + custom_variable_values | array | . + custom_variables | array | Array of custom variable array pair. + parents | array | Direct host parents. + childs | array | Direct host children (Note: `childs` is inherited from the origin MK_Livestatus protocol). + num_services | int | . + worst_service_state | int | All services and their worst state. + num_services_ok | int | All services with Ok state. + num_services_warn | int | All services with Warning state. + num_services_crit | int | All services with Critical state. + num_services_unknown | int | All services with Unknown state. + worst_service_hard_state | int | All services and their worst hard state. + num_services_hard_ok | int | All services in a hard state with Ok state. + num_services_hard_warn | int | All services in a hard state with Warning state. + num_services_hard_crit | int | All services in a hard state with Critical state. + num_services_hard_unknown | int | All services in a hard state with Unknown state. + hard_state | int | Returns OK, if state is OK. Returns current state if now a hard state type. Returns last hard state otherwise. + staleness | int | Indicates time since last check normalized onto the check_interval. + groups | array | All hostgroups this host is a member of. + contact_groups | array | All usergroups associated with this host through notifications. + services | array | All services associated with this host. + services_with_state | array | All services associated with this host with state and hasbeenchecked. + services_with_info | array | All services associated with this host with state, hasbeenchecked and output. + +Not supported: `initial_state`, `pending_flex_downtime`, `check_flapping_recovery_notification`, +`is_executing`, `check_options`, `obsess_over_host`, `first_notification_delay`, `x_3d`, `y_3d`, `z_3d`, +`x_2d`, `y_2d`, `filename`, `pnpgraph_present`. + +#### Livestatus Hostgroups Table Attributes + + Key | Type | Note + ----------------------|-----------|------------------------- + name | string | . + alias | string | `display_name` attribute. + notes | string | . + notes_url | string | . + action_url | string | . + members | array | . + members_with_state | array | Host name and state. + worst_host_state | int | Of all group members. + num_hosts | int | In this group. + num_hosts_pending | int | . + num_hosts_up | int | . + num_hosts_down | int | . + num_hosts_unreach | int | . + num_services | int | Number of services associated with hosts in this hostgroup. + worst_services_state | int | . + num_services_pending | int | . + num_services_ok | int | . + num_services_warn | int | . + num_services_crit | int | . + num_services_unknown | int | . + worst_service_hard_state | int | . + num_services_hard_ok | int | . + num_services_hard_warn | int | . + num_services_hard_crit | int | . + num_services_hard_unknown | int | . + +#### Livestatus Services Table Attributes + + Key | Type | Note + ----------------------|-----------|------------------------- + description | string | . + display_name | string | . + alias | string | same as display_name. + check_command | string | . + check_command_expanded | string | . + event_handler | string | . + notification_period | string | host with notifications: period. + check_period | string | . + notes | string | . + notes_expanded | string | . + notes_url | string | . + notes_url_expanded | string | . + action_url | string | . + action_url_expanded | string | . + plugin_output | string | . + perf_data | string | . + icon_image | string | . + icon_image_expanded | string | . + icon_image_alt | stirng | . + statusmap_image | string | . + long_plugin_output | string | . + max_check_attempts | int | . + flap_detection_enabled | int | . + check_freshness | int | . + process_performance_data | int | . + accept_passive_checks | int | . + event_handler_enabled | int | . + acknowledgement_type | int | Only 0 or 1. + check_type | int | . + last_state | int | . + last_hard_state | int | . + current_attempt | int | . + last_notification | int | service with notifications: last notification. + next_notification | int | service with notifications: next notification. + next_check | int | . + last_hard_state_change | int | . + has_been_checked | int | . + current_notification_number | int | service with notifications: number. + checks_enabled | int | . + notifications_enabled | int | . + acknowledged | int | . + state | int | . + state_type | int | . + no_more_notifications | int | notification_interval == 0 && volatile == false. + last_check | int | . + last_state_change | int | . + last_time_up | int | . + last_time_down | int | . + last_time_unreachable | int | . + is_flapping | int | . + scheduled_downtime_depth | int | . + active_checks_enabled | int | . + modified_attributes | array | . + modified_attributes_list | array | . + check_interval | double | . + retry_interval | double | . + notification_interval | double | service with notifications: smallest interval. + low_flap_threshold | double | flapping_threshold + high_flap_threshold | double | flapping_threshold + latency | double | . + execution_time | double | . + percent_state_change | double | flapping. + in_notification_period | int | service with notifications: matching period. + in_check_period | int | . + contacts | array | service with notifications, users and user groups. + downtimes | array | id. + downtimes_with_info | array | id+author+comment. + comments | array | id. + comments_with_info | array | id+author+comment. + comments_with_extra_info | array | id+author+comment+entry_type+entry_time. + custom_variable_names | array | . + custom_variable_values | array | . + custom_variables | array | Array of custom variable array pair. + hard_state | int | Returns OK, if state is OK. Returns current state if now a hard state type. Returns last hard state otherwise. + staleness | int | Indicates time since last check normalized onto the check_interval. + groups | array | All hostgroups this host is a member of. + contact_groups | array | All usergroups associated with this host through notifications. + host_ | join | Prefix for attributes from implicit join with hosts table. + +Not supported: `initial_state`, `is_executing`, `check_options`, `obsess_over_service`, `first_notification_delay`, +`pnpgraph_present`. + +#### Livestatus Servicegroups Table Attributes + + Key | Type | Note + ----------------------|-----------|------------------------- + name | string | . + alias | string | `display_name` attribute. + notes | string | . + notes_url | string | . + action_url | string | . + members | array | CSV format uses `host|service` syntax. + members_with_state | array | Host, service, hoststate, servicestate. + worst_service_state | int | . + num_services | int | . + num_services_pending | int | . + num_services_ok | int | . + num_services_warn | int | . + num_services_crit | int | . + num_services_unknown | int | . + num_services_hard_ok | int | . + num_services_hard_warn | int | . + num_services_hard_crit | int | . + num_services_hard_unknown | int | . + +#### Livestatus Contacts Table Attributes + + Key | Type | Note + ----------------------|-----------|------------------------- + name | string | . + alias | string | `display_name` attribute. + email | string | . + pager | string | . + host_notification_period | string | . + service_notification_period | string | . + host_notifications_enabled | int | . + service_notifications_enabled | int | . + in_host_notification_period | int | . + in_service_notification_period | int | . + custom_variable_names | array | . + custom_variable_values | array | . + custom_variables | array | Array of customvariable array pairs. + modified_attributes | array | . + modified_attributes_list | array | . + + +Not supported: `can_submit_commands`. + +#### Livestatus Contactgroups Table Attributes + + Key | Type | Note + ----------------------|-----------|------------------------- + name | string | . + alias | string | `display_name` attribute. + members | array | . + + +#### Livestatus Commands Table Attributes + + Key | Type | Note + ----------------------|-----------|------------------------- + name | string | 3 types of commands in Icinga 2. + line | string | . + + +#### Livestatus Status Table Attributes + + Key | Type | Note + ----------------------|-----------|------------------------- + connections | int | Since application start. + connections_rate | double | . + service_checks | int | Since application start. + service_checks_rate | double | . + host_checks | int | Since application start. + host_checks_rate | double | . + external_commands | int | Since application start. + external_commands_rate | double | . + nagios_pid | string | Application PID. + enable_notifications | int | . + execute_service_checks | int | . + accept_passive_service_checks | int | . + execute_host_checks | int | . + accept_passive_host_checks | int | . + enable_event_handlers | int | . + check_service_freshness | int | . + check_host_freshness | int | . + enable_flap_detection | int | . + process_performance_data | int | . + check_external_commands | int | Always enabled. + program_start | int | In seconds. + last_command_check | int | Always. + interval_length | int | Compatibility mode: 60. + num_hosts | int | . + num_services | int | . + program_version | string | 2.0. + livestatus_active_connections | string | . + +Not supported: `neb_callbacks`, `neb_callbacks_rate`, `requests`, `requests_rate`, `forks`, `forks_rate`, +`log_messages`, `log_messages_rate`, `livechecks`, `livechecks_rate`, `livecheck_overflows`, +`livecheck_overflows_rate`, `obsess_over_services`, `obsess_over_hosts`, `last_log_rotation`, +`external_command_buffer_slots`, `external_command_buffer_usage`, `external_command_buffer_max`, +`cached_log_messages`, `livestatus_queued_connections`, `livestatus_threads`. + + +#### Livestatus Comments Table Attributes + + Key | Type | Note + ----------------------|-----------|------------------------- + author | string | . + comment | string | . + id | int | legacy_id. + entry_time | string | Seconds. + type | int | 1=host, 2=service. + is_service | int | . + persistent | int | Always. + source | string | Always external (1). + entry_type | int | . + expires | int | . + expire_time | string | Seconds. + service_ | join | Prefix for attributes from implicit join with services table. + host_ | join | Prefix for attributes from implicit join with hosts table. + + +#### Livestatus Downtimes Table Attributes + + Key | Type | Note + ----------------------|-----------|------------------------- + author | string | . + comment | string | . + id | int | legacy_id. + entry_time | string | Seconds. + type | int | 1=active, 0=pending. + is_service | int | . + start_time | string | Seconds. + end_time | string | Seconds. + fixed | int | 0=flexible, 1=fixed. + duration | int | . + triggered_by | int | legacy_id. + triggers | int | NEW in Icinga 2. + trigger_time | string | NEW in Icinga 2. + service_ | join | Prefix for attributes from implicit join with services table. + host_ | join | Prefix for attributes from implicit join with hosts table. + + +#### Livestatus Timeperiod Table Attributes + + Key | Type | Note + ----------------------|-----------|------------------------- + name | string | . + alias | string | `display_name` attribute. + in | int | Current time is in timeperiod or not. + +#### Livestatus Log Table Attributes + + Key | Type | Note + ----------------------|-----------|------------------------- + time | int | Time of log event (unix timestamp). + lineno | int | Line number in `CompatLogger` log file. + class | int | Log message class: 0=info, 1=state, 2=program, 3=notification, 4=passive, 5=command. + message | string | Complete message line. + type | string | Text before the colon `:`. + options | string | Text after the colon `:`. + comment | string | Comment if available. + plugin_output | string | Check output if available. + state | int | Host or service state. + state_type | int | State type if available. + attempt | int | Current check attempt. + service_description | string | . + host_name | string | . + contact_name | string | . + command_name | string | . + current_service_ | join | Prefix for attributes from implicit join with services table. + current_host_ | join | Prefix for attributes from implicit join with hosts table. + current_contact_ | join | Prefix for attributes from implicit join with contacts table. + current_command_ | join | Prefix for attributes from implicit join with commands table. + +#### Livestatus Statehist Table Attributes + + Key | Type | Note + ----------------------|-----------|------------------------- + time | int | Time of log event (unix timestamp). + lineno | int | Line number in `CompatLogger` log file. + from | int | Start timestamp (unix timestamp). + until | int | End timestamp (unix timestamp). + duration | int | until-from. + duration_part | double | duration / query_part. + state | int | State: 0=ok, 1=warn, 2=crit, 3=unknown, -1=notmonitored. + host_down | int | Host associated with the service is down or not. + in_downtime | int | Host/service is in downtime. + in_host_downtime | int | Host associated with the service is in a downtime or not. + is_flapping | int | Host/service is flapping. + in_notification_period | int | Host/service notification periods match or not. + notification_period | string | Host/service notification period. + host_name | string | . + service_description | string | . + log_output | string | Log file output for this state. + duration_ok | int | until-from for OK state. + duration_part_ok | double | . + duration_warning | int | until-from for Warning state. + duration_part_warning | double | . + duration_critical | int | until-from for Critical state. + duration_part_critical | double | . + duration_unknown | int | until-from for Unknown state. + duration_part_unknown | double | . + duration_unmonitored | int | until-from for Not-Monitored state. + duration_part_unmonitored | double | . + current_service_ | join | Prefix for attributes from implicit join with services table. + current_host_ | join | Prefix for attributes from implicit join with hosts table. + +Not supported: `debug_info`.