This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

How to find advanced alert actions in the database?

Does anyone know where I can find the advanced alert actions in the database, or on the server?


I am trying to find a way to search through the advanced alerts and determine which alerts are sending emails to a certain address.
I tried looking in the 'AlertLog' table, but that only contains alerts that were fired, and not how all alerts are configured.


We have a lot of alerts, and it would be a huge pain to have to go through each one and check.

  • To answer my own question:

    SELECT AlertName, Title, Target

    FROM ActionDefinitions

      INNER JOIN AlertDefinitions ON ActionDefinitions.AlertDefID = AlertDefinitions.AlertDefID

    WHERE ActionType = 'EMail'

    AND Target LIKE '%<address>%'

    ORDER BY AlertName

    Replace <address> with the email address