Submit a ticketCall us

AnnouncementsTHWACKcamp 2018 is here

2018 is the seventh year for THWACKcamp™, and once again we’ll be live October 17 – 18 with packed session tracks covering everything from network monitoring and management, to change control, application management, storage, cloud and DevOps, security, automation, virtualization, mapping, logging, and more.

Register for online sessions.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > SQL query to show duplicate nodes

SQL query to show duplicate nodes

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

Views: 1,487 Votes: 0 Revisions: 6

Updated March 7, 2017

Overview

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

 

Environment

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

Steps

  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

Tags

Classifications

Public