Network Management

Change nodes polling engine ID in the SolarWinds Platform using the database manager.

This article describes how you can assign nodes to the correct Polling engine or moving nodes from one Polling Engine to another using the database manager.

First published date

10/16/2018 9:34 AM

Last published date

6/30/2025 2:41 PM

Overview

This article describes how to change the nodes' polling engine ID when you are prompted with the following warning message during the Configuration Wizard and/or a migration is performed.

Multiple polling engines detected. The database you have selected is currently being used by another SolarWinds application at (Orion Server Name) Do you still want to use the selected database?

 

Product section

Network Performance Monitor

Resolution

Please note the following for all SQL queries below:

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

In SolarWinds Platform 2022.3 and newer, the EngineID column is a key and can't be edited directly; the NodesData table will need to be updated to match the EngineID instead.

  1. Stop all Orion services using the Orion Service Manager.
  2. Go to All Programs > SolarWinds Orion > Database Manager
  3. Run the following query:
    SELECT TOP 1000 * FROM [dbo].[Engines]
    1. Pull the EngineID and run the final query adding the correct EngineID to update all nodes.
    2. Run this query:
      Update [dbo].[Engines] set EngineId = 'NumberGoesHere'

Where EngineId =  'NumberGoesHere'
      • To update the NodesData table in SolarWinds Platform 2022.3 and newer:
      Update NodesData Set EngineID = (the new polling engine ID you want to move the nodes to)
Where EngineID = (the old polling engine ID)
Sample: --Update NodesData Set EngineID = 4 Where EngineID = 2
      1. Start all services using Orion Service Manager.(All Programs > Solarwinds Orion > Orion Service Manager)