Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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: 124 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
20:06, 29 Aug 2016

Tags

Classifications

Public