Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Looking for some guidance on creating a report that shows alert count for last 30 days per alert.

Would like to show a bar graph (or other visual) that depicts the count of all alerts that fired for each alert irrespective of Node.

Eg. High CPU Alert - 45 times in last 30 days

High Memory Alert - 22 times in last 30 days

Any thoughts?

Find more posts tagged with

Accepted answers

KMSigma.SWI

So, just something like this?

SELECT COUNT([AH].AlertHistoryID) AS TriggeredCount
     , [AH].Message
FROM Orion.AlertHistory AS [AH]
WHERE [AH].EventType = 0
  AND [AH].TimeStamp >= GETUTCDATE() - 30
GROUP BY [AH].Message
ORDER BY COUNT([AH].AlertHistoryID) DESC

All comments

KMSigma.SWI

So you are just looking for a summary report based on the OOTB Triggered Alerts - Last 30 Days?

danbert

Not a list of all alerts, just a summary count for each alert that fired. Preferably something I can put into a graphic for my leadership.

KMSigma.SWI

So, just something like this?

SELECT COUNT([AH].AlertHistoryID) AS TriggeredCount
     , [AH].Message
FROM Orion.AlertHistory AS [AH]
WHERE [AH].EventType = 0
  AND [AH].TimeStamp >= GETUTCDATE() - 30
GROUP BY [AH].Message
ORDER BY COUNT([AH].AlertHistoryID) DESC

danbert

Perfect, thanks.