Text file | Dynamic Attributes Update AD Users Properties
Rule description
This rule updates AD user attributes according to values defined in the CSV file. When the rule executes, it compares the current value for a found user with the value from the CSV file and updates the user only if these values are different.
Output report contains detailed information about which users have been updated by the rule.
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 update AD user properties that depend on some other AD property. For example, set the various address attribute values based on the office name attribute value.
This rule queries the Active Directory attribute defined by the name of the "key" column, for example, office name (physicalDeliveryOfficeName). When a user object attribute "key" attribute matches the value of the specified "key" column, the subsequent columns in the text file are used to update attributes that are defined by the remaining column names, for example, street address, postal code, state, and others.
Example CSV File:
physicalDeliveryOfficeName;streetAddress;l;st;postalcode
Atlanta;100Atlantic Blvd, Suite90;Atlanta;GA;30301Video tutorial
Rule settings
Query section
| Setting name | Description |
|---|---|
Select Data Source |
Specify the text file to be imported. The […] (three dots) button allows the user to browse for the file and the Create/Edit button allows the creation or editing of the existing file in the built-in Data Source editor. |
Separator used in file |
Specify the separator used in the source CSV file. |
| Maximum number of objects | Specify the maximum number of objects to modify in the selected scope. |
More options | |
Filter CSV data |
This setting specifies the filter that can remove data rows from the imported text file that satisfies the specific condition. |
Column name > Attribute Mapping (optional) |
Use this setting to map column names from the file to the AD user attributes. When file column names do not match Active Directory Attribute names, map them here using a separated string. Map column to AD Attribute by specifying each in the format
Indicate the key search column with an You can add columns that already match without formatting. Example: *username>SamAccountName, *Office>physicalDeliveryOfficeName,description |
Empty field in Data Source |
If the record in the CSV file column is empty, you can skip updating the attribute or clear its value. |
Action 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 a specific OU. IMPORTANT: To test the rule configuration, limit the rule scope to an OU that contains test accounts or objects and use the Preview feature. |
| More Options | |
Server |
Select the domain controller to run the rule. |
Credentials |
Specify credentials to the selected domain controller. |
|
LDAP Filter Filter |
Set the filtering conditions to only return objects or data that need to be processed by the rule. It is possible to use only one of these filters: either the LDAP filter or the filter, where you can select properties and operators from the list. |
Output section
This section defines the output format of this rule.
To get more information about this section, please see the Rule 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 Rule Enforce/Schedule section article.
Comments
0 comments
Please sign in to leave a comment.