• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 363
  • Last Modified:

Update user information in Active directory

Dear All,

I have more than 3000 users in the active directory. Those users are not having the correct information. I need a way to export all users information to excel sheet, then correct all of the information and import them again in the active directory.

How do I can make this? What are the tools that I can use it?

  • 2
1 Solution
There are number of ways to update information in AD depends on what are you updating.

if you updating a personal data that you trust users to update them, then use self update tools. there are number of such tools that for example create a portal for users and they will update their information through it.

If you want to export data to excel & import it again to AD, then use  
devdeptAuthor Commented:

Thanks for your replay, I use the following Command to Export all of the Information:

csvde -f finalad.csv -r "objectclass=user" l userPrincipalName,givenName,SN,displayName,discription,telephoneNumber,mail,homephone,mobile,department,manager,city u

Then I Import the file in Microsoft Excel. I will start correct all of the information for all users.

Now; I need a Script to import users information after corrected them to the Active Directory.

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now