Exchange 2003 - Active Sync reporting

Exchange Activesync Reporting

Jason Langridge's WebLog - MR Mobile! — Wed, 15 Feb 2006 05:52:28 GMT

One of the big requests we've had from large deployments of Exchange Activesync is the ability to generate...

re: Exchange 2003 - Active Sync reporting

Peter Mohr — Wed, 15 Feb 2006 08:20:28 GMT

Good stuff!! Works like a charm

A better way to view Activesync logs.

Neil Chapman's Blog — Thu, 16 Feb 2006 13:53:15 GMT

I just tried&nbsp;the&nbsp;SQL script for getting a useful view of the activesync logs from here:
http://blogs.technet.com/exchange/archive/2006/02/14/419562.aspx...

Weekend reading

subject: exchange — Sun, 19 Feb 2006 22:04:12 GMT

I almost missed the weekend, but gladly I made it on time&nbsp;;-)

Rivals Take Aim at RIM
Microsoft...

re: Exchange 2003 - Active Sync reporting

Mike Ireland — Thu, 23 Feb 2006 17:46:18 GMT

Great code, thanks for sharing. You can clean the code up by replacing the substring commands you are using to pull data out of the cs-uri-query with EXTRACT_VALUE. For example, this:

SUBSTR (cs-uri-query, ADD (INDEX_OF (cs-uri-query, 'DeviceType='), 11),
INDEX_OF (SUBSTR(cs-uri-query, ADD (INDEX_OF (cs-uri-query, 'DeviceType='), 11)), '&')) AS MyDeviceType

Can be simplified to:

EXTRACT_VALUE(cs-uri-query,'DeviceType') AS MyDeviceType

Much cleaner and my tests showed that it ran the analysis nearly 50% faster on large logs.

re: Exchange 2003 - Active Sync reporting

Alan Sebastian — Thu, 02 Mar 2006 00:19:48 GMT

This is exactly what I've been looking for. Although there is one aspect I would love to add if possible which is the time of last sync. Since many of the users in this list could be gone from the company now, it would be good to know the time of the last good sync of each user. Is this easily added to the .sql file?

Thanks!
Alan Sebastian
Alan.Sebastian@hansonamerica.com

More on Exchange ActiveSync Reporting with Log Parser – COM object available

You Had Me At EHLO... — Fri, 03 Mar 2006 21:19:35 GMT

We recently posted details on how to use Log Parser to parse out Exchange ActiveSync (EAS) information...

re: Exchange 2003 - Active Sync reporting

MaxDamage — Fri, 10 Mar 2006 13:20:13 GMT

Dam

I just spent two days writing this exact report in VBscript. That will teach me to pay more attention :)

If you are interested I can share the code ?

Regards Max

re: Exchange 2003 - Active Sync reporting

ptousig — Mon, 20 Mar 2006 23:24:28 GMT

To answer Alan's question above, you can add:
MAX(date)
to the list of columns returned. That will give you the date of the last request sent, which you could use to figure out who left the company (or threw their phones in a lake). It gets a little trickier to do for the last "good" sync. I would probably revert to some perl script to do that, although I've seen some pretty clever uses of SQL statements, so maybe it would be possible to do it all in one statement.