Select employees without AD accounts

Provisioning tutorial · Step 4 of 10

Select the people who need a new Active Directory account.

Create a reusable filter that returns HR500 employees who do not yet have an Active Directory account.

Add the filter

1. Go to Processing > Filters.

2. Click Add.

3. Name the filter HR500_AD_User_Create.

   This tutorial uses the pattern SourceSystem_TargetSystem_ObjectType_Action; use a convention that works for your environment.

4. Click Create.

Configure the filter's logic

1. Select HR500.employees as the Start Table.

2. Click Relation filter item and add it to HR500.employees.

3. Set AD.Users as the relation target.

4. Set the relation filter item's logical operator to no. This returns employees without an AD account.

5. Click Save.

6. Click Filter. The Result pane now lists the employees that need accounts; in this example, all 585 HR500 employees are returned.

Select columns

To simplify things, we only want this filter to output relevant columns.

1. Open Columns Selection.

2. Clear all columns under the Users alias. They are empty for employees without AD accounts and are not needed by the create mapping.

3. Click Save.

4. Return to Data and click Filter once more to confirm that AD user columns are no longer in the output.