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?
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?
So you are just looking for a summary report based on the OOTB Triggered Alerts - Last 30 Days?
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
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.