Export a list of mobile devices active in your Exchange Online Organization | Office 365


Exchange ActiveSync

Yeah, I know its much awaited feature in Office 365, and more or less, there is very little information available on the internet about this at this time. To be true, there is now a method of exporting list of devices that run exchange ActiveSync on mobile devices. Here is goes:

$MailBox = Get-Mailbox -ResultSize Unlimited
$MailBox | %{$PrimarySmtpAddress=$_.PrimarySmtpAddress; Get-ActiveSyncDeviceStatistics -Mailbox $_.Identity | Select-Object @{Name="PrimarySmtpAddress";Expression={$PrimarySmtpAddress}}, DeviceType, DeviceOS, DeviceMobileOperator, LastSyncAttemptTime} | Export-CSV "D:\ActiveSyncDevices.csv" -Encoding utf8 -NoTypeInformation -Delimiter ";"

The above commands will export all information about your mobile devices configured with last sync time by your users like mobile device, device type, device family and even mobile operator.



I welcome you to write your comments here..