Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Automated Device management

How can I add and remove ping only nodes in NPM using SQL? we have thousands of nodes, some of which change IP's weekly, and manually adding and removing them will be extremely tedious.

Find more posts tagged with

Accepted answers

All comments

Jason.Henson

infosat,

When Orion has no SNMP authority to a node, the node is marked in the database in the 'Nodes' table under 'ObjectSubType' as 'ICMP' (as opposed to 'SNMP'). For myself, I ran the following query which deleted all of those nodes.

Delete from nodes where objectsubtype like 'ICMP'

This should accomplish what you are wanting to do, but please make sure that you are ready to delete these nodes by running select * from nodes where objectsubtype like 'ICMP' FIRST. This will list the nodes that will be removed.

Thanks,
Jason Henson
Loop1 Systems
www.Loop1Systems.com

bshopp

Are these DHCP nodes? When you add them, why not select the check box as Dynamic Node