Foloseste-te de System Enclosure si Chassis Type. De exemplu:
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 ( "10" )
iti va returna numai notebookuri. Problema este ca, dpdv al chassis type, "notebook" si "laptop" sunt doua sisteme diferite :)
Lista cu toate chassis type-urile de la Microsoft este mai jos (vezi Chassis Values aici http://www.microsoft.com/technet/scriptcenter/guide/sas_cpm_btnz.mspx?mfr=true):
| Value |
Meaning |
|
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 |
SubChassis |
|
20 |
Bus Expansion Chassis |
|
21 |
Peripheral Chassis |
|
22 |
Storage Chassis |
|
23 |
Rack Mount Chassis |
|
24 |
Sealed-Case PC |
Prin urmare, poti sa mai adaugi valorile 8 (pt portable), 9 (pt laptop) si 14 (pt sistemele ultraportable, gen Asus Eee PC)
Pentru desktop, sper ca te descurci 
Aici depind de ce desktop vrei sa ai in colectie :)
Update: Desigur ca mai sus este varianta eleganta :) Daca aveti conventia de nume bine pusa la punct, poti sa faci o colectie cu toate sistemele care au numele de genul %wksl00% si alta colectie cu %wksd000%.