What is the best and easiest way to update some fields Active Directory Users "300+ user"

Hello everybody,

I would like to ask a question which I have already searched for it on the net but I have not found a solution for it tell now.

I have been given a job be my manager to update our active directory Users list the field which will be affected are:


 “First Name, Initials, Last Name, Display Name, Office and Telephone number"


“Mobile, Fax and IP Phone"

In the Organization TAB:

“Title, Department, Company and last the Name under Manager"

We have 350+ users in the active directory. Those field on most of them are either empty or have a wrong information.

I would like to ask experts what is the best and easy way to edit those huge numbers of user while keeping track of what have been changed and what is still need to be done. Please inform me about any tool that could do it or it meant to do this kind of editing.

Thank you all in advance.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Abhay PujariCommented:
You want to update First Name, Initials, Last Name, Display Name and Telephone number - which is unique and I think u need to do it manually. Even if you create a script, you have to enter parameters for the same. Correct me if I am wrong,
If you select multiple users, then you can edit few things which are common in every case.
There is a tool for importing and exporting AD objects.
I don't know the exact workings anymore: but check google for ldifde.exe
This should make things easier.

And nicer: it is a native Windows tool...
LDIFDE works, however the input file syntax can be frustrating...

You will need a decent script, e.g. take this as a starting point:

Of course you will have to have to input data in some kind of machine-readable format...
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Check out the command line programs dsquery and dsmod.  They're both included in Windows XP and above.  If you have a text file with the username and data to be modified you can create a for loop to read the text file and run dsquery piped to dsmod to modify the AD object.
You can get help for them as follows:
Open a command prompt.
type in:
dsquery user /?
dsmod user /?

I was given a similar task and i foud a free tool called 'WiseSoftBulkADUsers'. Made the job very easy.

Have a look and if you need assistance, let me know.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It can be found here:


Seems to be in beta, but if it does the trick: why not...
BO7AREBAuthor Commented:
it was not easy. but a good tool to work on the user on excel file.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Active Directory

From novice to tech pro — start learning today.