This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

email_addr_chg_alertDefinitions.zip

These SQL scripts will search and replace ALERT DEFINITION email addresses.

Example:  original orion admin leaves and you take position.  you need to change all alerts from their email to yours.

read comments...ensure you update email addresses prior to executing AND BACKUP YOUR DATABASE FIRST!!!

test-update_actionDefinitions email addresses.sql   and

update_actionDefinitions email addresses

test.... allows you to see results of query

update... actually makes the changes

I'd recommend (per comments) you select a row to test from first script and grab the ActionDefID and replace in the where clause.

email_addr_chg_alertDefinitions.zip
Parents Reply Children
No Data