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 show duplicate nodes

SQL query to show duplicate nodes

Table of contents
Created by Roengen Mendoza, last modified by Rodim Suarez on Mar 07, 2017

Views: 1,217 Votes: 0 Revisions: 6

Updated March 7, 2017


The following are some steps that can be used to detect instances of having duplicate nodes on your Orion database.



  • NPM 11.0
  • NPM 11.5
  • NPM 11.5.2
  • NPM 11.5.3
  • NPM 12


  1. Open the Database Manager > Add Default Server.
  2. Right click on the Orion Database and select New query.
  3. Run and execute the following query

    SELECT NodeID, ObjectSubType, IP_Address, Caption, DNS, count(*) FROM [dbo].[NodesData]
    group by NodeID, ObjectSubType, IP_Address, Caption, DNS
    having count(*)>1

  4. Search criteria (highlighted in yellow) can either NodeID,  IP_Address, Caption or DNS which ever attribute applies on your searching.

On below example, I used ObjectSubType as search field providing information on all ICMP, SNMP and WMI counts/duplicates.

SELECT ObjectSubType, count(*) FROM [dbo].[NodesData]
group by ObjectSubType
having count(*)>1



Last modified