Active Directory Tools > User Update Tool

Active Directory Bulk User Update Tool

Do you need to bulk modify Active Directory Users? With the AD Pro Toolkit, you can easily mass-update user account properties such as: Office, telephone, street, city, state, manager, department, company, title, department, home folder, employe number, groups and many more. This tool is a huge time saver and eliminates the need for complicated scripts or manually modifying user accounts.

Features:

  • Easily bulk update user account properties
  • Add or remove ProxyAddresses and mail attribute
  • Bulk modify user account options such as change password at next logon, password never expired, disable or enable user accounts.
  • Includes CSV template
  • Automate user import with the built-in scheduler.
  • Add or remove users to groups
  • bulk reset passwords
  • Supports a large number of attributes.
  • Template includes 35 user attributes, you can add more if needed.

Requirements:

  • You need permission to modify user accounts in Active Directory.

How to Use the AD Bulk User Update Tool

Step 1. Download and modify the CSV Template

1. Click on Bulk User Modification

select bulk user modification

2. Click the “Download CSV Template” button.

download csv template

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.

csv template example

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.

user update options

Step 3. Select your CSV file and click run

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

select 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.

start the update process

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.

remove user account properties

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.

Other features

Below are additional features included in the AD Pro Toolkit.

AD ACL Scanner

Audit Active Directory delegated permissions.

AD Cleanup Tool

Find inactive users and computer accounts in Active Directory. Cleanup and secure your AD domain.

Bulk User Update Tool

Bulk update user account attributes. Easily make mass changes to multiple user accounts at once.

NTFS Permissions Report

Scan and audit the NTFS permissions on local and shared folders.

Local Admin Report

Scan remote computers and find users that have local administrator rights on their devices.