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 July 18, 2016
This article provides steps to check duplicate IP addresses in NodesData table in the NPM database.
NPM version 12
1. Click Start >Programs > Solarwinds Orion >Advanced Features > Database Manager.
2. Expand Orion Database.
3. Right click Nodes >Query Table, and then select Read-write(results can be edited) Find Duplicate Entries of the same Node.
a. Find duplicate IP Addresses in your nodesdata table:
WHERE IP_Address IN (SELECT IP_Address
GROUP BY IP_Address
HAVING COUNT(*) > 1)
b. Find 'bad' Ip addresses in the NodesData table:
Note: this will pick up some "Unknown" entries as well. This is normal when assigned to DHCP nodes.
select NodeID, IP_Address, Caption
Where IP_Address not like '%.%.%.%' or IP_Address like '%.%.%.%.%'