EAS Reporting Exchange Server 2007
Exchange ActiveSync Info > Exchange ActiveSync Reporting
Administrators Pocket Guide
This document was created to assist and IT Pro in setting up and using the Exchange ActiveSync Reporting functionality that was built into Exchange Server 2007.
Getting Started
The Exchange ActiveSync reporting solution is a Powershell task that pulls a set of IIS Log(s) from a single location or N number of locations and processes them together to create a series of CSV output files. Each file is a separate report that can help you as the IT Professional understand more about your Exchange ActiveSync deployment.
How to install
The Export-ActiveSyncLog task is installed by default with Exchange Server 2007.
How to RunPermissions Required
In order to run this task you will need to have the following permissions:
- Read access to the directory where the IIS Logs are located.
- Exchange Roles:
o Server Admin
o Org Admin
Command Line
The Export-ActiveSyncLog task is able to process a set of IIS Logs by piping the results of a specified directory into the Export-ActiveSyncLog task.
Here are the input parameters:
Parameter Name
|
Definition
(What is this?)
|
Required?
|
Default Value
|
-FileName
|
Location of the IIS Log. Can take in a set of logs by using this syntax:
Dir [Location] | Export-ActiveSyncLog
Eg.
Dir D:\Logs\*.log |Export-ActiveSyncLog
|
Yes
|
Null
|
-StartDate
|
Start date for range used in processing reports from this task.
Date Format:
7/3/2006 10:05:14 AM
|
No
|
If no start date is provided the task will process all IIS Logs.
|
-EndDate
|
End date for range used in processing reports from this task.
Date Format:
7/3/2006 10:05:14 AM
|
No
|
If no end date is provided the task will process all IIS Logs.
|
-OutputPath
|
Location where you want the logs saved.
|
No
|
Location where Export-ActiveSyncLog runs.
|
-OutputPrefix
|
You can use this parameter to set a prefix to the filename. This could be helpful if you wanted to add the date to the name of the file.
Eg. 063006 would look like this…
063006Hourly.csv
Optionally you could use this feature for these types of naming conventions as well…
- CAS1Hourly.csv
- RedmondDomainHourly.csv
|
No
|
Null
|
UseGMT
|
If parameter = True, then the Export-ActiveSyncLog will use GMT in the report output. Otherwise Local Time will be the default time.
|
No
|
Local Time is used by Default.
|
Force
|
Use this parameter if you want to overwrite existing files that were previously created by this task that have the same file name.
|
No
|
By default the task will ask you for confirmation to overwrite the file.
|
Script
You can use a script like the following to retrieve and process logs from multiple IIS Log sources:
A more advanced script could request a series of input parameters before executing such as the Start and End Dates and whether you want to always specify a certain OutputPrefix name such as the date when the script was run, or some other naming convention.
Reports generated by Export-ActiveSyncLog
For more details on the reports generated by the Export-ActiveSyncLog task. Click here for Report details (http://www.exchangeninjas.com/EASReportDetails)
| 
