Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

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: 144 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