msExchange_list_MobileDeviceStatistics

msexchange_list_mobiledevicestatistics.ps1

#
# PSSnapin Load
if ( (Get-PSSnapin -Name Microsoft.Exchange.Management.PowerShell.E2010 -ErrorAction SilentlyContinue) -eq $null )
{
    Add-PsSnapin Microsoft.Exchange.Management.PowerShell.E2010
}
#
# Create list with MobileDeviceStatistics for each mailbox extend output with Mailbox and MailboxUser
#
$UserList = Get-CASMailbox -Filter {hasactivesyncdevicepartnership -eq $true -and -not displayname -like "CAS_{*"} | Get-Mailbox
$UserList | foreach { 
$User = $_
Get-MobileDeviceStatistics -Mailbox $_} | fl @{l='Mailbox';e={$User.SamAccountName}},@{l='MailboxUser';e={[regex]::Match($_.Identity,'^.+/(.+)/ExchangeActiveSyncDevices/.+').Captures.groups[1].value}},*