Remove computers not in AD from collection

[mbkowns]

Is there a way I could remove computers not found in AD from a collection membership?

 

Using this to grab all systems

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM.SystemRole = "Workstation")

[Eswar Koneti]

Is there a way I could remove computers not found in AD from a collection membership?

 

Using this to grab all systems

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM.SystemRole = "Workstation")

 

if you want to remove the computers from SCCM databse which are not in AD ,you can do ths via site maintanance tasks (http://technet.microsoft.com/en-us/library/bb693646.aspx)

 

Or else look at this script : http://myitforum.com/cs2/blogs/matbe/archive/2011/05/03/delete-computers-from-sccm-that-have-been-removed-from-ad.aspx (use at your own Risk )