Modify user telephone number field in Active Directory

ADModify is a good tool for bulk edits
http://www.codeplex.com/admodify
However in your situation if you need to change hundreds of numbers that are wrong then there really isn't a superfast way because you will still have to make sure every number is right for every user.
We had a similar issue the last place I was at.  In the end we had our users modify their own info (number, office #, location).   They were moving and changing offices and phones so much and we were never updated.
We used http://www.directory-update.com/
 Thanks
Mike

Are the numbers the same for each user? If so, something like ADModify would seem appropriate.

If they numbers differ then that's not so good but it can be scripted easily. If you'd like to investigate that method you presumably have a list you'd like to import?

Chris

The numbers are all different so a bulk modify will not work unless it will allow importing from one source like excel and then using that information to update all the AD accounts.

We can import from Excel, or preferably from a CSV file (less hassle).

What kind of details do you have in the Excel sheet? We need something that'll allow us to pick up the user account without too much trouble. Ideally a username, or e-mail address, although we can use first name and last name at a push.

Chris

I have found a program that will modify the field for me which is AD Bulk users by dovestone software.
what I need now is to export from AD the sAMAccountName to put into a file the program uses
I have tried with csvde but can't seem to get the syntax correct have any of you done this before?

You only want the sAMAccountName?

If you have the Windows Support Tools installed this will drop those to a text file:

dsquery user | dsget user -samid > AFile.txt

Do you need more fields?

Chris

In order to update I need username (sAMAccountName and telephone number