2 Replies Latest reply on Jul 27, 2017 11:42 AM by bslobodn

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


      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