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