Submit a ticketCall us

AnnouncementsCome see SolarWinds at VMUG Frankfurt

SolarWinds is delighted to attend the upcoming VMUG which will take place at Kap Europa in Frankfurt on June 19th, 2018.

See event details.

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: 1,104 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