WHAT IS THE BEST WAY TO BULK 'REPLACE' ALERT E-MAIL ?

mudassir

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'
            )

sean.nyhan

Syntax above is with the wrong ’

Should be:

Update [dbo].[ActionsProperties]
Set PropertyValue= REPLACE(PropertyValue,'OldEmail@domain.com','NewEmail@domain.com')
Where
(PropertyName='EmailTo' or PropertyName='EmailFrom' or PropertyName='EmailCC')