Saturday, February 9, 2013

SCCM Collection query for no client machines

The following SCCM Collection query is useful when you have many machines without SCCM Client on the client machines.
Just create a new collection using the below query;
select R.ResourceID,R.ResourceType,R.Name,R.SMSUniqueIdentifier,R.ResourceDomainORWorkgroup,R.Client from SMS_R_System as r full join SMS_R_System as s1 on s1.ResourceId =   r.ResourceId full join SMS_R_System as s2 on s2.Name = s1.Name where s1.Name   = s2.Name and s1.ResourceId != s2.ResourceId  and R.Client = null
More SCCM collection queries can be found here

No comments:

Post a Comment