Friday, July 25, 2025

 Quick little query to find what Alerts in SolarWinds email to an email address. This can be used SolarWinds DB Manager. 


SELECT

    ac.Name AS AlertName,

    ac.Enabled As Alert_Enabled,

    ap.PropertyName AS Property,

    ap.PropertyValue AS PropertyValue

FROM

    [dbo].AlertConfigurations ac

INNER JOIN

    [dbo].ActionsAssignments aa ON ac.AlertID = aa.ParentID

INNER JOIN

    [dbo].ActionsProperties ap ON aa.ActionAssignmentID = ap.ActionID

WHERE

    ap.PropertyValue Like '%<email minus domain>%'