Contributed By: Geoff Walker
Here is the SQL statement that I use to create an SMS 2003 Collection to tell me what computers do not have clients.

It also lists whether or not the clients are assigned to the site.

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 Client is NULL
 

To see other SMS 2003 Administration FAQs click here.