Hello All, In my SCCM hierarchy I have 1000 Non client. And I know that majority of those are not actually present in AD. Is there a script available to filter out Inactive machines from AD. Kindly Help

Hi,Create a collection with the interactive computers: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 where SMS_R_System.Active = 0And also create a collection with computers without any client installed: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 where SMS_R_System.Client is nullKent Agerlund | http://scug.dk/members/Agerlund/default.aspx | The Danish community for System Center products