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
Store

Delete/Remove devices from UDT ?

Hi,

We have several devices (Windows Servers etc) showing in "All UDT Nodes" that we cannot remove , how can we remove them ?

Regards

Find more posts tagged with

Accepted answers

All comments

superfly

Click on the Manage Ports button in the All UDT Nodes view. Then find the devices you wish to delete out of UDT. Click in the little box to select it and click on the Delete button.

sdawson35

The "delete" option is greyed out.

zackm

One of my clients had this issue a few months back and opened a ticket with SolarWinds, who responded with this SQL script (which assumes that you want to remove all Windows devices from UDT)

DELETE FROM UDT_NodeCapability WHERE Capability IN ('2','3') AND WHERE NodeID IN (SELECT NodeID FROM NodesData WHERE Vendor = 'Windows');DELETE FROM UDT_Port WHERE NodeID NOT IN (SELECT NodeID FROM UDT_NodeCapability);DELETE FROM UDT_Job WHERE NodeID NOT IN (SELECT NodeID FROM UDT_NodeCapability);

Hope that helps!

-ZackM

Loop1 Systems: SolarWinds Training and Professional Services

LinkedIN: Loop1 Systems
Facebook: Loop1 Systems
Twitter: @Loop1Systems

superfly

Are you an admin in Solarwinds?

sdawson35

Yes am an Admin

superfly

Can you post up some screen shots?

sdawson35

Of the "stuck" devices ?

superfly

Yes, just some screen shots showing where you are having the issue.

sdawson35

So screen shot as requested. Essentially we keep getting servers added to UDT (which we don't want - I know this is a discovery issue) but struggle to remove them.

sdawson35

Have now sorted !!, was running the SQL script against a copy of the D.B not the live one ......................

Thanks all , most appreciated.

phillipscc

In some versions of SQL you will need to drop the second WHERE:

DELETE FROM UDT_NodeCapability WHERE Capability IN ('2','3') AND WHERE NodeID IN (SELECT NodeID FROM NodesData WHERE Vendor = 'Windows');

becomes

DELETE FROM UDT_NodeCapability WHERE Capability IN ('2','3') AND NodeID IN (SELECT NodeID FROM NodesData WHERE Vendor = 'Windows');

(SQL2012R2)