Here is our task: Create a few Active Directory User queries.
-Filter all users that are employees
-Filter all users that report to Abigail Lowe (alowe)
-Filter all disabled users
-Filter all users based in the Japan office
-Filter all users with VP in title
Let's start by querying all of our Active Directory users in your staging environment. The below command we are limiting our search to our user OU, and we are grabbing each users properties.
Lets start off by taking a look at one of our users properties. As you can see the left shows the property and to the right shows the value for that user.
Query 1: Filter all users that are employees
Looking at the users properties and values we can use Description or employeeType. The commands should look like below.
Query 2: Filter all users that report to Abigail Lowe (alowe)
Looking at the users properties and values we can use manager or directReports
Query 3: Filter all disabled users
Looking at the users properties and values we are looking for all accounts with the property Enabled set to False
Query 4: Filter all users based in the Japan office
Looking at the users properties and values we are looking for all accounts with the property physicalDeliveryOfficeName set to Japan
Query 5: Filter all users with VP in title
Looking at the users properties and values we are looking for all accounts with the property title with VP in it.
