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

Dashboard to calculate the number of Active Critical and Warning alerts

Hi All, Hi everyone, I hope you all are doing well. Currently I'm trying to have a Dashboard in my enviroment to display the number of Active alerts between Critical Alerts and Warning Alert, but for some reason that I cannot see in my code it is not bringing the correct numbers of active alerts for each of them. Would someone spotting the issue, please? thanks!

Find more posts tagged with

Accepted answers

All comments

Seashore

I can't see your code error either ;-)

But below should give you nr of alerts per severity:

SELECT 
    Count(AA.AlertActiveID) AS QTY
    ,AA.AlertObjects.AlertConfigurations.Severity
FROM Orion.AlertActive AS AA
Group BY AA.AlertObjects.AlertConfigurations.Severity

Want text instead of severity number?

SELECT 
    Count(AA.AlertActiveID) AS QTY
    ,CASE
        WHEN AA.AlertObjects.AlertConfigurations.Severity=1 THEN 'Warning'
        WHEN AA.AlertObjects.AlertConfigurations.Severity=2 THEN 'Critical'
        WHEN AA.AlertObjects.AlertConfigurations.Severity=3 THEN 'Serious'
        WHEN AA.AlertObjects.AlertConfigurations.Severity=4 THEN 'Notice'
    END AS Severity
FROM Orion.AlertActive AS AA
Group BY AA.AlertObjects.AlertConfigurations.Severity

Adjust the code for your need and wishes