Prajwal Desai
SCCM | ConfigMgr | Azure | Intune | Tech

SCCM Create Collections for Laptops

7 12,152

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

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

  • 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”.

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

  • >