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) > SQL Query to find duplicate IP addresses

SQL Query to find duplicate IP addresses

Table of contents
Created by Norsolihati Selamat, last modified by Aileen de Lara_ret on Aug 30, 2016

Views: 974 Votes: 0 Revisions: 8

Overview

 Find duplicate IP addresses using SQL query.

Environment

All Orion Core products

Detail

Use the following SQL query:

 

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

 


This will return the number of duplicates a specific IP Address has.

 

If the above SQL query return a lot of duplicates, it will be useful to pick out just the entries that are seeing this issue by running the following SQL query:

 

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

 

 

 

 

Last modified

Tags

Classifications

Public