SCCM collection to list all the Laptop computers

If your boss ask to get list of laptops which are managed by SMS or SCCM.what do you do and how do you get that. Right click on computer and go to resource explorer to identify the computer is Laptop or Desktop ?

You can identify if the computer is Laptop or Desktop based on its chassis Types.

Below are listed the Chassis types available to create SCCM collection or reports.

For Laptops Chassis Types : 8 , 9, 10, 11, 12, 14, 18, 21

For Desktop Chassis Type : 3, 4, 5, 6, 7, 15, 16

For server Chassis  Type: 23

Below is the collection to list all the computers which are laptops which fall in above Chassis type. All these values are from SQL table called SMS_G_System_SYSTEM_ENCLOSURE .If you are looking to create SCCM report,you can create using Views(v_GS_SYSTEM_ENCLOSURE).

You can also replace the values with Desktop computers or servers also you can use joins to club these with AD groups for deploying the applications based on this.

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", "11", "12", "14", "18", "21" )

Chassis Type Value Description :

 

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

SCCM Report to list all the laptop computers :

select a.name0,a.Operating_System_Name_and0,a.Client_Version0 from v_R_System a,v_GS_SYSTEM_ENCLOSURE b
where a.ResourceID=b.ResourceID and b.ChassisTypes0 in ( '8', '9', '10', '11', '12', '14', '18', '21' )
group by a.name0,a.Operating_System_Name_and0,a.Client_Version0

Here are some sample reports/queries available which you can make use of it

http://myitforum.com/cs2/blogs/snorman/archive/2007/09/18/count-of-chassis-types-by-collection.aspx

5 Responses to "SCCM collection to list all the Laptop computers"

  1. I'm using sccm 2007 R3 in our domain and (For Laptops Chassis Types : 8 , 9, 10, 11, 12, 14, 18, 21) doesn't seem to work. It only shows a few of our laptops so I wonder if there is some other way to get all laptops in a collection?

    Reply
    1. if you have power management enabled ,then u can try this report for laptops :

      select * from v_R_System sys join
      v_GS_POWER_MANAGEMENT_CAPABIL pmc on
      sys.ResourceID = pmc.ResourceID
      where PreferredPMProfile0 = 2

      I would always go with Chasis type.
      If you have any laptops that are not fall into the collection ,could you please look for the chasis type value ?are the remaining computers are reported the inventory to site server correctly ?

      Reply

Leave a Reply