nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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
Store

How to Query ACtive Alert for weekly basis

basilfernandaz

Dears

Thansk for the wonderful community

What is the query we can fetch the active alerts on weekly basis , ? kind of historical data

Thanks for your response.

Find more posts tagged with

Accepted answers

All comments

m_roberts

There is an out the box report 'Triggered Alerts - Last 30 Days web-based'. If you need anything specific in your output, use this as a starting point by duplicating it and extending.

Come back if you need help.

basilfernandaz

Thanks for your response ,

Can you share the SWQL Query for fetching the active alerts - weekly basis pls

basilfernandaz

Can you also share the sQL query to fetch severity of all ACtive Alarms

christopher.t.jones123

@basilfernandaz, take a look at this query found in the content exchange. In the future, the Content Exchange is a great place to start looking when trying to find queries, reports, etc.

basilfernandaz

Dear Christopher , Thanks for the response ,

I have the below query to fetch the severity of the active alerts ,

SELECT o.AlertActive.TriggeredDateTime AS [ALERT TRIGGER TIME] ,CASE WHEN o.AlertConfigurations.Severity = 1 then 'Critical' WHEN o.AlertConfigurations.Severity = 2 then 'Serious' WHEN o.AlertConfigurations.Severity = 3 then 'Warning' WHEN o.AlertConfigurations.Severity = 4 then 'Informational' WHEN o.AlertConfigurations.Severity = 5 then 'Notice' END AS [Severity] FROM Orion.AlertObjects o WHERE o.AlertActive.TriggeredMessage <> ''

What i would need to do is , to group by Severity / Count the severity so that Critical /Warning/Serious/Informational/Notice will have an aggregated information .

Can you please help me with incorporating this severity aggregating data please

Thanks in advance.

basilfernandaz

attached the snapshot of the existing query to fetch severity. attachment fyi.

Once i get aggregated data ......i can feed ito create pie chart .

christopher.t.jones123

@basilfernandaz, try this query

SELECT count(o.AlertActive.TriggeredDateTime) AS [ALERT TRIGGER TIME] 
,CASE 
WHEN o.AlertConfigurations.Severity = 1 then 'Critical' 
WHEN o.AlertConfigurations.Severity = 2 then 'Serious' 
WHEN o.AlertConfigurations.Severity = 3 then 'Warning' 
WHEN o.AlertConfigurations.Severity = 4 then 'Informational' 
WHEN o.AlertConfigurations.Severity = 5 then 'Notice' 
END AS [Severity] 
FROM Orion.AlertObjects o 
WHERE o.AlertActive.TriggeredMessage <> ''
GROUP BY O.AlertConfigurations.Severity