Removing Old Computers Placed By Resource Discovery Into Database

How will you be able to remove old computers that were placed by resource discovery into the database? This tech tip will tell you how to do so.

The easiest way is to create a collection which shows unmanaged computers for a discovery method. Once the collection is created, review the set of computer resources, then select the needed computers, right-click, and choose Delete.

Run the following SQL query to create this collection:

USE Altiris   --Or your database name
select vc.[Guid]
, Name
, IsManaged
from vComputer vc
join Inv_AeX_AC_Discovery dis on dis.[_ResourceGuid] = vc.[Guid]
where dis.[Discovery Method] in ('DomainMembership') AND IsManaged<>'1'
GO