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?