Features:

• Easily bulk update AD user account properties
• Bulk modify user account options such as change password at next logon, password never expired, disable or enable user accounts.
• Includes CSV template. Template includes 35 user attributes; you can add more if needed.
• Automate user import with the built-in scheduler.
• Add or remove users to groups.

How to Use the AD Bulk User Update Tool

1. Open the Bulk User Modification tool (Located under user management tools).
2. Click the “Download CSV Template” button.
   • Note: You can also generate a template by using the user export tool.
3. Fill out the CSV with user details.
4. The CSV must have one of the following headers to identify the accounts:
   • SamAccountName (default)
   • EmployeeID
   • EmployeeNumber
   • UserPrincipalName
5. Click the update options button and select your ID column.
6. Select your CSV template and click run.

CSV Example.

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.

Supported Attributes List

Below is a list of attributes included in the template. The CSV headers are case sensitive and can be in any order. You can delete any columns from the template that you do not need. If a cell has no value (blank) then it will not update the account.

Attribute Name (column headers)	Example Value	Description
sAMAccountName	robert.allen	This will be the users logon name.
password	Fuutbaal#123	The password for the user.
memberof	group1,group2	This will add users to a group. Use the groups name and separate multiple groups with a comma.
giveName	Robert	This is the users first name. (General tab)
initials	RA	The users initials (General tab).
sn	Allen	This is the users last name (General tab).
displayname	Robert Allen	The users display name (General tab).
description	IT staff	This is the description field in Active Directory (General tab).
physicalDeliveryOfficeName	1st floor	This is the office field in Active Directory (General tab).
telephoneNumber	1-888-214-3802	This is the Telephone number field (General tab).
mail	robert@activedirectorypro.com	This is the E-mail field (General tab).
wwwHomepage	activedirectorypro.com	Web page field (General tab).
streetAddress	123 W. EagleCrest LN	Street field (Address tab).
postOfficeBox	PO Box 1	P.O Box field (Address tab).
l	Springfield	This is the City field (Address tab).
st	MO	State/province field (Address tab).
postalCode	65802	Zip/Postal Code field (Address tab).
c	US	2-digit string value
co	United States	open string value
countryCode	840	integer value
profilePath	\file1\profiles\%username%	Profile path field (Profile tab).
scriptPath	it.bat	Logon script field (Profile tab).
homeDirectory	\file2\users\IT\%username	This is the home folder path (Profile tab)
homePhone	1-888-214-3802	Home phone (Telephones tab)
mobile	1-888-214-3802	Mobile number (Telephones tab)
ipPhone	1-888-214-3802	Ip phone (Telephones tab)
title	Network Manager	Job title field (Organization tab)
department	IT	Department field (Organization tab)
company	Active Directory Pro	Company field (Organization tab)
employeeID	12345	This is the employeeID attribute
EmployeeNumber	1	This is the employeenumber attribute
manager	robert.allen	This will assign a manager to the user account. Use the managers logon name.
proxyAddresses	SMTP:test.user1@activedirectorypro.com, smtp:test.user2@activedirectorypro.com	This column will add additional proxyAddress to the user.
proxyAddresses_update	smtp:test.user3@activedirectorypro.com	This will update existing proxyAddresses.

Add Additional Attributes

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.

All done. That is how you add additional attributes to the CSV file to import with new accounts.

Schedule User Updates

You can use the built-in task scheduler to automate updating AD users.

1. Click on Scheduler.
2. Click on the Add button.
3. For the type select “Bulk User update”
4. Give the task a name.
5. Set the credentials.
   
6. Click Next
7. Set the schedule frequency. You can choose from Daily, Weekly or Monthly.
8. Click Next
9. Select your CSV template. If you need to change the ID column click the options button. When done click Finish.
10. Your task will now appear in the list.