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.

Solution


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:

Get-ActiveSyncDevice

image

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.

image

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;}

image

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 ITPROCentral.com, MSExchange.org, Techgenix.com and Anderson Patricio.org (Portuguese).

Related Post

BYOD Basics: Managing Smartphones and Tablets with... Hello folks, Fellow Anthony Bartolo from the Canadian IT Pro Connection (CANITPro.net) blogged an interesting post about ActiveSync when managing BYO...
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.. 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...
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...