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

Anderson Patricio is a Canadian MVP in Cloud and Datacenter Management, and Office Server and Services, besides the Microsoft Award he also holds a Solutions Master (MCSM) in Exchange and several other certifications. Anderson has been contributing to the Microsoft Community with articles, tutorials, blog posts, twitter, forums and book reviews. He is a regular contributor here at,, and Anderson (Portuguese).

Related Post

Retrieving ActiveSync Logs: Using Outlook Web App Good morning my friends (long time no see, after a couple of days in holidays I’m back!) In Today’s post we are going to check it out the ActiveSync ...
Administrator initiated remove wipe in Exchange Se... In this Tutorial we are going over the process to remote wipe a mobile phone using Exchange Server 2010 console. Solution A customer of mine is st...
How to enable Quarantine for Mobile devices in Exc... In this Tutorial we are going over the process to enable quarantine for mobile devices in Exchange Server 2013. This is really nice feature where a s...
How to.. generate a list of all ActiveSync devices... In Today’s post we are going over a simple cmdlet to generate a list of all ActiveSync devices that you have in your organization For starters, we ca...