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?

Br,

Jasper