Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Find and update email address in To:, cc: and bcc: fields of email alerts.

I have quite a few email alert actions using email addresses that need to be changed (Need to change email address in the To:, CC:, or BCC: fields). Using SWQL studio I have found the fields in the Orion.ActionProperties and Orion.Actions tables. I was wondering if I can use some sort of update SQL or SWQL code to find and replace the email addresses without manually going through the web gui.

Find more posts tagged with

Accepted answers

All comments

cjfranca

I think so, makes a backup, and then tries to put the result with the details of the settings. Please, I was curious about it.

njoylif

not supported; obviously backup your DB prior to doing any work...

check what you will be changing.... by highlighting all below....update by select from bottom to beginning of Update

select *

-- update ap SET PropertyValue=Replace(propertyvalue,'<email to change>','<new/updated email>'

from actionsproperties ap where

propertyvalue like '%<email to change>%' and

propertyname like 'email%'