Creating Device Collections with in SCCM 2012 (Query Rule)

Posted on Posted in Don't Feed the Technician

Create collections in System Center 2012 Configuration Manager to represent logical groupings of users or devices. You can use collections to help you perform many tasks including application management, deploying compliance settings, or installing software updates. You can also use collections to manage groups of client settings or use them with role-based administration to specify the resources that an administrative user can access.

  • In the Configuration Manager Console, click Assets and Compliance.
  • Right Click Device Collections and choose Create Device Collection
  • Type in the collection name, choose Browse next to limiting Collection. For this example we will pick All Desktop and Server Clients.
Device Collection
Collection Name + Limiting Collection Group
  • Click Add Rule and choose Query Rule.
  • Type in an appropriate query rule name, then click Edit Query Statement button.
  • Click on the Criteria Tab then click on the Star icon button.
  • Click Select.
  • Make you’re query statement.

Few examples:

Collection based on computers in a specific Active Directory OU

  • Attribute Class: System Resource
  • Attribute: System OU Name
  • Operator:  is equal to
  • Value:    <OU Name>
OU
Query AD OU
  • Click Value and select the OU desired.

 

Collection based on computers with a specific program in Add/Remove Programs

  • Attribute Class: Add/Remove Programs
  • Attribute: Display Name
  • Operator:  is equal to / is like
  • Value:    <Program Name>

Example Collections:

  • -SQL Servers:
  • Value: Add/Remove Programs Display name is like “%Microsoft SQL%”

 

Collection based on computers in a specific Operating System

  • Attribute Class: System Resource
  • Attribute: Operating System Name and Version:  is like
  • Value:    <%NAME%>

Example Collections:

  • – Windows Vista:
  • Value = %Workstation 6.0%
  • – Windows 7:
  • Value = %Workstation 6.1%
  • – Windows 8:
  • Value = %Workstation 6.2%
  • – Windows Server 2008:
  • Value = %Server 6.0%
  • – Windows Server 2008 R2:
  • Value = %Server 6.1%
  • – Windows Server 8:
  • Value = %Server 6.2%

 

Use incremental updates for this collection.
Select this option to periodically scan for only new or changed resources from the previous collection evaluation and update the collection membership with only these resources, independently of a full collection evaluation. Incremental updates occur at ten minute intervals.

Schedule a full update on this collection.
Select this option to schedule a regular full evaluation of the collection membership.

Direct.
Rule Direct rules let you to choose the users or computers that you want to add as members to a collection. This rule gives you direct control over which resources are members of the collection. The membership does not automatically change unless a resource is removed from Configuration Manager. Configuration Manager must discover the resources or you must import the resources before you can add them to a direct rule collection. Direct rule collections have a higher administrative overhead than query rule collections because you must modify this collection type manually. For more information about direct rule collections, see How to Create Collections in Configuration Manager.

Query.
Rule Query rules dynamically update the membership of a collection based on a query that Configuration Manager runs on a schedule. For example, you can create a collection of users who are a member of the Human Resources organizational unit in Active Directory Domain Services. Unlike direct rule collections, this collection membership automatically updates when you add or remove new users to the Human Resources organizational unit. For more information about query rule collections, see How to Create Collections in Configuration Manager.

Include.
Collections Rule The include collections rule lets you include the members of another collection in a Configuration Manager collection. Configuration Manager updates the membership of the current collection on a schedule if the membership of the included collection changes. For more information about the include collection rule, see How to Create Collections in Configuration Manager.

Exclude.
Collections Rule The exclude collections rule lets you exclude the members of another collection from a Configuration Manager collection. Configuration Manager updates the membership of the current collection on a schedule if the membership of the excluded collection changes. For more information about the exclude collection rule, see How to Create Collections in Configuration Manager.