• RSS
  • Twitter
  • FaceBook

Security Forums

Log in

FAQ | Usergroups | Profile | Register | RSS | Posting Guidelines | Recent Posts

Script to parse message tracking logs

Users browsing this topic:0 Security Fans, 0 Stealth Security Fans
Registered Security Fans: None
Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Programming and More

View previous topic :: View next topic  
Author Message
ryansutton
Trusted SF Member
Trusted SF Member


Joined: 25 Aug 2004
Posts: 67
Location: San Francisco, California

Offline

PostPosted: Thu Oct 29, 2009 10:26 pm    Post subject: Script to parse message tracking logs Reply with quote

Hello,

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

Code:

[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. Very Happy

Suggestions welcomed.

-Ryan
Back to top
View user's profile Send private message
ThePsyko
SF Mod
SF Mod


Joined: 17 Oct 2002
Posts: 16777178
Location: California

Offline

PostPosted: Fri Oct 30, 2009 8:07 pm    Post subject: Reply with quote

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 Smile
Back to top
View user's profile Send private message Send e-mail
ryansutton
Trusted SF Member
Trusted SF Member


Joined: 25 Aug 2004
Posts: 67
Location: San Francisco, California

Offline

PostPosted: Fri Oct 30, 2009 11:33 pm    Post subject: Reply with quote

Well I'm pretty tied up right now with other studies so I ended up outsourcing this. Thank you for the recommendation. Very Happy
Back to top
View user's profile Send private message
Richard_Williams_II
Just Arrived
Just Arrived


Joined: 10 Jun 2009
Posts: 0


Offline

PostPosted: Thu Nov 05, 2009 8:38 pm    Post subject: Parsing large log files using biterscripting Reply with quote

For parsing large log files, you may be able to use the open source script http://www.biterscripting.com/SS_WebLogParser.html .

Richard
Back to top
View user's profile Send private message
ryansutton
Trusted SF Member
Trusted SF Member


Joined: 25 Aug 2004
Posts: 67
Location: San Francisco, California

Offline

PostPosted: Thu Nov 05, 2009 8:48 pm    Post subject: Reply with quote

Thanks for that however we already outsourced the project.
Back to top
View user's profile Send private message
Display posts from previous:   

Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Programming and More All times are GMT + 2 Hours
Page 1 of 1


 
Jump to:  
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!

Community Area

Log in | Register

Readers' Choice

Which is your preferred data recovery solution?

Follow TechGenix on Twitter