Tuesday, 5 January 2010

Query to find all 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" )

You may change this as needed here is the complete list from Micrsoft:
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
Posted by at
Labels:

11 comments:

  1. Anonymous30 July 2010 at 16:44

    Howdy. thanks for all the great information you have provided. I have a question for you:
    I have a colleague who is using SCCM to inventory Client environment (mostly DELL). SCCM is picking up Port Replicators as being a separate Chassis and reporting as such. As a results, Laptops are reported twice as DOCKED and UNDOCKED. He believes Dell Port Replicator Serial Number is being recognized as a PC.
    One of my suggestions was for client to remove the "Chassis Type Number" for Docking Stations from the collection but client wants Docking Stations to be reported.
    can you suggest anything?

    ReplyDelete
  2. b mowlt15 April 2011 at 18:21

    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" ) and SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes NOT in ( "12" )

    Something like above?

    ReplyDelete
  3. Anonymous23 January 2013 at 13:10

    GREAT FIND this morning. Thank you for sharing this bit of information.

    ReplyDelete
  4. Phil N31 July 2014 at 17:13

    Thanks a lot!
    It has saved my evening!

    ReplyDelete
  5. Anonymous10 December 2014 at 15:25

    You can also use powerCapabilities.systembatteriespresent=1

    ReplyDelete
  6. Anonymous20 April 2017 at 07:09

    system configurations for designing softwares
    ?

    ReplyDelete
  7. Unknown21 October 2017 at 10:17

    i feel the above are right queries to find all laptops ad i support the post
    lenovo laptops price list

    ReplyDelete
  8. Unknown24 November 2017 at 16:08

    Please can someone share the chassis type of HP elitebook 8470p, HP elitebook 8460p, beacuse i can't find it. thanks

    ReplyDelete
    Replies
    1. Anonymous9 November 2018 at 17:43

      @mirza irfan, It's 10. You can use WMI to get it, like this:

      From a CMD prompt:
      WMIC systemenclosure Get Manufacturer, Model, SerialNumber, ChassisTypes

      Or from PowerShell:
      Get-WmiObject win32_systemenclosure | select-object Manufacturer, Model, SerialNumber, ChassisTypes

      - Cheers

      Delete
  9. Dev28 May 2020 at 15:55

    I want yo buy a laptop under 50000 nd I am totally confused so I have selected one ASUS vivobook 14 i5 8th gen x412FA


    So It's perfect or not, for student use or office.... Not fir a high class gaming

    ReplyDelete
  10. Ezza22 October 2021 at 06:02

    G-Technology G-Dock Enclosure in UAE, Solo Evolution Series Docking Enclosure in UAE, USB 3.0 Docking Enclosure in UAE
    https://gccgamers.com/g-technology-g.html
    G-Technology Enclosure in UAE, Safe Shopping Multiple Payment Options Express Delivery GCC Gamers Moneyback Guarantee.
    1634878905904-8

    ReplyDelete

Subscribe to: Post Comments (Atom)