Change all login user names

Our standard for usernames is to use a first initial lastname ...

With a recent takeover, we've been asked to to change all usernames to a firstname.lastname convention.

So John Doe ... is currently JDoe .. needs to be John.Doe ...

Is there an easy way to change all user login names to the new convention without affecting anything else?

Thanx ...

Ming ...
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.

TomislavjSystem AdminCommented:
maybe with script that can manage importing data from file like this one
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Joseph DalyCommented:
The fastest and easiest way of doing this will be to use Its a nice GUI and lets you revert changes as well. This tool will let you use wildcards to do the work for you as well. Something similar to


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
ThinkPaperIT ConsultantCommented:
your first step is export from AD a list of all your users with their logon name, first name, and last name, (and maybe middle name too in case of duplicates). You should easily be able to create a query within AD to do this and export it. With that spreadsheet you can organize the columns and create a new column for the new naming convention. You can use Excel to propogate it with firstname.lastname. After that you'd have to go thru and make sure there are no duplicate names.

After that, you can use PowerShell to read in the CSV to rename the user accounts. Quest AD cmdlets would also work:

So your CSV should look something like this:
(note that you need to correct any duplicate names)

logon, firstn, lastn, midn, newusername
smithj, john, smith, l, john.smith
smithj2, john, smith, k, john.k.smith          
johnsonl, larry, johnson, b, larry.johnson
villab, bob, villa, r, bob.villa
villab1, brian, villa, w, brian.villa
villas, stephen, villa, w, stephen.villa

Then your PowerShell would look something like: (using Quest AD cmdlets)

Import-CSV "c:\mystuff\importedusers.csv" | ForEach { Rename-QADObject $_.logon -NewName $_.newusername}

(Note I haven't test it, so make sure you FULLY test it before deploying network wide).
There is bulk modify tool and i guess you can use that. Changing account login will not do any harm as i did in the past becasue SID will remain same, so permission and everything will be as earlier.

You can also search for script at below

Awinish Vishwakarma
gmponAuthor Commented:
handy utility to have.
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
Windows Server 2003

From novice to tech pro — start learning today.