We are running Exchange 2013 CU9.  I found out today that there are departments and managers running reports that pull from the Alias field in Exchange.  Pre-2013, the Alias was FirstName, LastInitial.  Our reports were off today because a user who was created on the new system now has an alias of FirstInitial,LastName.  Is there a way to change this globally, so that all aliases are FirstName,LastInitial.  Any help would be greatly appreciated.

--Scott

• Edited by slrobb 9 hours 44 minutes ago sentence structure

Yes, and that way is to write a script.  Be aware that it may change e-mail addresses if your e-mail address policy is keyed on the alias.

You may try this...

get-recipient -Resultsize Unlimited | ?{$_.recipienttype -eq "userMailbox" -and $_.alias -ne ($_.lastname)+"."+($_.firstname).substring(0,1)} | %{set-mailbox $_.identity -Alias (($_.lastname)+"."+($_.firstname).substring(0,1))}

Before doing this for all users I would recommend you to try this in test environment first, do this in staggered manner something like this...

Verify that you are getting only needed recipients only with this (which have firstname.lastname in alias)

get-recipient -Resultsize Unlimited | ?{$_.recipienttype -eq "userMailbox" -and $_.alias -ne ($_.lastname)+"."+($_.firstname).substring(0,1)}

Then set it on few users (starting with A) like this

get-recipient A* -Resultsize Unlimited | ?{$_.recipienttype -eq "userMailbox" -and $_.alias -ne ($_.lastname)+"."+($_.firstname).substring(0,1)} | %{set-mailbox $_.identity -Alias (($_.lastname)+"."+($_.firstname).substring(0,1))}

Then go for all, but as Ed warned, it may change the email addresses as well if policy says to set the email address based on alias...