Creating a Collection for only Desktop machines Excluding servers

Use the below query language to Create a collection only for desktops and Laptops

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 inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM.SystemRole = "Workstation" and SMS_R_System.OperatingSystemNameandVersion not like "%Server%"

Else in other way click on edit query statement and select as shown in screenshot below

For more clarification add another query and use and operator as shown in below two screen shots.