question

DD-6838 avatar image
0 Votes"
DD-6838 asked DD-6838 answered

SCOM 2019 Report for Closed alerts per week or a day

Is there a good report available online or a SQL query to the Data Warehouse to show all Closed Alerts per week and the user who closed them. The built in reports won't allow you to specify resolution state. I found an Article by Kevin Holman but I need weekly and daily report for all closed alerts to include the Alert name the user who closed it and the date...

msc-operations-manager
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

StoyanChalakov avatar image
0 Votes"
StoyanChalakov answered

Hi,

there are plenty of them, but it would be hard to find one that is 100% matching your requirments. You will have to dev it yourslef. I have currently no access to SCOM, but I would start like this:

 --To view a count of all alerts closed by all users:
 select statesetbyuserid, count(*) as 'Number of Alerts' 
 from Alert.vAlertResolutionState ars 
 where resolutionstate = '255' 
 group by statesetbyuserid 
 order by 'Number of Alerts' DESC

You can add additional resolution states here.
After you check the results, you could limit the results byy using filtering coondition on the time frame.

This comes again from Kevin.


(If the reply was helpful please don't forget to upvote or accept as answer, thank you)
Regards,
Stoyan



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DD-6838 avatar image
0 Votes"
DD-6838 answered

Stoyan,

I already have this but it doesn't even allow you to specify for a specific timeframe. Like if i want to list closed alerts for this week. Veeam has a report library that has a report for alerts but its not very helpful either. In your query I would need it to show the name of the alert and also timeframe like for the last week. How would this query look like ?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.