1. All Desktops

The following query allows to include all desktops in a collection using the detection of the ChassisTypes (being a part of Win32_SystemEnclosure)

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 ( “3”, “4”, “5”, “6”, “7”, “15”,”16″)

ChassisTypes

3 : Desktop (including virtual machines)

4 : Low Profile Desktop

5 : Pizza Box

6 : Mini Tower

7 : Tower

15 : Space-Saving

16 : Lunch Box

.

.

2. All Laptops

The following query allows to include all laptops in a collection using the detection of the ChassisTypes (being a part of Win32_SystemEnclosure)

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

ChassisTypes

8 : Portable

9 : Laptop

10 : Notebook

11 : Hand Held

12 : Docking Station

14 : Sub Notebook

18 : Expansion Chassis

21 : Peripheral Chassis

.

.

3. All Servers

The following query allows to include all servers in a collection using the detection of the ChassisTypes (being a part of Win32_SystemEnclosure)

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 ( “17”, “23”)

ChassisTypes

17 : Main System Chassis

23 : Rack Mount Chassis