Is it possible to bulk change SMTP settings for all configured alerts?

Subject says it all....I want to make a wholesale change for all our alerts involving email notification.

I don't really want to wade through each alert, etc.

Thanks for any info!

Find more posts tagged with

First you'd need to find the rows you want to replace within the ActionDefinitions table. This can be done by using this query:

select Target from ActionDefinitions where ActionType = 'Email'

Make note of the SMTPserver, then use that value in this statement to change it

Update ActionDefinitions

Set Target = REPLACE('mail.oldsmtpserver.domain', 'mail.newsmtpserver.domain')

Where ActionType = 'Email'

This will update all the current SMTP values with the new values for your actions.

Thanks very much!

REPLACE was asking for three arguments, so I changed up the statements a little bit and encountered success.

I appreciate the assistance.