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

Modify user telephone number field in Active Directory

I need an easy way to modify all my active directory user telephone number fields, their numbers ale all over the place and I need to make them a standard format as well as putting in the correct num
0
MANNATEAM
Asked:
MANNATEAM
  • 3
  • 3
  • 2
1 Solution
 
Mike KlineCommented:
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
0
 
Chris DentPowerShell DeveloperCommented:

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
0
 
MANNATEAMAuthor Commented:
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.
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
Chris DentPowerShell DeveloperCommented:

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
0
 
MANNATEAMAuthor Commented:
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?
0
 
Chris DentPowerShell DeveloperCommented:

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
0
 
MANNATEAMAuthor Commented:
In order to update I need username (sAMAccountName and telephone number
0
 
Mike KlineCommented:
I like using adfind for this (the dsquery/dsget combo works too)
http://www.joeware.net/freetools/tools/adfind/index.htm
adfind -b dc=yourdomain,dc=com <or whatever your suffix is> -f  "&(objectcategory=person)(objectclass=user)" samaccountname telephonenumber -nodn   -csv  > c:\users.csv
That will dump the users samaccountname and phonenumber into a csv file on your C drive
Thanks
Mike
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

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