Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

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: 2 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
22:30, 6 Mar 2017

Tags

Classifications

Public