SQL for the report "Availability and Health History Report for All Monitor Group" warning/critital info ??

SQL for the report "Availability and Health History Report for All Monitor Group" warning/critital info ??

Hi,

We would like to make a report vía SQL (PostgreSQL database). Our report is a mix of the SLA report and the "Availability and Health History Report for All Monitor Group".

We have found the SLA tables, and the Outages tables, but we don't find the tables where the "warning/critical Duration, Count, From and To"  info from the report  "Availability and Health History Report for All Monitor Group" are stored.

Why? Our boss need a report with one line for each monitor group, with the following information:
  - the group monitor name
  - the SLA level for the monitor group
  - the total outage time for the monitor group
  - the total warning/critical time for the monitor group

We have found the three first point, but we need the last.

Thanks in advance




















                New to ADSelfService Plus?