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.

Query_image

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

Related Posts

8
Leave a Reply

avatar
4 Comment threads
4 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
newest oldest most voted
Brittany Paige
Guest
Brittany Paige

There is an error in the script, INSTEAD, USE SINGLE QUOTES:

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’ )

Jyri S.
Guest
Jyri S.

Hi

There are now some new types:

30 – Tablet
31 – Convertible
32 – Detachable

Julian Ontiveros
Guest
Julian Ontiveros

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”.comment image

Roy
Guest
Roy

Thanks Julian and Prajwal.

FlavioPena
Guest
FlavioPena

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. comment image

Rajasekhar
Guest
Rajasekhar

i am also getting the same error. verified the query but no use. Prajwal please advice.

Julian Ontiveros
Guest
Julian Ontiveros

I replied to @disqus_Kztq7PdjPu:disqus with the solution

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More