Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > 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,506 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