How do I delete all the discovered computers unmanaged

Created: 18 Jan 2013 | Updated: 23 Jan 2013 | 3 comments

tfreeman

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.

Discussion Filed Under:

Endpoint Management, Altiris Deployment Solution - 7.x, Altiris Deployment Solution, Agents, Tip/How to

Comments RSS Feed

Comments 3 Comments • Jump to latest comment

mclemson Trusted Advisor Partner Accredited

How do I delete all the discovered computers unmanaged - Comment:18 Jan 2013 : Link

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

How do I delete all the discovered computers unmanaged - Comment:23 Jan 2013 : Link

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 Trusted Advisor Partner Accredited

How do I delete all the discovered computers unmanaged - Comment:30 Jan 2013 : Link

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

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

How do I delete all the discovered computers unmanaged

Comments 3 Comments • Jump to latest comment

Would you like to reply?

Links