Query Based User Collections Example #1
Full-Access Members Only
Sorry, this lesson is only available to Server Academy Full-Access members. Become a Full-Access member now and get instant access to this and many more premium courses. Click the button below and get instant access now.
Instructions
Q&A (0)
Notes (0)
Resources (0)
Saving Progress...
Resources
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.
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 resource, User 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.
