For a single user you can run
Get-ActiveSyncDeviceStatistics -Mailbox "John Smith" | Select-Object @{n="Mailbox";e={$mailbox}}, LastSuccessSync, Status, DeviceID, DeviceType, DeviceUserAgent, DeviceModel, DeviceIMEI, DeviceOS
For all users you can run
Set-AdServerSettings -ViewEntireForest $True
Function New-Array {,$args}
$Report = new-array
$file_out = "C:\temp\mobile_devices.csv"
$mbx = Get-CASMailbox -ResultSize Unlimited | ?{$_.HasActiveSyncDevicePartnership}
$mbx | ForEach-Object {
$mailbox = $_.Name
$PrimarySMTPAddress = $([string]$_.PrimarySMTPAddress)
$stats = Get-ActiveSyncDeviceStatistics -Mailbox $PrimarySMTPAddress
if($stats){
foreach ($dev in $stats){
$device = New-Object System.Object
$device | Add-Member -type NoteProperty -name Mailbox -value $mailbox
$device | Add-Member -type NoteProperty -name LastSuccessSync -value $dev.LastSuccessSync
$device | Add-Member -type NoteProperty -name DeviceID -value $([string]$dev.DeviceID)
$device | Add-Member -type NoteProperty -name DeviceType -value $dev.DeviceType
$device | Add-Member -type NoteProperty -name DeviceUserAgent -value $dev.DeviceUserAgent
$device | Add-Member -type NoteProperty -name DeviceModel -value $dev.DeviceModel
$device | Add-Member -type NoteProperty -name DeviceIMEI -value $([string]$dev.DeviceIMEI)
$device | Add-Member -type NoteProperty -name DeviceOS -value $dev.DeviceOS
$Report += $device
}
}
}
$Report | Export-Csv $file_out -NoType
Credit to: http://exchangeblog.pl/en/2012/10/exchange-2010-activesync-devices-list/
