Creating Device Collections

5/4/2012

This section provides information that will help you set up membership queries, which create collections that are similar to Device Manager 2011 device collections. The information in this section is needed only if you have turned off device collections. For more information on turning off device collections, see Turning Off Device Collections. For more information about device collections, see Device Collections.

Use the instructions in How to Create a Collection in Configuration Manager Help to create a query-based collection. To create a collection based on device type, copy and paste the following code into the New Collection Wizard:

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_EDM_DEVICEINFORMATION on 
SMS_R_SYSTEM.ResourceID = SMS_G_SYSTEM_EDM_DEVICEINFORMATION.ResourceID Where 
SMS_G_SYSTEM_EDM_DEVICEINFORMATION.DeviceType = devicetypevalue

The following table provides the device type values for the SMS_G_SYSTEM_EDM_DEVICEINFORMATION.DeviceType attribute.

Value Definition

1

All Thin Client Devices

2

All Point of Service Devices

3

All Digital Signage Devices

4

All Handheld Devices

5

All Other Devices

6

All Kiosk Devices

To modify a collection query, add one or more of the attributes from the following table to your query. The information for the attributes comes from corresponding registry key values previously set on the device. The registry key values are typically set by the device manufacturer.

Attribute Definition

SMS_G_SYSTEM_EDM_DEVICEINFORMATION.OEMName

Filters by device manufacturer name.

SMS_G_SYSTEM_EDM_DEVICEINFORMATION.Model

Filters by model number.

SMS_G_SYSTEM_EDM_DEVICEINFORMATION.OEMFirmwareVersion

Filters by device manufacturer firmware.

SMS_G_SYSTEM_EDM_DEVICEINFORMATION.PXEBoot

If PXE Boot is enabled, you can deploy an operating system image through a proxy server. If PXE Boot is disabled, you cannot. Valid values:

  • 0= PXE Boot is not set (disabled)
  • 1= PXE Boot is set (enabled)

See Also

Concepts

Collections and Inventory