Hello Everyone,

I’m looking into creating additional perspectives on a distributed application where you can query the data warehouse for the following:

  • How many alerts that DA has generated in the last month (scalar SQL query)
  • Which alerts were generated by that that DA. (filtering on monitor/rule critical/warning/informational) (Regular SQL)
  • State changes done by that DA. (Regular SQL)

This would allow managers to see the SLA of the application, which alerts have occurred and how many.

Problem is I do not have the SQL queries at hand, so I’m wondering if anyone else has done something similar to get me started?



jaspervd selected answer