• State Not Answered
  • Locked Locked
  • Replies 6 replies
  • Subscribers 23 subscribers
  • Views 840 views
  • Users 0 members are here
Options
Related
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

njoylif

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
  • 0

    OMG...it worked perfect!!!!!!
    I also had to run Title to make them match but it worked perfect njoylif!!!!

    When I get the distribution email I will run it again with that. You just made my day sir!!

    update ActionDefinitions
    set Target = replace (
    CAST(Target as nvarchar(4000)),
    'oneil_brown@campbellsoup.com', --string you are searching for - to be replaced
    'chris_stasnek@campbellsoup.com'  --string to replace found expression
    )


    Run this after the Target
    update ActionDefinitions
    set Title = replace (
    CAST(Title as nvarchar(4000)),
    'oneil_brown@campbellsoup.com', --string you are searching for - to be replaced
    'chris_stasnek@campbellsoup.com'  --string to replace found expression
    )

Reply
  • 0

    OMG...it worked perfect!!!!!!
    I also had to run Title to make them match but it worked perfect njoylif!!!!

    When I get the distribution email I will run it again with that. You just made my day sir!!

    update ActionDefinitions
    set Target = replace (
    CAST(Target as nvarchar(4000)),
    'oneil_brown@campbellsoup.com', --string you are searching for - to be replaced
    'chris_stasnek@campbellsoup.com'  --string to replace found expression
    )


    Run this after the Target
    update ActionDefinitions
    set Title = replace (
    CAST(Title as nvarchar(4000)),
    'oneil_brown@campbellsoup.com', --string you are searching for - to be replaced
    'chris_stasnek@campbellsoup.com'  --string to replace found expression
    )

Children
No Data

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.