Exchange on-premises Message Tracking Logs Analysis

Steel Contributor

Calling on Exchange admins with scripts (or just commands) to analyze Message Tracking logs.  I would like to be able to summarize a days' worth of email that flowed through Exchange Server.

 

It's very hard.

 

In particular, I'm thinking of metrics like these:

  • # of messages (sent / received / total) - and proper counts, not count of each event for each message.
  • Top NN senders
  • Top NN recipients
  • Top NN Subjects, message ID (top anything I suppose)
  • Total Bytes per hour / timerange / etc.

Would anybody happen to have some experience with this kind of a chore and be interested in helping me out.  I'd love to create a script for this task, and hopefully will, and if I do, I'll definitely share it, and it will be filled with parameters to dial in exactly what we're after, and error handling / other protections to make sure it's robust.  For the immediate term, I figured I should come here and check.

 

Thanks in advance.

2 Replies
Thank you for this one. It looks like a great set of reports. I do need to spend some time reviewing it before I could put it to use in customer environments. So many thanks and I will try it out. At the same time, additional suggestions welcomed.