exchange 2007 + excel 2007 reporting

Is there a way to run a report on how many emails that was sent in a month on the Exchange 2007 box.  Want to then export it over to Excel and then put it into charts.

Thank you
happyexchangeAsked:
Who is Participating?
 
B HCommented:
naively, no... but with the use of some other tools you can automatically parse the logs yes

http://blogs.technet.com/b/exchange/archive/2008/02/07/3404839.aspx


and from here: http://social.technet.microsoft.com/Forums/en-US/exchangesvrmonitoring/thread/5df4e519-f36b-4d1a-a609-58b064d1bd1b/
this:
Other useful information is who is receiving most mail.
"C:\Program Files\Log Parser 2.2\LogParser.exe" "Select Top 10 Recipient-Address as Recipient,Count(*) as hits From *.log Where Event-ID = 1019 Group By Recipient Order By hits DESC" -i:W3C


Who is sending most email.
"C:\Program Files\Log Parser 2.2\LogParser.exe" "Select Top 10 Sender-Address as Sender,Count(*) as hits From *.log Where Event-ID = 1019 Group By Sender Order By hits DESC" -i:W3C

which requires this:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=890cd06b-abf8-4c25-91b2-f8d975cf8c07&displaylang=en
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.