How to create a collection query with multiple values

[ozthe2]

Hello, I had to create a query that would identify our desktops and laptops yesterday. Here's how I did it in Config Manager 2012: http://wp.me/p2m1uI-bp

 

 

[AmrelMahdy]

Try this SCCM Query

select SMS_R_System.Name, SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System inner join SMS_G_System_SYSTEM_ENCLOSURE on SMS_G_System_SYSTEM_ENCLOSURE.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes in ("3","4","5","6","7","13","15","16")

as referred in the below link

http://marckean.wordpress.com/2010/12/21/sccm-2007-r2-collection-queries/

[ozthe2]

Thanks for the reply and I am aware how to do it as per your example. My post is not aimed at how to create a collection based on chassis types rather using chassis types as an example on how to create a query using the wizard that contains multiple values - as per the title of my blog post. My blog is aimed at helping people better understand at how Config Manager works, and not simply "copy \ paste"

[AmrelMahdy]

Ok good job , i thought that ur Query Didnt work