There are a few options for you to get ActiveSync statistics from an Exchange 2010.

First some Powershell and then Log Parser if you don’t want to dig into the IIS-Logs yourself 😉


Get-ActivesyncDevice: Retrieve list of devices that have ActiveSync partnerships.


Get-ActiveSyncDeviceStatistics : Returns statistics about each device.


Export-ActiveSyncLogs : Analyzes IIS-Logs and creates reports in CSV-format.

Export-ActiveSyncLogs will generate six CSV files: “Users.csv”, “Servers.csv”, “Hourly.csv”, “StatusCodes.csv”, “PolicyCompliance.csv” and “UserAgents.csv”.

The IIS-Logs also hold username and IP-adress for the mobile device. Useful to know when the firewall guys come running down the corridor with the IP-adress for a misbehaving sync 🙂

If you have several CAS servers, you need to process the IIS-logs from each one of them.



LogParser 2.2 :

LogParser Studio:





LogParser Studio is also able to export the query as a Powershell script.