Analyzing Exchange ActiveSync data from .CSV report files
You can extract Exchange ActiveSync usage data from your Client Access server's Internet
Information Services (IIS) logs using the Exchange Management Shell (EMS) command
Export-ActiveSyncLog. The Exchange ActiveSync data extraction process creates six different
report files. In this tip, learn how to view these reports and what type of information each report
contains.
Individual Exchange ActiveSync report files are saved in .CSV or comma-separated values format.
In essence, a .CSV file is a comma-delimited text file. Although .CSV files are difficult to read
in text format, you can open them in Microsoft Excel, which lets you view the data in spreadsheet
form.
When you register, you’ll also receive targeted alerts from my team of editorial writers and independent industry experts with the latest news, tips, and advice to help you do your job more efficiently and effectively. Our goal is to keep you informed on the hottest topics and biggest challenges faced by Exchange professionals today working with Exchange, Outlook and other related technologies.
Margie Semilof, Editorial Director
Premium Access
Register now for unlimited access to our premium content across our network of over 70 information Technology web sites.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy
Dig Deeper
-
People who read this also read...
-
This was first published in December 2008
When using Microsoft Excel to open a report, the Export-ActiveSyncLog command writes a
series of words to the .CSV file before it exports data. These words are meaningless when you view
the file in text format, but if you open the .CSV file in Excel, the words serve as column headers.
This is extremely helpful in interpreting the raw data.
NOTE: Most Microsoft Office applications support the use of .CSV files. For example, if you
wanted to analyze Exchange ActiveSync usage trends over a long period of time, you could import the
various report files into Microsoft Access.
The users report
The users report or Users.csv file lets you analyze Exchange ActiveSync activity on a
user-by-user basis. For example, you can see what type of mobile device individuals use to access
Exchange Server. You can also see the number of items each user sends and receives.
The user agents report
The user agents report or User-Agents.csv file generates ActiveSync usage data based on user
agent information. The term user agent refers to the operating system and build number the
mobile device uses. This report details which mobile device operating systems were in use, how many
mobile devices using a particular user agent connected on a given day and how many hits each user
agent generated.
Unfortunately, this report doesn't reveal the average number of hits each user agent generated.
However, the report will tell you how many of each type of user agent was in use and the total
number of hits a user agent type produced. When you divide the total number of hits by the number
of user agents, you'll know the average number of hits for a given user agent. You can use this
information to determine whether there is a specific type of mobile device that is consuming more
wireless traffic than another type of device.
Keep in mind that a higher average number of hits doesn't necessarily mean that a particular
user agent is less efficient. It can mean that some user agents were issued to power users or that
some mobile devices are not configured effectively.
The servers report
The server's report or Servers.csv file essentially tells you which mailbox servers are used
most frequently by mobile device clients.
The status codes report
Generally speaking, the status codes report or StatusCodes.csv file is the least useful report.
It is filled with cryptic codes that may be meaningless to most Exchange administrators. I have not
been able to track down any documentation on these codes, which I assume are there for Microsoft's
own diagnostic purposes.
The policy compliance report
The policy compliance report or PolicyCompliance.csv file supplies the number of Exchange
ActiveSync clients that are currently in compliance with established ActiveSync policies. Although
this report doesn't provide detailed data, it can help target deficiencies. For example, the report
won't tell you why a client is not compliant with the ActiveSync policy, but it will tell
you how many clients are compliant, how many are not compliant, how many are partially compliant
and the number of clients in an unknown state.
The hourly report
Microsoft designed the hourly report or Hourly.csv file to help you spot network usage trends.
You can find out the number of unique mobile devices that synchronized with your Exchange server
within a given hour. Because this report tracks activity throughout the day, it is easy to discover
peak usage periods.
About the author: Brien M. Posey, MCSE, is a five-time recipient of Microsoft's Most Valuable
Professional award for his work with Exchange Server, Windows Server, Internet Information Services
(IIS) and File Systems and Storage. He has served as CIO for a nationwide chain of hospitals and
was once responsible for the Department of Information Management at Fort Knox. As a freelance
technical writer, Brien has written for Microsoft, TechTarget, CNET, ZDNet, MSD2D, Relevant
Technologies and other technology companies. You can visit Brien's personal website at www.brienposey.com.
Do you have comments on this tip? Let
us know.
Please let others know how useful this tip was via the rating scale below. Do you know a
helpful Exchange Server, Microsoft Outlook or SharePoint tip, timesaver or workaround? Email the
editors to talk about writing for SearchExchange.com.
Disclaimer:
Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.
