Documentation Rules DynamicAttributes™ Update AD Users Properties


Text file | DynamicAttributes™ Update AD Users Properties


█ How to use Dynamic Attribute rules to search and update AD users properties.

For example, we want to update users’ titles and departments and search users by their user principal name.

Preparing a text file

The rule titled, Text file | DynamicAttributes™ Update AD Users Properties can read a text file and use it to update multiple AD attributes. The text file be in a comma or colon separated format. The first row of the file must contain the names of attributes. The first column represents the attribute to be searched, while the remaining attributes are the attributes to be updated.

NOTE: If the attribute names in the first row do not match the Active Directory LDAP attribute names, you can use the Column Name > Attribute Mapping option of the rule to align the file column names to Active Directory attribute names.

For example, here is a file that can be used to update user’s address attributes, based on the Office in which they reside.

Create a Dynamic Update Rule

  1. In the Cayosoft Administrator Console, click New Rule on the toolbar.
  2. Use the wizard to create the Rule as follows:
    Active Directory > Users > Text file | DynamicAttributes™ Update AD Users Properties
    The rule will appear on the screen.
  3. To the right of the Select Data Source field on the rule, click Create.
    The file editor will appear on the screen.
  4. From the Available Templates list at the top-right, choose Dynamic Update AD Users Addresses – Template, then click Select.
    Attribute names will appear at the top row of the file editor.
  5. In the first column enter an Office name for which the rule will search and attempt to match. In the subsequent columns, enter the address information that will be used to update the returned user’s attributes.
  6. Click Save Changes at the bottom of the rule.

NOTE: In this example the first column titled physicalDeliveryOfficeName is the LDAP name for the Office attribute displayed on the General tab of the user properties dialog box in Active Directory Users and Computers. The remaining columns represent the attribute names associated with the attributes displayed on the Address tab of the same dialog box.

CAUTION: Rules that perform bulk actions against Active Directory should be tested before running in a production scenario. Cayosoft recommends that you create a separate OU for testing purposes and specify that OU name in the Rule’s Action section setting labeled Limit scope to this Domain or OU.

Mapping file column names to Active Directory attributes

On the rule there is a section titled More Options. By expanding the More Options section and using the and map the attributes.

For example, if the text file was to update a user organizational information and contained the columns UPNJob Title and Department, the Ldap name for UPN is ‘userPrincipalName’,  Job Title is ‘title’ and the ldap name for Department is department. Our mapping entery would appear as follows with an * before userPrincipalName to indicate it is the attribute being searched for matching users.





Your Email is safe here.