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.

    bslobodn

      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