Change SMTP server in all alerts

i have the same problem and would also like to see a solution to this

seems that users have alread complained about this 2 years ago but still no solution, or am i mistaking ?

Howdy--

I've marked this for the Product Manager to get it added to the feature request list if it isn't already.

M

A quick and dirty solution is to either add a CNAME or another A record in your DNS with old name if you're using the server name in your alerts.

Just a thought.

A quick followup on this solution.  If you don't have control of DNS you could also make a host entry with the old server name on the machine itself.  Be sure to document that though.

I'm not a fan host entries, bu tthey can be useful in certain situations.

It would be great if specifying multiple SMTP servers is possible.  I have redundant routes for some servers so this would help me out for sure.

good idea dude!!!  other tools have that, even Kiwi cattools...

the SMTP route should be specified outside the alert, somewhere more global, and indeed have a backup route with a time out

cheers

dan

Apparently SolarWinds just doesn't care about this issue.  It's ridiculous that we spend so much money on a company that just doesn't listen to it's users.  I've worked with other monitoring software and all have global settings for smtp servers.  At this point I can't recommend SolarWinds with all it's flaws.  Adding a CNAME to DNS is not a solution but a work around.

sstokic-

I hear your frustration here. I will email the PM and ask him to get back to you promptly to address your issues.

Thank you for your feedback. It helps us to improve and it is listened to.

M

you could use SQL like this:

Use NetPerfMon
UPDATE    [ActionDefinitions]
SET       [ActionDefinitions].[Target] = cast(REPLACE(cast([ActionDefinitions].[Target] as varchar(500)),'SMTPServer:1.1.1.1','SMTPServer:2.2.2.2') as Text)
FROM      [ActionDefinitions]
Where     [ActionDefinitions].[Target] like '%SMTPServer:1.1.1.1%'

netlogix, thanks for your post.

We talked with SW development and below is a script to try to replace an SMTP Server. Please note the following:

• Run any backups to protect your system before running this query.
• The file attached should only target alerts actions that have an SMTPserver specified.
• Changes are done on pattern matching basis. This means that for instance if you change ‘SMTPServer’ to ‘SMTPSERVER_1,’ this will unfortunately also affect any server that might have been named ‘SMTPSERVER1’ , ‘SMTPSERVER2’ , which will be renamed to ‘SMTPSERVER_11’, ‘SMTPSERVER_12’, etc.

/****** Script for SelectTopNRows command from SSMS  ******/

declare @oldServerName As Varchar(255)

declare @newServerName As Varchar(255)

set @oldServerName = 'localhost2'

set @newServerName = 'localhost'

update [dbo].[ActionDefinitions] set [Target]  = REPLACE(CAST( [Target] AS VARCHAR(MAX)),'SMTPSERVER:'+@oldServerName,'SMTPSERVER:'+@newServerName) WHERE Target like '%SMTPSERVER:%'

select * from [ActionDefinitions]

Please post back with your feedback after you use this. 

Thanks,

M