How to get the external email address of a mail user with get-mguser

Question

I sync all of my users from on-prem AD to Azure. Some have mailboxes and some are mail users with external email addresses. I can see the external address in Exchange on-prem and Exchange Online, but Get-MGUser frequently returns the user's UserPrincipalName in the Mail field instead of the real email address. And Get-MGUser's ProxyAddresses doesn't list the external address at all.

Is there some other field I can access with Get-MGUser that will give the external email address of a mail user and only the external email address?

Answer 1

 Hi @ Jay Carper ,

You can use the format-list parameter to view all parameters for a specified user, for example:

Get-MgUser -UserId ‘27d57b10-ae36-4113-bb27-d8d4dafa4345' |   Format-List

However, my tests show that there are no other parameters to display email addresses other than Mail and UserPrincipalName.

In addition, I use the Get-MgUser command to get all users, and I can get the following types of recipients , except for mail contacts:

·         User mailbox

·         Shared mailboxes

·         Mail users

·         Guest users

And, the results are compared to guest users in the Exchange admin center, and the email addresses displayed under Mail are their external address.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Check the mail and otherMails properties. But in general, for any Exchange-related objects and properties, you should be using the Exchange Online cmdlets instead.

Answer 3

 

 Hi @ Jay Carper ,

As Michev says, you can use Exchange Online cmdlets to get the relevant properties of a user mail.

For example:

Get-MailUser -Identity "tony" | fl ExternalEmailAddress

In addition, for the get-mguser command, I suggest you can use the Format-List command to get all the relevant parameters to see if there is an external email address.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 4

I know I can use the Exchange cmdlets to get this information, but it would be a lot more efficient if I could use a single command instead of two, especially since I'll then have to merge the output with custom columns.

So, back to my original question...

You can get ProxyAddresses and Mail using Get-MGUser, but it's not returning accurate data. Are there other fields that can be accessed using Get-MGUser that contain the user's real primary/external email address?

Answer 5

The problem seems to be related to removing an Exchange license from a user. If you have a synced user with a remote mailbox in Exchange Online, and then you remove the remote mailbox and Exchange license and enable the on-prem user as a mail user with an external email address instead, Azure will change the Mail attribute from the old PrimarySmtpAddress to the MOERA/UPN.

I have a support request open with Microsoft and they've been trying to figure it out for almost a month now.