Extracting Activesync Logs from Exchange 2007

Had to try and troubleshoot an ActiveSync connectivity problem as I discovered though there is  no GUI mechanism that analyzes ActiveSync logs, so you I  had to use the Exchange Management Shell and the Export-ActiveSyncLog cmdlet to export the data.

To do so, you need to know the date that the desired data was collected, and the path to which you want to dump the extracted data. For example, suppose that you wanted to extract data that was collected on October 29 2009 and move it to a folder called C:\Logs. In this situation, you would use the following command:

Export-ActiveSyncLog -FileName:’C:\Inetpub\logs\LogFiles\W3SVC1\u_ex091029.log -UseGMT:$true -OutputPath C:\aslogs\(this was run on windows 2008)

powershell

This file name is based on the date chosen, which is entered in YYMMDD format. Exchange Server will then create six csv files in the target directory. The first CSV file that Exchange Server creates is Users.csv. This file logs user activity.

User-Agents.csv is the second CSV file that Exchange Server 2007 creates. This file logs activity according to device type. 

The Servers.csv file reports ActiveSync-related activity on a mailbox server-by-mailbox server basis. 

The PolicyCompliance.csv file reports on how well various wireless devices comply with established ActiveSync mailbox policies. 

The StatusCodes.csv file contains various undocumented codes designed for use by Microsoft technical support staff

Advertisements

Tags: ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: