Version 1

    What is the best way to bulk 'replace' Alert recipient e-mail?


    We have 200 alerts which sends email as an alert action to our support team e-mail. Due to a recent change in the Company's team structure, my task is to replace this e-mail account with a new one. What should be my best approach, Action Manager SDK or something else?


    I've tried using Action Manager but I have same action name for all 800 alerts.


    Thanks in advance.






    Update [dbo].[ActionsProperties]

    Set PropertyValue= REPLACE(PropertyValue,,'')


    (PropertyName='EmailTo' or PropertyName=’EmailFrom’ or PropertyName=’EmailCC’)