Modify Active Directory Users Properties/Attributes by Import CSV

ADManager Plus provides the ability to modify the users by just importing from a CSV file. To perform this operation follow the steps below:

Select the AD Mgmt tab.
Click the Modify users link under CSV import.
Import the CSV file and click OK. Sample CSV file.
This will list all users and their attributes.
Click update to update the information in Active directory.

Know these Tabs:

Change Headers: Clicking on this will allow you to change the attributes (eg.given name to sn); then save.

Update in AD:

A pop-up displays all the LDAP Attributes provided in your CSV. You can specifically select the attributes to be modified on the active directory by placing a checkmark against the attributes on display and clicking on "OK" button.

By further clicking on the "Show search" link the display screen expands to provide a Match Criteria for users in AD in-order to be updated.

Match Criteria for users in AD:

Using this option users can be matched uniquely in AD by selecting one or more LDAP attributes, placing a check mark against them, which helps in identifying specific users to be modified.

Eg:-

Take for example you have two users with the name "John Smith" in your office and you want to update one of them. This option helps to identify him uniquely by providing one or more LDAP attributes which are specific to that user.

Note:

First create a CSV with all the updated information and then start the process.
It is recommended to give a unique value attribute like samaccountname, distinguishedname, userprincipalname to the users
If Multiple users match the same criteria then the users names will be appended by numbers starting from the number specifies the users with same name but distinguishes them by number.
The modifications done on UserAccountControl attributes using CSV will not be replaced but appended.

An example entry to modify the "department" and "telephone number" for group of users is given below:

givenName,samAccountName,department,telephoneNumber

MathewIles,MathewIles,Transportation,01455 882107

Emmanuelsam,Emmanuelsam,Transportation,01455 882108

Strongosky,Strongosky,Transportation,01455 882109

ManageEngine