Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

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,765 Votes: 0 Revisions: 2

Updated July 18, 2016

Overview

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

Environment

NPM version 12

Steps

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:

SELECT * 
FROM Nodesdata 
WHERE IP_Address IN (SELECT IP_Address
FROM Nodesdata
GROUP BY IP_Address 
HAVING COUNT(*) > 1)

 

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

Tags

Classifications

Public