What Alerts Could Trigger on Node X?

Does anyone have a good method for determining all possible alerts a specified node could trigger? I have about 300 alerts, and I need to spot check certain nodes to see what alerts could be triggered.

For example, lets say I provide N:1234, I would want to see a list of alerts that particular node might trigger, including child elements (V, I, AM, AA, UnDPs, ...).

Has anyone written a report or tool that could do this for me?

Find more posts tagged with

Reports

alert reports

Alerts

Accepted answers

All comments

neomatrix1217

On the Node details page click customize page on the far upper right and add the resource all alerts this object can trigger.

lag

This is helpful, but not exactly what I'm looking for. What I'd really like is the underlying SWQL or SQL.

jhandberg

That list hasn't been reliable for us. This may be because of how we set up alerts for different agencies/departments where the node selection is by whether or not it has "this" custom property and belongs to "that" support group. Then those alerts don't show up on the node page, even though they will trigger if that node has that alert condition. Maybe it is the combination of custom property requirements causing this, I don't know. I see some alert listed, but not all of them, and some particular is missing from all the nodes in the trigger list. I have seen the missing ones trigger though.

xtraspecialj

I'm trying to do the same thing. Did you ever find the SQL/SWQL that runs the "Alerts this Object Can Trigger" resource?

I feel like I'd seen it before either in one of the asp files in the InetPub folder of the website or in a log file, but I've tried turning logging up and dug through the files but I couldn't find a query anywhere. I need to create a report for a certain subset of nodes and all of the alerts they could trigger on, but until I find/create this query I won't be able to.

maclu

Success Center

Shows that this Node Details item just has alerts that has fired on the nodes - NOT alerts that could fire on this node.

xtraspecialj

Are you using the Scope section of the alert's Trigger Condition to filter the custom properties, or are you putting all of your filter values in the Actual Trigger Condition section of the Trigger Condition page? The "All Alerts this Object Can Trigger" widget relies on the Scope section of Trigger Conditions. If you don't properly use those, you won't get accurate data.

tmn_m

I also found this documentation about the alert widget, it actually uses the alert history table, so if the alert hasn't ever been triggered it won't show up yet.

https://support.solarwinds.com/SuccessCenter/s/article/All-alerts-this-object-can-trigger-resource