How to create a report detailing configuration of all alerts that send emails.

Question

This used to work when running 10.6, since the upgrade that imported the alerts to web based this no longer works. Does anyone have report setup that will give similar output?

select AlertName, ObjectType, Alertdescription,TriggerQuery, ActionType, Title from AlertDefinitions

inner join ActionDefinitions on ActionDefinitions.AlertDefID = AlertDefinitions.AlertDefID

where TriggerAction = 1 AND Enabled = 1 AND ActionDefinitions.ActionType = 'email'

order by AlertName, SortOrder

bobmarley · Accepted Answer

SELECT ac.AlertID, ac.Name, ac.Description, ac.Enabled, ac.Severity, ac.CreatedBy, ad.TriggerQuery, ap.ActionID, ac.AlertMessage, a.Title, a.Description, ap.PropertyName, ap.PropertyValue

FROM dbo.ActionsProperties ap

LEFT JOIN dbo.ActionsAssignments aa ON ap.ActionID = aa.ActionID

LEFT JOIN dbo.Actions a ON a.ActionID = ap.ActionID

LEFT JOIN dbo.AlertConfigurations ac ON aa.ParentID = ac.AlertID

LEFT JOIN dbo.AlertDefinitions ad ON ad.AlertDefID = ac.AlertRefID

WHERE ac.Enabled='True' AND a.ActionTypeID='Email'

replace dbo with your Solarwinds database name

How to create a report detailing configuration of all alerts that send emails.

Top Replies