0/1 Lessons

Getting Started with this Course

• 26min

0 / 3 lessons complete

System Center Configuration Manager - Features and Capibilities

• 31min

0 / 5 lessons complete

SCCM 1902 Lab Setup

• 51min

0 / 12 lessons complete

Installing SCCM 1902 Installation

• 1hr 32min

0 / 11 lessons complete

Configuration Manager Basics

• 1hr 58min

0 / 8 lessons complete

Updating SCCM

• 30min

0 / 7 lessons complete

SCCM Client Installation

• 46min

0 / 4 lessons complete

User and Device Collections

• 1hr 6min

0 / 13 lessons complete

Application Management

• 2hr 34min

0 / 12 lessons complete

Operating System Deployment

• 23min

0 / 7 lessons complete

Endpoint Protection

• 1hr 12min

0 / 10 lessons complete


• 37min

0 / 4 lessons complete

Problems and Solutions from the Message Board

• 14min

0 / 5 lessons complete

Query Based User Collections Example #1


Q&A (0)

Notes (0)

Resources (0)

Saving Progress...


There are no resources for this lesson.

Notes can be saved and accessed anywhere in the course. They also double as bookmarks so you can quickly review important lesson material.

Create note

In this lecture I’m going to show you how to create a query based user collection that will pull Users from a specific OU into a User Collection. 

Example #1 – Let’s say in your organization you have an OU (Organizational Unit) called Managers, the members of this OU often change as managers come and go. From SCCM you need a way to keep track of the Managers OU as changes are made. 

  • First, we need to take a look at Active Directory

Login to your Domain Controller, Open Server Manager, click Tools, click Active Directory Users and Computers.

Here I need to create a organizational unit called managers.

So in this case I right click on ServerAcademy.com, (Your Active Directory may look different) click new and then choose Organizational Unit, for a name type Managers, then click ok.

Now right click on Managers and click New, then select User. 

Here I type Joe, tab 2x and type Grey. Login name type JGrey, click next.

Type password 2x and for this lab click password never expires.

Click next, then click finish. Now create two more users, stop the video while you do this. After you have created all three users go ahead and close ADUC and Server Manager.

  • First let’s create a User Collection, 
  • For Limiting Collection, click Browse, click All Users, click ok, then click next.

On the Membership Rules panel check the box Use incremental updates for this collection. Because the query based membership will change as members are added and removed from the Managers OU.

  • Click Add Rule, click Query Rule, for a name type Managers
  • Now click Edit Query Statement. Click Criteria, click the orange Icon.

For Criterion Properties, Criterion Type use the default (Simple Value)

For the Where clause, click select, for attribute class, choose (User Resource), and for Attribute choose (User OU Name)click ok.

  • For Operator use the default (is equal to) 
  • Click Value, select the Managers OU, click ok, click ok again, click ok, ok, then click next, next again, then click close.
  • Now go back to Assets and Compliance, Click User Collections then click Query Managers, press F5, now the member count should be three. 

In this example this Criteria was used for steps 4-6 

Criterion Type – Simple

4. Where – User resourceUser OU Name

5. Operator – is equal to

6. Value – Select Specific OU (Managers OU)

Tip – (not in the video) After you click Value in step 6. If the Managers OU does not appear, exit out of the user collection creation and do the following. 

From the Workspace click Administration, from the Navigation Pane click Hierarchy Configuration. Click Discovery Methods, right click on Active Directory User Discovery and select Run Full Discovery Now, click yes. Discovery Methods will go out to Active Directory and look for changes and write those changes to the SCCM database. Now after you go back in and create your User collection you should see the Managers OU for the Value.

Server Academy Members Only

Sorry, this lesson is only available to Server Academy Full Access members. Become a Full-Access Member now and you’ll get instant access to all of our courses.

0 0 votes
Lesson Rating
Notify of
profile avatar
Inline Feedbacks
View all comments