SQL Query to View All Enabled alert and its action

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.

Find more posts tagged with

Accepted answers

mesverrum

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.DescriptionFROM Orion.AlertConfigurations acjoin Orion.ActionsAssignments aa on aa.parentid=ac.alertid and aa.EnvironmentType='Alerting'join Orion.Actions a on a.actionid=aa.ActionIDwhere ac.enabled=1order by name, categorytype desc, sortorder

-Marc Netterfield

Loop1 Systems: SolarWinds Training and Professional Services

LinkedIN: Loop1 Systems
Facebook: Loop1 Systems
Twitter: @Loop1Systems

All comments

mesverrum

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.DescriptionFROM Orion.AlertConfigurations acjoin Orion.ActionsAssignments aa on aa.parentid=ac.alertid and aa.EnvironmentType='Alerting'join Orion.Actions a on a.actionid=aa.ActionIDwhere ac.enabled=1order by name, categorytype desc, sortorder

-Marc Netterfield

Loop1 Systems: SolarWinds Training and Professional Services

LinkedIN: Loop1 Systems
Facebook: Loop1 Systems
Twitter: @Loop1Systems

san.tran

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.

cmatrask

THank you for the query! Works excellently! THank you again for sharing!