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