Active Directory Bulk
User Updater Tool

Administrator Guide
Bulk User Updater Tool

Description

The bulk user updater tool is used to bulk update active directory user account attributes. You can
choose to remove or update multiple users attributes at once. A CSV template is included that you fill
out with the user accounts and attributes you want to update.

Table of contents

• Read First
• Step 1: Generate CSV Template
• Step 2: Bulk Update Options
• Step 3: Run Bulk Updater
• How to remove user account properties
• CSV Template Setup
• Update proxyaddresses
• Adding additional user fields to the CSV
• Task Scheduler
• Support

Step 1: Generate CSV File

Make sure you read the READ FIRST section. It has important information for running this tool.

Click the CSV Template button to download the provided CSV template.

You can rename the template and save it anywhere you like.

Fill out the CSV

Now fill in the CSV with the user accounts and details you want to update. Just fill out the columns that you want to update, the rest can be left blank. You do not need to remove columns that are not used. See the CSV template section if you need help with the column names.

You must enter the user’s sAMAccountName into column A. You can use the bulk export tool to export this for all accounts or from an OU.

For this example, I’m going to update several user’s displayname, Office, department, and street addresses. Here is a screenshot of my CSV.

Again if any of these attributes have data the tool will update it, if blank it will add it.

Step 2. Bulk Update Options

Choose bulk update options or leave them as default.

Note: Changes to user proxyAddresses will only occur if you add a value to the proxyaddresses column in the CSV. See the ProxyAddress section for more details.

Step 3: Run Bulk Updater

The last step is to select your template and click run.

The log section makes it easy to verify the update was successful for all accounts. Any errors will be flagged.

All done. Now go check one of the accounts in Active Directory.

Remove User Account Properties

If you want to bulk remove user account properties then just put remove in the CSV column. In this example, I will remove the department information. Here is a screenshot of the CSV.

If any of these users had anything in the department field in Active Directory this tool will remove it.

Now check the logs and Active Directory to verify.

CSV Template Setup

The provided CSV template includes 33 user attributes you can use. You can add additional attributes if needed. Active Directory uses LDAP attribute names to store most account information. This means the user fields you see in Active Directory Users and Computers do not always match with the LDAP attribute name. To update user accounts you must use the LDAP names.

Below is a reference table that shows the LDAP name (CSV Template column) and what it maps to in Active Directory.

For example, the first name in Active Directory = giveName. The office field in Active Directory = physicalDeliveryOfficeName.

If you look at the provided CSV template the example has Test for the giveName (First name) and Nixa Office as the physicalDeliveryOfficeName (Office).

Here is a visual to help illustrate this.

If you need more visual reference refer to the LDAP Field Mappings guide.

proxyAddresses Details

If you need to update or modify proxyAddress please watch the video below.

Adding Additional User Fields to the CSV

You can add additional user attributes to the CSV file, you just need to know the LDAP name. You can find the LDAP name by opening the attribute editor in Active Directory Users and Computers. You could also use PowerShell to list all user account properties.

To see the attribute editor you first need to enable the advanced features in Active Directory Users and Computer

Click view from the top menu then select advanced features.

Now when you open an account you will see the attribute editor tab.

The attribute editor screen will show you all the user LDAP properties.

Now just find the attribute name and add it to the CSV. For example, I want to add information to the other Home telephone section for users.

In the attribute editor, I see the name is “otherHomePhone”. I will add this to the CSV.

Task Scheduler

Please refer to the Task Scheduler Guide for the steps.

Additional Tools

The AD Pro Toolkit includes 13 Active Directory management tools and over 200 built-in reports. The toolkit simplifies Active Directory administration and helps you to security your domain.

Support

If you run into any issues or need to ask a question you can contact us via our contact page.

You can also send us any additional features you would like to see added.