Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

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_ret on Mar 07, 2017

Views: 1,345 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