Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

How do I delete all the discovered computers unmanaged

Created: 18 Jan 2013 • Updated: 23 Jan 2013 | 3 comments
This issue has been solved. See solution.

I have over 5000 devices discovered unmanaged I want to delete all 5000 of them and then go into the discover computer tab and put in IP Ranges. Is that possible and if so how do I do that. And that's all I would ever want to show up in the discovery view is though's IP ranges that I have specified and then you just have to push the agent out to them. Thanks for any help.

Comments 3 CommentsJump to latest comment

mclemson's picture

Create the following report and then review the results for accuracy:
SELECT vc.Guid FROM vComputer vc WHERE vc.IsManaged=0

Tweak as necessary so you're deleting the right records, then grab DeleteItems.cs from this article/download:
https://www-secure.symantec.com/connect/downloads/...

Edit DeleteItems.cs and update this line:
   static public string sql = @"select Guid from vSiteResource";

To this:
   static public string sql = @"select Guid from vComputer where vc.IsManaged=0";

Then run NScript DeleteItems.cs as described.  NScript is at <drive>:\Program Files\Altiris\Notification Server\Bin\NScript.exe.

Ensure Active Directory import is disabled--I'm not sure where these unwanted 5,000 records came from--and then use Network Discovery on the IP ranges you defined, working first with a test range and then expanding to include all ranges.

Does this answer your question?

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com

SOLUTION
tfreeman's picture

This worked perfectly the only thing I had to change was this line of code.

Edit DeleteItems.cs and update this line:
static public string sql = @"select Guid from vSiteResource";

To this:
static public string sql = @"select Guid from vComputer where vc.IsManaged=0";

this is what I put:

static public string sql = @"select Guid from vComputer where IsManaged=0";

thanks it worked perfectly.

Tyson

mclemson's picture

You're right, my query should have read:
select Guid from vComputer vc where vc.IsManaged=0

or

select Guid from vComputer where IsManaged=0

Glad I could help!

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com