You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Jan 15, 2019. It is now read-only.
Assignee: gbeutner
Status: Resolved (closed on 2011-11-23 14:11:07 +00:00)
Target Version: 1.6
Last Update: 2014-12-08 14:37:26 +00:00 (in Redmine)
Planned features:
-keeping track of host/service availability statistics in a separate history table
-configuration flag (enable_sla) to enable/disable SLA data collection; defaults to 0 (disabled)
slahistory_id: unique ID for a SLA history entry
instance_id: Icinga instance ID
start_time, end_time: time interval for the history entry
acknowledgement_time: when the state was acknowledged (NULL by default)
object_id: the host/service ID this history entry is related to
state: the state during the time interval
state_type the state type
scheduled_downtime: whether the whole time interval was in scheduled downtime (a history entry are split into several entries if only a fraction of the time interval was in scheduled downtime)
This issue has been migrated from Redmine: https://dev.icinga.com/issues/2037
Created by gbeutner on 2011-10-25 11:16:14 +00:00
Assignee: gbeutner
Status: Resolved (closed on 2011-11-23 14:11:07 +00:00)
Target Version: 1.6
Last Update: 2014-12-08 14:37:26 +00:00 (in Redmine)
Planned features:
-keeping track of host/service availability statistics in a separate history table
-configuration flag (enable_sla) to enable/disable SLA data collection; defaults to 0 (disabled)
Database table layout:
CREATE TABLE IF NOT EXISTS icinga_slahistory (
slahistory_id serial,
instance_id bigint unsigned default 0,
start_time datetime default '0000-00-00 00:00:00',
end_time datetime default '0000-00-00 00:00:00',
acknowledgement_time datetime default NULL,
object_id bigint unsigned default 0,
state smallint default 0,
state_type smallint default '0',
scheduled_downtime tinyint(1) default 0,
PRIMARY KEY (slahistory_id)
) ENGINE=InnoDB COMMENT='SLA statehistory';
slahistory_id: unique ID for a SLA history entry
instance_id: Icinga instance ID
start_time, end_time: time interval for the history entry
acknowledgement_time: when the state was acknowledged (NULL by default)
object_id: the host/service ID this history entry is related to
state: the state during the time interval
state_type the state type
scheduled_downtime: whether the whole time interval was in scheduled downtime (a history entry are split into several entries if only a fraction of the time interval was in scheduled downtime)
Changesets
2011-10-28 13:45:21 +00:00 by mfriedrich c3e0acf
2011-10-31 08:17:20 +00:00 by gbeutner 3b5fc3b
Relations:
The text was updated successfully, but these errors were encountered: