Articles in this section

See more
Print

Text file | Dynamic Attributes Relocate AD Users rule

  • Updated
Follow

 

Rule description

This rule moves AD users to the OU defined in the CSV file.

Note: The data source text file must be in the comma or semi-colon separated values format (CSV). CSV-file should be in UTF-8 format in case of using letters with an accent: á, ä, é, í, ö, ü and etc.

 

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.

 

Related articles

Comments

0 comments

Please sign in to leave a comment.