Updated November 29, 2016
This article provides steps to discover the existence of duplicate nodes in your SolarWinds database.
All Orion Platform products
Run the following SQL query against your SolarWinds database, using either SQL Server Management Studio (recommended) or Database Manager:
Note: SolarWindsDatabaseName is the name of your SolarWinds database.
USE SolarWindsDatabaseName
Select IP_address, count(*)
FROM NODES
GROUP BY IP_address
Having COUNT (*)>1
The result will be a list of IP addresses that are each assigned to multiple monitored nodes. Use Node Management in the web console to delete duplicates by IP address.