Welcome to Community Answers

Question

Solved Alert SQL Queries and perspectives

0

jaspervd 466 Rep. 06 Oct, 2017

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

jaspervd selected answer 16 Oct, 2017

To reply or comment, use the 'Comment' link on the relevant answer or question.

score 0 · Answer 1 · 2017-10-06T11:13:06+00:00

0

jannep 1.08K Rep. 06 Oct, 2017

You could start here for some tips for SQL queries:

SCOM SQL queries

http://www.itserviceanalytics.com/2015/10/querying-distributed-application-data-from-scom-data-warehouse-2/

jaspervd selected as best answer 16 Oct, 2017

jaspervd - 09 Oct, 2017

Hey Jannep, Thanks for the tip. I am currently looking at reverse engineering the generic alerts reports. Apparently it triggers a stored procedure which contains the SQL query I need. Just need to make some changes to the parameters (like MonitoredEntityRowId) that can hopefully be fulled in through Squared Up. Br, Jasper