Submit a ticketCall us

Training ClassSign up for Network Performance Monitor (NPM) and Scalability instructor-led classes

Attend our instructor-led classes, provided by SolarWinds® Academy, to discuss the more advanced monitoring mechanisms available in NPM as well as how to tune your equipment to optimize its polling capabilities. NPM classes offered:
NPM Custom Monitoring and Polling
Orion Platform Scalability

Reserve your seat.

Home > Success Center > Orion Platform > Orion - Knowledgebase Articles > Run SQL query to update node EngineID in Orion Platform

Run SQL query to update node EngineID in Orion Platform

Updated October 30, 2018

Overview

After a failed migration, nodes will be assigned to incorrect EngineID and may cause polling issues in the environment. This article describes how to fix the issue by running a SQL query on the database.

Environment

  • Orion Platform

Steps

Identify the correct EngineID

  1. Open Database Manager, and open the Engines table
  2. Run the following query:

    SELECT TOP 1000 * FROM [dbo].[Engines]

  3. Take note of the information under EngineID column 00201540_1.png

In a multi-poller environment, you may see more than one EngineID in this table. In this example, the EngineID to take note is '1'.

Update the nodes with incorrect EngineID

  1. Open another table in Database Manager, NodesData
  2. Run the following query, changing @CorrectID to match the Engines table:

    UPDATE NodesData SET EngineID = @CorrectID WHERE EngineID != @CorrectID

    00201540_2.png

With the information noted in the first screenshot, we changed @CorrectID with the number 1 to match the Engines table.

 

Last modified

Tags

Classifications

Public