Help getting UPN, email address, or user name from ActiveSyncDeviceStatistics or Get-MobileDeviceStatistics

king daddy
king daddy used Ask the Experts™
on
This is what I am using to get a Mobile Device report from our Office 365 server. I get Identity in the report, but it looks like this and is not easy to work with.

SERVER.PROD.OUTLOOK.COM/Microsoft Exchange Hosted Organizations/company365.onmicrosoft.com/Display Name/ExchangeActiveSyncDevices/Android?androidc97397597
SERVER.PROD.OUTLOOK.COM/Microsoft Exchange Hosted Organizations/company365.onmicrosoft.com/Display Name/ExchangeActiveSyncDevices/iPhone?7YHLOI8DER5HCN01HYHY8UDEC

This is the power shell I am running:

$Mailboxes = Get-Mailbox -Identity $_.UserPrincipalName -RecipientTypeDetails UserMailbox -ResultSize Unlimited
$Devices = $Mailboxes | %{Get-ActiveSyncDeviceStatistics -Mailbox $_.Identity} | `?{$_.LastSuccessSync | export-csv PATH

I need to get the email address, UPN, or even the user's display name in a column.

Any help much appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
You just have to run additional queries in order to resolve the identity to UPN. Here's one of my scripts that does just that: https://gallery.technet.microsoft.com/office/Office-365-Mobile-device-9fff6110

Author

Commented:
Thanks, Vasil. It is running now.

Author

Commented:
Perfect. Thanks again, Vasil.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial