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.

     

     

    Answer:

     

     

    Update [dbo].[ActionsProperties]

    Set PropertyValue= REPLACE(PropertyValue,OldEmail@domain.com,'NewEmail@domain.com')

    Where

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