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