Alerts_-_Currently_Enabled.OrionReport

Version 2

    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 :

     

    SELECT

      ObjectType,

      AlertName,

      AlertDescription,

      TriggerQuery,

      ActionDefinitions.ActionType as ActionType,

      ActionDefinitions.Title as Title,

      ActionDefinitions.Target as Target,

      ActionDefinitions.Parameter1 as AlertMsgTitle,

      ActionDefinitions.Parameter2 as AlertMsg,

      ActionDefinitions.Parameter3 as AlertEmailFrom

     

    FROM [dbo].[AlertDefinitions]

    left join ActionDefinitions on (AlertDefinitions.AlertDefID = ActionDefinitions.AlertDefID)

     

    where (enabled = 'True' and ActionType='Email')

     

    order by enabled, ObjectType, AlertName, AlertDescription, TriggerQuery  asc