When I am deactivating a user I get a warning to say that they are included in email alerts and so cannot be deactivated. However, as I have hundreds of email alerts set-up, it is not practical to go through each one manually to find the offending alert/s. Additionally it is not possible to display the recipient of the alert in the email alerts list view. Therefore i need to be able to query or report on the email alert object to find this information. How can I report on email alerts and show the recipient value for the alert.

Attribution to: Bart

Possible Suggestion/Solution #1

You could do this by searching your workflows metadata. For example in an Eclipse project you could use the file search functionality to search for the user email in all the *.workflow files in your current project.

Attribution to: melmoussaoui
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/33684