Exchange 2003 – Active Sync reporting?
Taken from Microsoft’s Exchange Team Blog and modified, we have been able to take two SQL scripts, run them against our Front-end Protocol servers, and retrieve usage data pertaining to Active Sync users and clients. The first script produces a ‘Hits by User’ Report which will show you which users are hitting your EAS servers. This report provides many of the statistics that could help you better understand how your users are interacting with your EAS deployment. It returns information by individual user such as, devices type used, number of Syncs, Emails Sent, Attachments downloaded, Meeting Responses, etc.
The second script produces is a ‘Hits by DeviceType’ Report. This report gives you a breakdown of the DeviceTypes (SmartPhone, PocketPC, etc.)
You need several things setup in order for the scripts to work:
- Install Microsoft’s LogParser 2.2 or later on your Front-End Exchange server(Get it here)
- Copy both SQL scripts to the "C:\Program Files\Log Parser 2.2" directory on your Front-End Exchange server. If you have more than one server, this will need to be ran on every Front-end server n your organization to get accurate results. (IIS logs are being parsed)
- Get the scripts. Script 1 (Save as Hits_By_User.Sql) and Script 2 (Save as Hits_by_DeviceType.Sql). (Email Me for the scripts)
Once saved, open a command prompt to "C:\Program Files\Log Parser 2.2" from your Front-End Exchange server.
Issue this command: LogParser.exe -i:IISW3C file:"C:\Program Files\Log Parser 2.2\Hits_By_User.sql"
This is going to create a file named Hits_By_User.csv in the root of C:\. Depending on your usage the script may take 15-30 minutes to run.
Once complete, open a command prompt to "C:\Program Files\Log Parser 2.2" from your Front-End Exchange server.
Issue this command: LogParser.exe -i:IISW3C file:"C:\Program Files\Log Parser 2.2\Hits_By_DeviceType.sql"
This is going to create a file named Hits_By_DeviceType.csv in the root of C:\. Depending on your usage the script may take 15-30 minutes to run.
Results should look similar to this: (By User)
, 60 *Other devices