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

m_roberts

If you are not already running v9+, it is now possible to delete nodes in bulk via the 'Manage Nodes' page within the website interface.

Saves any manual SQL, script or orphanded data issues