Export (0) Print
Expand All

How to Use Queries to Create Windows Mobile Device Collections

Updated: January 1, 2010

Applies To: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2

You can create new Microsoft System Center Configuration Manager 2007 collections for grouping devices in your organization. Creating collections for devices is similar to creating collections for Configuration Manager 2007 computer clients. The only difference is that if a query rule is used, then it must use Device classes as the source of data instead of Desktop classes. Discovery data is contained in the System class (SMS_R_System), which is the same for both Configuration Manager 2007 client computers and devices. For more information on creating collections, see How to Create a Collection.

Microsoft System Center Configuration Manager 2007 collections for mobile devices allow administrators to distribute advertisements to clearly defined groups of mobile devices. This is particularly useful if an advertisement is only valid for a certain mobile device platform or set of platforms. Configuration Manager 2007 allows administrators to create new customized collections. Creating a new collection requires a query which will return the correct set of Configuration Manager 2007 resources.

Use the following procedure to create a collection of Windows Mobile 6 Pocket PC devices.

To create a collection of Windows Mobile 6 Pocket PC devices

  1. In the Configuration Manager console, navigate to System CenterConfiguration Manager / Site Database / Computer Management / Collections.

  2. Right-click Collections, and then select New Collection. The New Collection Wizard opens.

  3. Type the Name of the new collection and any comments to display with the new collection. Click Next.

  4. Click the Query Rule icon in Membership rules. The Query Rule Properties dialog box opens.

  5. Type the Name of the Query Rule.

  6. Click the Edit Query Statement button. The Query Statement Properties dialog box opens.

  7. Click the Show Query Language button. The Query Language tab opens.

  8. Copy the following query and paste it in the Query Statement pane:

    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 where ResourceType = 5 and ClientType = 3 and OperatingSystemNameandVersion = 'Windows CE 5.2 (PocketPC)'

  9. Click OK, and click Next.

  10. Specify the security user rights that users have on this object class or instance. Click Next. The new collection is created.

  11. Click Close to close the New Collection Wizard.

Queries for Mobile Device Platforms

Queries for the following mobile device platform can be substituted for the query in the procedure above:

  • All Windows Mobile 6 devices

  • Windows Mobile 6 Professional devices

  • Windows Mobile 6 Standard devices

  • All Windows Mobile 5 devices

  • Windows CE 6 devices

  • Windows CE 5 devices

  • Windows CE 4.2 devices

  • All Windows Mobile Smartphone devices (includes Windows Mobile 6 Standard)

  • All Windows Mobile Pocket PC devices (includes Windows Mobile 6 Professional)

All Windows Mobile 6 Devices

Replace the query in the above procedure with the following query to create a collection of all Windows Mobile 6 devices.

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 where ResourceType = 5 and ClientType = 3 and ( (OperatingSystemNameandVersion = 'Windows CE 5.2 (PocketPC)') or (OperatingSystemNameandVersion = 'Windows CE 5.2 (SmartPhone)'

Windows Mobile 6 Professional and Classic Devices

Replace the following query with that in the procedure to create a collection of all Windows Mobile 6 Professional devices.

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 where ResourceType = 5 and ClientType = 3 and OperatingSystemNameandVersion = 'Windows CE 5.2 (PocketPC)'

Windows Mobile 6 Standard Devices

Replace the following query with that in the procedure to create a collection of all Windows Mobile 6 Standard devices.

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 where ResourceType = 5 and ClientType = 3 and OperatingSystemNameandVersion = 'Windows CE 5.2 (SmartPhone)'

Windows Mobile 5 Device

Replace the following query with that in the procedure to create a collection of all Windows Mobile 5 devices.

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 where ResourceType = 5 and ClientType = 3 and ( (OperatingSystemNameandVersion = 'Windows CE 5.1 (PocketPC)') or (OperatingSystemNameandVersion = 'Windows CE 5.1 (SmartPhone)'

Windows Mobile 2003 Device

Replace the following query with that in the procedure to create a collection of all Windows Mobile 2003 devices.

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 where ResourceType = 5 and ClientType = 3 and ( (OperatingSystemNameandVersion like 'Windows CE 4.% (PocketPC)') or (OperatingSystemNameandVersion like 'Windows CE 4.% (SmartPhone)'

Windows CE 6 Devices

Replace the following query with that in the procedure to create a collection of all Windows CE 6 devices.

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 where ResourceType = 5 and ClientType = 3 and OperatingSystemNameandVersion like 'Windows CE 6.0 %'

Windows CE 5 Devices

Replace the following query with that in the procedure to create a collection of all Windows CE 5 devices.

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 where ResourceType = 5 and ClientType = 3 and OperatingSystemNameandVersion like 'Windows CE 5.0 %'

Windows CE 4.2 Devices

Replace the following query with that in the procedure to create a collection of all Windows Mobile CE 4.2 devices.

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 where ResourceType = 5 and ClientType = 3 and OperatingSystemNameandVersion like 'Windows CE 4.2 %'

Any Windows Mobile Smartphone Devices

Replace the following query with that in the procedure to create a collection of all Windows Mobile Smartphone devices (including Windows Mobile 6 Standard).

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 where ResourceType = 5 and ClientType = 3 and OperatingSystemNameandVersion like '%(SmartPhone)'

Any Windows Mobile Pocket PC Devices

Replace the following query with that in the procedure to create a collection of all Windows Mobile Pocket PC devices (including Windows Mobile 6 Professional).

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 where ResourceType = 5 and ClientType = 3 and OperatingSystemNameandVersion like '%(PocketPC)'

For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft