SCCM Create Collections for Laptops


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 search 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.


SCCM Create Collections for Laptops



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


  1. Hi Prajwal, thanks for providing the sql query to create the collection. However, when I try to create a device collection based on your query, I recieve the following error “This query has a syntax error. Are you sure you want to save it?”
    I went through query statement, but couldn’t find any syntax error. Just wondering if anyone else has received this error message as well?
    Thanks for your help.

  2. The issue is in the quotation marks around the numbers ( “8”, “9”, “10”, “14” ). Somehow copy/pasting this script from this website inserts symbols that LOOK like quotation marks, but they aren’t. Delete and re-type each quotation mark and you will fix the problem.

    See my attached screenshot. The difference is slight, but it’s there. I replaced the quotation marks on “10” and “14”, but I left the original quotation marks for “8” and “9”.


Please enter your comment!
Please enter your name here