Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

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 on Jul 18, 2016

Views: 3 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
21:58, 17 Jul 2016

Tags

Classifications

Public