Submit a ticketCall us

WebinarDatabase Roundtable – Expert Database Professionals Feel Your Pain

In this video broadcast, Head Geek™ Tom LaRock is joined by Karen Lopez, Tim Chapman, and David Klee. They’ve known each other for many years, so this discussion was like four friends getting together to talk data and databases. They discussed diagnostic data collection, common performance root causes, reactive tuning versus proactive, and more. Join us for an engaging discussion on these topics! Plus, Tom LaRock will be available to answer your questions live.

Register now.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Change the SMTP server name in NPM

Change the SMTP server name in NPM

Table of contents
Created by Ezgi Muderrisoglu, last modified by MindTouch on Jun 23, 2016

Views: 2,297 Votes: 2 Revisions: 8

Overview

This article provides information on how to change the SMTP server name using the Advanced Rules option without going through the properties of each rule.

Environment

NPM v11.5.2 and earlier versions

Steps

There are three different ways to change the SMTP server name:

  1. Change the SMTP server information in each of the alerts.
  2. Change the information as explained in the SMTP Configuration and Email Settings for Scheduled Reports and Alerts article.
    Setup the default SMTP server and then within the alerts, make sure that the use default SMTP server option is selected. However, this needs to be done for all of the other alerts.
    Note: You need to provide one recipient and one sender when doing this as this is mandatory.
  3. The third way is a workaround - changing the SMTP server directly from the database by SQL query. Notes:
    • Please be aware that this is not a supported way and you should only perform this at your own risk. 
    • Backup your database before making any changes.
    • Follow steps below:
      • Stop all Orion services.
      • Start SQL Server Management Studio
      • Run the following query to apply change:
        declare @oldServerName As Varchar(255)
        declare @newServerName As Varchar(255)
        set @oldServerName = 'OLD_SERVER_NAME'
        set @newServerName = 'NEW_SERVER_NAME'
        update [dbo].[ActionDefinitions]
        set [Target] = REPLACE(CAST( [Target] AS VARCHAR(MAX)),'SMTPSERVER:'+@oldServerName,'SMTPSERVER:'+@newServerName)
        WHERE Target like '%SMTPSERVER:%'
        

        NOTE:

        Replace OLD_SERVER_NAME with the hostname or IP address of your old SMTP server

        Replace NEW_SERVER_NAME with the host name or IP address of your new SMTP server

      • Run the following query to verify change.
        select * from [ActionDefinitions]
      • Start all Orion services.
Last modified

Tags

Classifications

Public