Video Screencast Help

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