Creating basic ActiveSync reports

Share this:

In this Tutorial we are going over the basics to generate basic ActiveSync reporting in Exchange Server 2010 and the same applies to newer versions of Exchange Server.


The first step is to list all ActiveSync devices registered in your organization, and that is simple you can start by using the following cmdlet:



How about if you want to know the number of devices? Well that is pretty easy, just use the same cmdlet above and add ().count and you will get the total number of devices, as shown in the image below.


In some cases, the administrator wants to list all devices per mailbox from a specific organization unit. Using this cmdlet we can achieve the requirement in a single line.

get-mailbox –OrganizationalUnit domain.local/USA | foreach { write-host “Mailbox..:” $_.Name; start-sleep 2; Get-ActiveSyncDeviceStatistics -Mailbox $_.Alias | select DeviceType,DeviceID,DeviceModel,DeviceOS,LastSuccessSync;}


Well, in this Tutorial we checked a couple of cmdlets that can help the administrator to retrieve some numbers of activesync devices, that is just the tip of the iceberg, we can use the same cmdlets to generate different type of reports, and also export and play with the data in Excel or PowerBI.

Written by Anderson Patricio

Anderson Patricio is a Canadian Exchange Server MVP and MCSM (Solutions Master) and he contributes to the Microsoft Community with articles, tutorials, blog posts, forums and book reviews. He is a regular contributor at, and (Portuguese).