broonster Posted November 20, 2015 Report post Posted November 20, 2015 Hi All, Does anyone know of a query I can use to create a collection which has computer objects with no client installed. I can find something similar in the reports but you can't delete computer objects from the reports. Cheers Craig Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted November 20, 2015 Report post Posted November 20, 2015 What wrong with the built-in query for that? It can be use to create a collection. Quote Share this post Link to post Share on other sites More sharing options...
broonster Posted November 22, 2015 Report post Posted November 22, 2015 Would that be this one? Quote Share this post Link to post Share on other sites More sharing options...
Eswar Koneti Posted November 23, 2015 Report post Posted November 23, 2015 yes or you can create collection with below query: 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 = 0 or SMS_R_System.Client is null Quote Share this post Link to post Share on other sites More sharing options...
regan Posted November 23, 2015 Report post Posted November 23, 2015 I use the built in query "system resource client version" "is not equal to" " version you want to be running " Quote Share this post Link to post Share on other sites More sharing options...
broonster Posted November 24, 2015 Report post Posted November 24, 2015 Thanks guys. Quote Share this post Link to post Share on other sites More sharing options...
