Monthly Alert Summary

Management is asking for either a report or a dashboard showing the previous months number of alerts raised. They are wanting to see how alerts are trending.

1 Like

Under Reporting (in SCOM), check under the Microsoft Generic Report Library or Microsoft ODR Report library. Under one of those, I cannot recall which one, there should be some Alerts reports that will show you what you’re after.

1 Like

Download and import the free Veeam report library and use the “alerts statistics” report for exactly this use case scenario of spotting alert trends. Add in the “Operations Manager Agent managed computer group”, along with the “Microsoft.systemcenteragentwatchersgroup” and specify the previous month as a time range and you will get what you are looking for.

1 Like
SELECT 
  SUM(CASE datepart(month,datetime) WHEN 1 THEN 1 ELSE 0 END) AS 'January',
  SUM(CASE datepart(month,datetime) WHEN 2 THEN 1 ELSE 0 END) AS 'February',
  SUM(CASE datepart(month,datetime) WHEN 3 THEN 1 ELSE 0 END) AS 'March',
  SUM(CASE datepart(month,datetime) WHEN 4 THEN 1 ELSE 0 END) AS 'April',
  SUM(CASE datepart(month,datetime) WHEN 5 THEN 1 ELSE 0 END) AS 'May',
  SUM(CASE datepart(month,datetime) WHEN 6 THEN 1 ELSE 0 END) AS 'June',
  SUM(CASE datepart(month,datetime) WHEN 7 THEN 1 ELSE 0 END) AS 'July',
  SUM(CASE datepart(month,datetime) WHEN 8 THEN 1 ELSE 0 END) AS 'August',
  SUM(CASE datepart(month,datetime) WHEN 9 THEN 1 ELSE 0 END) AS 'September',
  SUM(CASE datepart(month,datetime) WHEN 10 THEN 1 ELSE 0 END) AS 'October',
  SUM(CASE datepart(month,datetime) WHEN 11 THEN 1 ELSE 0 END) AS 'November',
  SUM(CASE datepart(month,datetime) WHEN 12 THEN 1 ELSE 0 END) AS 'December',
  SUM(CASE datepart(year,datetime) WHEN 2018 THEN 1 ELSE 0 END) AS 'TOTAL'
FROM Alert.AlertXXXXXXXXXXXXXXXXX  WITH (NOLOCK)
WHERE datetime is not NULL AND datetime > (GetDate()-365) and  Severity=2

You could use the SQL plugin on squaredup and use the above SQL Query and run it agianst the DW-database alert table. Depending on your grooming settings you will get statistics for x months.

1 Like

You should try this way. https://noalertleftbehind.blog/2017/10/23/contextual-alert-reports-from-within-squared-up/

1 Like

Still trying to work on this I know what they want is a graph showing the number of alerts received over a period of time. They are looking to see trending that the number of alerts is going down. PRTG can do this out of the box so if I can not get management what they want they are going scrap SCOM and go to PRTG so they can have exactly what they want to see. Help please all the suggestions so far seem to be aimed at looking at specific alerts not showing the overall picture of total number of alert going out.

Hi

Check out Approved:s report tool.

https://www.youtube.com/watch?time_continue=2085&v=MmxqCA0PhH4

http://www.approved.se/tjanster/analys-rapportering (in swedish, google translate) :slight_smile: