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

Help! Bulk removal of nodes from node tree

Ok, I'm a dope. There... got that out of the way upfront. I was not paying enough attention to what I was doing and accidently imported about 4,000 workstation nodes into my database. I want them out. I see no method for node deletion other than one-at-a-time. Anyone have any suggestions (other than RTFM... doin' that now, but in a real hurry to get this thing pared back down to just server and network elements)?

Thanks for any help in advance,

John

Find more posts tagged with

Accepted answers

All comments

Network_Guru

You can edit the DB directly to remove the nodes, but you must stop the Orion polling engine first, delete the nodes & then restart.

You could also just restore the DB from last night's back-up.
I have my DB scheduled to be backed up every night at 11:15PM to a flat file on my C drive.
At most, I will lose 24hrs of data.
The server is also backed up with Veritas nightly at 12:15AM.

-=Cheers=-
NG

Josh_Stephens

Like NG said, if you decide to delete the nodes directly from the database be sure to stop the Orion polling service(s) first and backup your database.

A good practice when doing bulk deletes like this is to run a "select" query first and then when you've verified the results change it to a "delete".

For instance, you might say:

Select * from Nodes
Where MachineType like '%Windows%'

If this query returns the nodes that you want to delete, just change the first part of the query:

Delete * from Nodes
Where MachineType like '%Windows%'

Again, these are just examples so be sure to test this in your enviornment before actually deleting anything.

Happy hunting

Josh Stephens
SolarWinds R&D