How do I delete nodes in bulk

I am test driving this product and have pulled 100s of nodes that are not networking gear.
Is there a way to delete them in the SQL database (not sure about dependancies and relationships) or to delete en mass from the GUI?

Find more posts tagged with

Accepted answers

All comments

chjr7777

I'm probably missing it, but I don't see how to delete a node.

Charlie

larry.rice

if you go into system manager, you can right click on a node and delete. you can not select multiple nodes though.

chris.conway

Larry,

I have, somewhere, a VB script that will delete multiple devices.

This was written by Levi Drain of SolarWinds (don't think he is there anymore) a while back. It just needs you give it a text file containing a list of IPs to remove and away it goes and does its thing.

Analyser Sales Ltd
SolarWinds Premier Partner
www.asl-solarwinds.co.uk

tross

Where can i get this script? I have thousands of devices that were pulled into our production DB which was meant for a test DB. I would really like to remove these items.

Please email me with some information on this.

Thanks,

Todd Ross
todd.ross@newmont.com

Mithrilhall

Why chance you can post the script? I've been wanting to have the ability to do batch deletes.

torrielw

Could you also email me the script
torrie.williams@gpi.com

quote:Originally posted by asl-support

Larry,

I have, somewhere, a VB script that will delete multiple devices.

This was written by Levi Drain of SolarWinds (don't think he is there anymore) a while back. It just needs you give it a text file containing a list of IPs to remove and away it goes and does its thing.

Analyser Sales Ltd
SolarWinds Premier Partner
www.asl-solarwinds.co.uk

curii5

Where you able to locate this script? If so I would be greatly appreactive if you sent me a copy. Thanks!

voice.data.admin@gmail.com

Network_Guru

Actually you can also do it without the script.

First find a common property that belongs to all the nodes you want to delete.
If they are all different types of nodes, then open the custom property editor and create a common property.
I added the word "delete" in the custom property 'serialnumber' for all the nodes I wanted to remove.
Using this as an example;

Stop the polling engine and open the DB manager.
Open the nodes table and run the default query (just so you can see what the table looks like before proceeding).
To verify which nodes will be removed, you can also run the following query;
Select Top 1000 *
From Nodes
where serialnumber = 'delete'
Now change the radio button at the top to Read/Write and then enter this query:

delete from nodes
where serialnumber = 'delete'

Restart the polling engine and you are done.
(The nightly maintenance will clean up any loose ends left behind).

casonline

doesn't this leave a ton of orphaned records in other tables linked to those nodes' nodeID ? I did this manually and it seems to not delete the interfaces associated with the node out of the interfaces table

FormerMember

Not sure what you mean by "manually". did you delete them via System Manager or directly from the database? You should probably not delete from database directly. The best method is bulk delete via web console, but that does require 9.x.

Database maintance will clean up any orphaned objects when it runs every night.

BryanBecker

Not sure what you mean by "manually". did you delete them via System Manager or directly from the database? You should probably not delete from database directly. The best method is bulk delete via web console, but that does require 9.x.

Database maintance will clean up any orphaned objects when it runs every night.

I agree this is the fastest and easiest way to delete a bunch of nodes at the same time.

FormerMember

I found that to delete a lot of nodes the clicking on the box under the web interface took a longish time. I have two pollers, my plan is to shut them both down and delete through DB manager. I will then run DB maintenance by hand and re-start my pollers. I'm running 9.1. Does this make sense?