SCCM Create Collections for Laptops

9013

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.

Query_image

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

5 COMMENTS

  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. https://uploads.disquscdn.com/images/48199bd803c268ec4996db01cb93e684fd154f4d847c50ddff43e3dcd79a7a62.png

  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”. https://uploads.disquscdn.com/images/47024a837d79b490430081f904bec6ef30c1b8e9d475de08362e149a82214f09.png

LEAVE A REPLY

Please enter your comment!
Please enter your name here