SLA Reporting Enhancements

[jwilliams-shadowsoft]

Is your feature request related to a problem? Please describe.

There are a number of enhancements that would make the Host and Service SLA reporting more useful. I list the enhancements contemplated here, but they could be divided into several feature requests.

• Reporting on planned v. unplanned outages.
• Reporting based on an ad-hoc time interval (selected at report runtime).
• Reporting based on Host State (UP / DOWN) or Service State (OK / WARNING / CRITICAL / UNKNOWN).
• Reporting based on time available or unavailable in addition to percentage.
• Filtering based on Service Names (unclear if there is a way to do this currently).

It is unclear to me whether the data required to compute all of these report variants is available in the IDO database schema.

Describe the solution you'd like

• Inputs:
  • Show planned v. unplanned outages: Yes / No
  • Show Host states: Yes / No (if Host SLA report)
  • Show Service states: Yes / No (if Service SLA report)
  • SLA format: Time & percentage / Time only / Percentage only
  • Start Date (override): datetime
  • End Date (override): datetime

Clearly not all of these would have to be implemented at once.

Describe alternatives you've considered

• For ad-hoc time intervals I have instructed my customer on how to construct a time interval and then to assign it to a report. This is not, however, the same as ad-hoc time interval where you would be able to specify the interval at report run time (obviously not when run automatically by the daemon).

Additional context

I have worked up some design prototypes in Numbers to show how some of this could be displayed. Additionally some graphs could be provided interactively in another pane. The ones I show are trivial, but the donut graph could be displayed in a separate pane if the user were to click on the Host or Service

Host SLA report with all the features turned on:

Service SLA report with all features turned on filters on Service "disk":

Service SLA report with all features turned on filtered on Host "adam":

PDF with all concept images:
SLA-Report.pdf