Hide this message
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.
Updated March 7, 2017
The following are some steps that can be used to detect instances of having duplicate nodes on your Orion database.
SELECT NodeID, ObjectSubType, IP_Address, Caption, DNS, count(*) FROM [dbo].[NodesData]
group by NodeID, ObjectSubType, IP_Address, Caption, DNS
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