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:

  1. Select the AD Mgmt tab.

  2. Click the Modify users link under CSV import.

  3. Import the CSV file and click OK. Sample CSV file.

  4. This will list all users and their attributes.

  5. Click update to update the information in Active directory.

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


To have Useraccountcontrol attribute in CSV : While modifying users using CSV, if you want to turn-on/remove a particular accounts flag then give the input value for that flag (useraccountcontrol) as a semicolon separated value.

The syntax is as follows:"value1;value2"

where,
value 1 = Value of the flag to be turned on from off
value 2 = Value of the flag to be turned off from on.


For detailed information on these, click http://support.microsoft.com/kb/305144

 

 

To have  memberOf attribute in CSV : A user can be a member of more than one group, to support multiple values Distinguished Name (DN) of the groups should be separated by semicolon (;). Example:"CN=Group1,CN=Users,DC=domain,DC=com;CN=Group2,CN=Users,DC=domain,DC=com"

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

Note:

  1. First create a CSV with all the updated information and then start the process.
  2. It is recommended to give a unique value attribute like samaccountname, distinguishedname, userprincipalname to the users
  3. 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.
  4. 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:

 

distinguishedName,department,telephoneNumber,memberOf,managedby,description,userAccountControl,profilePath,homeDirectory,homeDrive

"CN=jamessmith,OU=Finance,DC=admp,DC=com",Finance,+1-980-765-1234,"CN=group1,OU=Finance,DC=admp,DC=com;CN=Group2,OU=Sales,DC=admp,DC=com","CN=Manager,OU=Finance,DC=admp,DC=com",Senior Account Officer,65536,"\\admp-dc1\UserProfile\%givenName%","\\admp-dc2\HomeFiles\%displayName%","E:"

"CN=jameswilliam,OU=Finance,DC=admp,DC=com",Human Resource,+1-980-765-1234,"CN=group1,OU=HR,DC=admp,DC=com;CN=Group2,OU=US,OU=HR,DC=admp,DC=com","CN=Manager,OU=HR,DC=admp,DC=com",Senior HR,65536,"\\admp-dc1\UserProfile\%givenName%","\\admp-dc2\HomeFiles\%displayName%","E:"

 

Below is an example to modify a user with Exchange attributes:

distinguishedName,targetAddress,authOrig,delivContLength,msExchRequireAuthToSendTo,msExchRecipLimit,accountExpires

"CN=jamessmith,OU=Finance,DC=admp,DC=com","smtp:jamessmith@gmail.com;smpt:jamessmith@ymail.com","CN=GeorgexSimonJones,OU=NTest,DC=admp,DC=com;CN=admptestgroup,OU=NTest,DC=admp,DC=com",999,true,1000,129503898000000000

"CN=jameswilliam,OU=Finance,DC=admp,DC=com","smtp:jameswilliam@gmail.com;smpt:jameswilliam@ymail.com","CN=GeorgexSimonJones,OU=NTest,DC=admp,DC=com;CN=admptestgroup,OU=NTest,DC=admp,DC=com",999,true,1000,129503898000000000

 

 



Copyright © 2011, ZOHO Corp.All Rights Reserved.