Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

Home > Success Center > Network Performance Monitor (NPM) > Find duplicate IP address in NPM 12 Database

Find duplicate IP address in NPM 12 Database

Table of contents
Created by Roie.Exconde, last modified by Aileen de Lara_ret on Jul 18, 2016

Views: 1,201 Votes: 0 Revisions: 2

Updated July 18, 2016


This article provides steps to check duplicate IP addresses in NodesData table in the NPM database. 


NPM version 12


1. Click Start >Programs > Solarwinds Orion >Advanced Features > Database Manager.

2. Expand Orion Database.

3. Right click Nodes >Query Table, and then select Read-write(results can be edited) Find Duplicate Entries of the same Node.

a. Find duplicate IP Addresses in your nodesdata table:

FROM Nodesdata 
WHERE IP_Address IN (SELECT IP_Address
FROM Nodesdata
GROUP BY IP_Address 


b. Find 'bad' Ip addresses in the NodesData table:
Note: this will pick up some "Unknown" entries as well. This is normal when assigned to DHCP nodes.

select NodeID, IP_Address, Caption
From Nodesdata
Where IP_Address not like '%.%.%.%' or IP_Address like '%.%.%.%.%'





Last modified