In CM12 I created Laptop, workstation and server collections. I originally had the membership setup as direct (during testing) and noticed that no new machines are in these collections.
We mark all out laptops with the prefix of L and our workstations with W Is there a way to make a query that says anything that starts with L put in the laptop collection and anything that starts with W put in the workstation collection? I am not sure about wildcards... But this is what I have: 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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Name = "L$" Thanks, Kevin Johnston
