EDATSUSYSOPS
asked on
Normalizing phone numbers in active directory
I need to change the way my phone numbers look in Activie Directory. Currently our format is 951.111.1111 but it needs to look like 19519551111. Currently using Server 2003 SP2. Last restort is to do everyting manually.
you should be able to select all user accounts, right click>properties and phone # is 1 of the fields that can be changed for all at once
ASKER
This would work if they all had the same phone number, but unfortunately, each person has their own number. I need to do this for the phone, mobile and fax numbers.
here is a link to use csvde and ldifde
http://thelazyadmin.com/2005/03/using-csvde-and-ldifde-for-active-directory-management/
http://thelazyadmin.com/2005/03/using-csvde-and-ldifde-for-active-directory-management/
I think you might need to first export all the data to get all the phone numbers. Then directly import the new phone numbers to all the users (like over writing them) with help of script or bulk operations?
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.