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 : http://www.microsoft.com/en-us/download/details.aspx?id=24659

LogParser Studio: http://blogs.technet.com/b/exchange/archive/2012/03/07/introducing-log-parser-studio.aspx

 

LogParserStudio

LogParserStudioQ1

 

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