SCCM Create Collections for Laptops In Configuration Manager a query is a specific set of instructions that extract information about a defined set of objects. You can create queries and store them in the Configuration Manager 2012 site database. By running a query, you replace the database for information about the objects that match the query criteria. Configuration Manager comes with just a handful of queries out-of-the-box that illustrates a small part of the rich amount of data available. If you ever wanted to create a SCCM collection for all the laptops in your organization you could use the below query to do it.
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_ENCLOSURE on SMS_G_System_SYSTEM_ENCLOSURE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes in ( “8”, “9”, “10”, “14” )
If you want to change the system enclosure type, here is Microsoft’s list of chassis type codes:
1 Other 2 Unknown 3 Desktop 4 Low Profile Desktop 5 Pizza Box 6 Mini Tower 7 Tower 8 Portable 9 Laptop 10 Notebook 11 Hand Held 12 Docking Station 13 All in One 14 Sub Notebook 15 Space-Saving 16 Lunch Box 17 Main System Chassis 18 Expansion Chassis 19 Sub Chassis 20 Bus Expansion Chassis 21 Peripheral Chassis 22 Storage Chassis 23 Rack Mount Chassis 24 Sealed-Case PC
Note that copying the above query may cause the quotation marks around the numbers ( “8”, “9”, “10”, “14” ) to LOOK like quotation marks, but they aren’t. This will cause the query to show an error when trying to save it. Delete and re-type each quotation mark and you will fix the problem.