Rule description
This rule moves AD users to the OU defined in the CSV file.
When to use this rule
Use this rule when you need to move AD users to the OU defined in the CSV file.
This rule queries the specified Active Directory scope and then uses the text file to identify the correct Organizational Unit (OU) for the user, and if the user is not located in the correct OU, the rule moves the user to that OU.
The text file’s first column name must be set to the name of the "key" attribute of the Active Directory user, for example, "Office". This attribute value is used to determine the user’s final OU location, which is taken from the second column.
The values in the first column should be unique and represent the possible values for the "key" user attribute. The text file’s second column should be named "OU" and contain the DN of the Organizational Units associated with the data in the first column.
Example CSV File:
Office; OU
Columbus; OU=Columbus,OU=User Accounts,OU=Corp,DC=cayodemo,DC=com
Atlanta; OU=Atlanta,OU=User Accounts,OU=Corp,DC=cayodemo,DC=com
Video Tutorial
Rule Settings
Query Section
| Setting name | Description |
|---|---|
|
Limit scope to this Domain or OU |
This setting defines the search query scope To improve query performance, limit the scope to specific OU. Important: To test rule configuration, limit the rule scope to an OU that contains test accounts or objects.
|
|
Query Criteria |
Query criteria are sent with the query and may improve query performance. Tip: For different samples on the criteria builder, see KB20180410-1.
|
|
More options |
|
|
Filter |
To hide unwanted data based on criteria, not supported by the Active Directory query, set the filtering conditions here. Example: filter by the found object Distinguished Name. Tip: For optimal performance, use the Query criteria above to filter objects whenever possible.
|
|
Returned Properties |
To display additional properties for each object found by the query, add those properties to the list. |
|
Sort by |
Sort result objects list. |
Action Section
| Setting name | Description |
|---|---|
|
Select Data Source |
Specifies the text file to be imported. Click the […] button to browse for the file, and the Create button to create or edit of the file in the Cayosoft Administrator data source editor. |
|
Separator used in file |
Use this setting to select the separator used in the file. |
|
Filter CSV data |
This setting specifies the filter that can remove data rows from the imported text file that satisfies the specific condition. |
Output Section
This section defines the output format of this rule.
To get more information about this section, please see the Output section article.
Enforce/Schedule section
This section defines the schedule for how often to run the rule.
To get more information about this section, please see the Enforce/Schedule section article.
Change History
| Version | Notes |
|---|---|
| 9.1.0 | Domain Controller and Credentials settings have been removed. |
| 7.3.1 | Filter CSV data setting is added. |
| 5.4.0 | The rule is supplied with the pre-built CSV file template, which is selected by default when you create a new rule. |
Comments
0 comments
Please sign in to leave a comment.