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.
1 2 3 4 5 |
Get-ActiveSyncDevice -mailbox [mbxidentity] Get-Mailbox [mbxidentity] | Get-ActiveSyncDevice | Out-Gridview |
Get-ActiveSyncDeviceStatistics : Returns statistics about each device.
1 2 3 |
Get-ActiveSyncDeviceStatistics -mailbox [mbxidentity] |
Export-ActiveSyncLogs : Analyzes IIS-Logs and creates reports in CSV-format.
1 2 3 4 5 |
Export-ActiveSyncLog -Filename: "X:\inetpub\logs\LogFiles\W3SVC1\LOGNAME.log" -OutputPath: "C:\Outputfolder\" Get-ChildItem "X:\LogFilesWeek1" | Export-ActiveSyncLog –OutputPath "C:\Outputfolder\" |
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
LogParser Studio is also able to export the query as a Powershell script.