Create SCCM Collection for Desktops

Q: How can I create a System Center Configuration Manager collection with all desktops in it?

A: The easiest way to create a device collection with all desktop instances is to create a new collection using a query membership rule and set the query statement to the following:

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 OperatingSystemNameandVersion like '%Workstation%'

This will then include all desktop operating systems in the collection.