I need a Report that shows which Alerts use a particular Custom Field for Nodes. I've gone over the canned Reports and come up empty. Can anyone help me put together a SQL or SWQL query that will hunt out which Alerts use a certain Custom Field?
This is a significant request considering the alert logic is stored in XML within SQL/SWQL.
That said, you could probably just query the API entity Orion.AlertConfigurations for the exact name of the Custom Property and have a good jumping off point.
Orion.AlertConfigurations
Did a similar thing here: Finding NULL values in alert trigger conditions - Alert Lab - The Orion Platform - THWACK (solarwinds.com)