Skip to content
This repository has been archived by the owner on Jan 15, 2019. It is now read-only.

[dev.icinga.com #2037] SLA monitoring for idoutils #778

Closed
icinga-migration opened this issue Oct 25, 2011 · 4 comments
Closed

[dev.icinga.com #2037] SLA monitoring for idoutils #778

icinga-migration opened this issue Oct 25, 2011 · 4 comments

Comments

@icinga-migration
Copy link

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

rework sla zeugs to fit coding policy and stays disabled by default

refs #2037

2011-10-31 08:17:20 +00:00 by gbeutner 3b5fc3b

Replace fprintf() with ido2db_log_debug_info().

refs #2037

Relations:

@icinga-migration
Copy link
Author

Updated by gbeutner on 2011-10-25 11:18:13 +00:00

  • Done % changed from 0 to 80

Current status: all the required features are implemented and need to be tested; documentation is still missing

@icinga-migration
Copy link
Author

Updated by mfriedrich on 2011-11-15 17:14:12 +00:00

a final full test is required.

  • get icinga 1.5.x db and perform the db upgrade scripts
  • do a fresh install with current db sqls
  • run it against databases and check that the table data is correct

@icinga-migration
Copy link
Author

Updated by mfriedrich on 2011-11-23 14:11:07 +00:00

  • Status changed from New to Resolved
  • Done % changed from 80 to 100

for now, resolved. future feedback = new issues, related to over here.

@icinga-migration
Copy link
Author

Updated by mfriedrich on 2014-12-08 14:37:26 +00:00

  • Project changed from 18 to Core, Classic UI, IDOUtils
  • Category changed from 79 to IDOUtils

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant