Someone just asked how to create a collection with all laptop computers? Well, if there is a good naming convention on site, this query will be easy to make even for me 
But, otherwise, we need to use chassis type value because laptops and notebooks are not the same things.
The full list with chassis types are bellow (taken from http://www.microsoft.com/technet/scriptcenter/guide/sas_cpm_btnz.mspx?mfr=true):
| 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 |
So, to make a collection with all kind of mobile systems (Portable, Laptop, Notebook, Sub Notebook) we will use 8, 9, 10 and 14 chassis types. The final query looks like 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", "14")
If you receive the “This query has a syntax error.” error, change the quotation marks when pasting the query, as this one does not work with ConfigMgr.
(5 votes, average: 4.80 out of 5)
Loading ...