Active Directory Bulk
User Update Tool

All Features:

• Bulk add, update, or remove user accounts properties
• Automated task scheduler
• Save hours of time
• Bulk update proxaddresses
• No scripting required
• Bulk reset passwords
• Update group membership
• Update manager attribute

Requirements:

• You will need rights to modify user account objects in Active Directory
• If running on a non-domain controller the RSAT tools will need to be installed.

How to Use the AD Bulk User Update Tool

Step 1. Download and modify the CSV Template

1. Click on Bulk User Modification

2. Click the “Download CSV Template” button.

You will be prompted to save the CSV file. You can save it anywhere you want.

3. Modify the CSV Template

The provided template includes an example user as a reference on how to fill out the CSV template.

The ID column is used to identify the account in Active Directory. The ID column can be one of the following.

• sAMAccountName (default)
• userPrincipalName
• mail
• employeeID
• employeeNumber

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.

For this example, I’m going to update the following attributes.

• description
• physicalDeliveryOfficeName
• streetAddress
• postOfficeBox
• title
• department
• employeeID
• manager

Here is what my CSV template looks like.

When you have your CSV template configured save it and move to the next step.

Step 2. Update Options

Click the Update Options button and change any options that you need. You may not need to change any of the default settings.

If you are not using the sAMAccountName attribute to identify the accounts then use the drop-down to change the attribute.

Note: Changes to user proxyAddresses will only occur if you add a value to the proxyaddresses column in the CSV. I cover updating proxyaddresses in a separate how-to guide.

Step 3. Select your CSV file and click run

Next, click the “Select CSV File” button and select your CSV template.

Then click run to start the update.

When the update process is completed, review the logs for any errors. Errors will be in red and will tell you why the error occurred.

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.

Additional Resources:

• Video Demo
• AD Pro Toolkit User Guide

Related Tools:

• Bulk Import User Tool
• Local Admins Report
• Service Account Management Tool