6 Replies Latest reply on Jun 2, 2016 9:48 AM by dsweir

Making changes to Solarwinds database

dsweir Jun 2, 2016 7:56 AM

Here's my predicament. Previous employee has their email address on hundreds of syslog and alert rules. Would it be safe to have our SQL DBA's do a mass replace to the all the tables within the solarwinds database to replace previous employee's email address with another?

Don't really want to spend the hours manually changing the email address on the all those rules.

Thanks.

Re: Making changes to Solarwinds database

john.ta Jun 2, 2016 8:32 AM (in response to dsweir)

I don't see any reason it wouldn't work. A word of advice, however...don't update former employees e-mail address with your own. Replace it with one of a mailing list i.e. solarwindsalerts@company.com and that way you'll never have to do this again.
Like (1)

Actions
- Re: Making changes to Solarwinds database
  
  dsweir Jun 2, 2016 8:46 AM (in response to john.ta)
  
  Thanks John. I didn't think it would be a problem, just wanted to verify before I pulled the trigger. As I sent my initial question, I forgot that syslog alerts/rules can be exported, but only one at a time and not all at once.
  
  Like (0)
  
  Actions
  - Re: Making changes to Solarwinds database
    
    john.ta Jun 2, 2016 8:47 AM (in response to dsweir)
    
    To be safe, have them do it to one alert and verify before making change globally
    
    Like (1)
    
    Actions
    - Re: Making changes to Solarwinds database
      
      dsweir Jun 2, 2016 8:49 AM (in response to john.ta)
      
      Of course .
      
      Like (0)
      
      Actions
Re: Making changes to Solarwinds database

Jfrazier Jun 2, 2016 9:42 AM (in response to dsweir)

Change your alerts to reference a custom property and place the email address there...then you have 1 place or fewer places to have to update and not having to re-touch every alert rule.
1 of 1 people found this helpful
Like (2)

Actions
Re: Making changes to Solarwinds database

dsweir Jun 2, 2016 9:48 AM (in response to dsweir)

Didn't think of that, thanks!
1 of 1 people found this helpful
Like (0)

Actions

Go to original post