cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

SQL Query to View All Enabled alert and its action

Jump to solution

Hello,

Can someone help me on figuring a right query/code in Orion Database to list all Enabled Advanced Alert, its description and its action?

Any help would be much appreciated.

Labels (1)
0 Kudos
1 Solution

This was kind of a beast to wrangle up since the newer version of the alert tables are a little cryptic.

This is was written to be used as a Custom Query resource

SELECT ac.Name, ac.Description, ac.ObjectType, ac.CreatedBy, aa.CategoryType, a.ActionTypeID, a.Description

FROM Orion.AlertConfigurations ac

join Orion.ActionsAssignments aa on aa.parentid=ac.alertid and aa.EnvironmentType='Alerting'

join Orion.Actions a on a.actionid=aa.ActionID

where ac.enabled=1

order by name, categorytype desc, sortorder

-Marc Netterfield

    Loop1 Systems: SolarWinds Training and Professional Services

- Marc Netterfield, Github

View solution in original post

2 Replies

This was kind of a beast to wrangle up since the newer version of the alert tables are a little cryptic.

This is was written to be used as a Custom Query resource

SELECT ac.Name, ac.Description, ac.ObjectType, ac.CreatedBy, aa.CategoryType, a.ActionTypeID, a.Description

FROM Orion.AlertConfigurations ac

join Orion.ActionsAssignments aa on aa.parentid=ac.alertid and aa.EnvironmentType='Alerting'

join Orion.Actions a on a.actionid=aa.ActionID

where ac.enabled=1

order by name, categorytype desc, sortorder

-Marc Netterfield

    Loop1 Systems: SolarWinds Training and Professional Services

- Marc Netterfield, Github

View solution in original post

Thanks Mesverrum. Your answer should be the answer of this question. It helps me a lot to get started. For me, I want to get the trigger condition as well.

0 Kudos