Audit Report for when your manager's ask about what alerts are active and what they do, who they email, etc.
I have joined from AlertDefinitions & AlertActions Tables...I learned this today as I did this, so Njoy as much as possible. Focus is on Enabled Alerts and the Email Action of the Alert.
Breakdown is as follows :
ActionDefinitions.ActionType as ActionType,
ActionDefinitions.Title as Title,
ActionDefinitions.Target as Target,
ActionDefinitions.Parameter1 as AlertMsgTitle,
ActionDefinitions.Parameter2 as AlertMsg,
ActionDefinitions.Parameter3 as AlertEmailFrom
left join ActionDefinitions on (AlertDefinitions.AlertDefID = ActionDefinitions.AlertDefID)
where (enabled = 'True' and ActionType='Email')
order by enabled, ObjectType, AlertName, AlertDescription, TriggerQuery asc