Submit a ticketCall us

Quickly Address Software Vulnerabilities
Patch Manager is an intuitive patch management software which extends the capabilities of WSUS and SCCM to not only patch Windows® servers and workstations, and Microsoft® applications, but also other 3rd-party applications which are commonly exploited by hackers. Learn more about our patch management solution.

 

Home > Success Center > Network Performance Monitor (NPM) > Manually mass update the SMTP server configured on Alerts

Manually mass update the SMTP server configured on Alerts

Table of contents
Created by John Salvani, last modified by MindTouch on Jun 23, 2016

Views: 24 Votes: 3 Revisions: 5

Overview

This article provides steps on how to manually update the SMTP server configured on all Alerts present in your Orion NPM.

Environment

NPM version 10.6 to 10.7

Steps

To do this, you can use either of the following methods below:

Note: Back up your Solarwinds Database first before performing these steps. 

 

Via SQL Management studio:

  1. Using SQL Server Management Studio, log in to your SQL Server using an account with sysadmin (SA) privileges.
  2. On your SQL Server, open SQL Server Management Studio (clickStart > All Programs > Microsoft SQL Server > SQL Server Management Studio).
  3. Using an account with the sysadmin role, log in to the SQL Server instance hosting your SolarWinds database.
  4. Click + to expand Databases > YourSolarWindsDatabase.
  5. Click New Query.
  6. Enter the following query in the query field (make sure to replace the value with the correct SMTP IP address):

update [dbo].[ActionDefinitions]
set Target = CAST(REPLACE(CAST(Target as NVarchar(MAX)),'SMTPServer:old.smtp.server.here','SMTPServer:new.smtp.server.here') AS NText)
where CAST(Target AS nvarchar(max)) like '%SMTPServer:old.smtp.server.here%';

 

Via Database Manager:

  1. Open the Database Manager in Solarwinds Orion folder. Go to Start > Solarwinds Orion > Advanced Features > Database Manager.
  2. ClickAdd Server (add the Orion Server).
  3. Log in using your SQL SA account or Solarwinds SQL account.
  4. Right-click on SolarWindsOrion Database (make sure to replace the value with the correct SMTP IP address):

 update [dbo].[ActionDefinitions]
set Target = CAST(REPLACE(CAST(Target as NVarchar(MAX)),'SMTPServer:old.smtp.server.here','SMTPServer:new.smtp.server.here') AS NText)
where CAST(Target AS nvarchar(max)) like '%SMTPServer:old.smtp.server.here%';

   5. Press Execute Query.

 

 

Last modified
22:39, 22 Jun 2016

Tags

Classifications

Public