SCCM Laptop Query

Posted on Posted in Don't Feed the Technician

I’m using SCCM 2012 but transferable to older versions.

  • Go to Assets and Compliance.
  • Right Click ‘Device Collections’ and click ‘Create Device Collection’.
  • Fill in the details for the group my case its Calling it ‘Laptops’.
  • Click the ‘Browse’ button for the limiting collection and select the appropriate group for your situation. (If in doubt choose ‘All Systems’).
  • ‘Next’
  • Now to create the query itself. Click ‘Add Rule’ then ‘Query Rule’.
  • Put in an appropriate name.
  • For this we won’t be importing a query so click ‘Edit Query Statement’
  • In the new window click the ‘Show Query Language’ this will show and allow you to edit query code.
  • ‘Copy’ the code below and paste into the statement window.

 

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

 

  • Microsoft has kindly provided a list of available options, you just need to alter the ‘SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes’ according to what you want the collection to consist of.
  • Choose if and how often the collection is updated.
  • ‘Next’
  • ‘Next’
  • ‘Close’
  • Double click the new collection and force an ‘Update Membership’ scan.
  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

 

Leave a Reply

Your email address will not be published. Required fields are marked *