Network Management

Update EngineID on IPAM Subnets

This article describes how to update the IPAM_Group table to ensure subnets are able to poll as expected

First published date

11/1/2019 1:34 PM

Last published date

6/1/2022 5:18 PM

Overview

With the release of IPAM 4.6 and newer versions, IPAM can be installed on APEs.  This sometimes causes an issue with the EngineIDs not being properly translated in the database, leading to orphaned subnets where polling does not complete. 

Product section

IP Address Manager

Cause

Possible Causes
  • Subnets are added to an APE but the EngineID is not properly updated in the IPAM_Group table.
  • Improper migrate where a new EngineID is created on the Engines Table, and the EngineID in IPAM_Group was not updated.

Resolution

  1. Back up the Orion database through SQL Server Management Studio.
  2. Establish a remote connection to the Orion Server.
  3. Open Database Manager and Add Orion Server.
  4. Expand the database and open the IPAM_Group table.
  5. Run the following query, Where XX is the new EngineID and YY is the old EngineID  
    -- 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

UPDATE IPAM_Group SET EngineID = 'XX' where EngineID = 'YY' AND GroupType = 8

-- or

UPDATE IPAM_Group SET EngineID = 'XX' WHERE EngineID = 'YY'
  6. Check the web console to confirm the updated Subnets are polling.