Joined: 25 Aug 2004 Posts: 67 Location: San Francisco, California
Posted: Thu Oct 29, 2009 10:26 pm Post subject: Script to parse message tracking logs
Does anyone know of a script, or method in which I can parse log files and extract some specific information? I have about 100MB of Exchange message tracking logs. I need to figure out a way to go through this data and find all emails sent from 10 specific users, excluding emails sent internally, dates they were sent and produce this information in a spreadsheet.
This is the output I am trying to get from the logs
[Internal Sender]---[External Recipient]--[Date Sent]--[# of emails sent]
I have been trying to see if I could import them in to an Access table and then run a query against that. I have not been successful doing that.
Joined: 17 Oct 2002 Posts: 16777178 Location: California
Posted: Fri Oct 30, 2009 8:07 pm Post subject:
A quick and dirty (and very ugly output) way would be to use the find command - but that won't give you the format you want. Perl would be my choice for something like this - if you don't know Perl, this would be an excellent excuse to learn it
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Looking for more Windows Networking info?
Sign up to the WindowsNetworking.com Monthly Newsletter, written by Enterprise Security MVP Deb Shinder, containing news, the hottest tips, Networking links of the month and much more. Subscribe today and don't miss a thing! View a sample newsletter.
Become a WindowsNetworking.com member!
Discuss your Windows Networking issues with thousands of other Windows Newtorking experts. Click here to join!