Welcome to WebmasterWorld Guest from 3.81.29.226

Forum Moderators: ocean10000

Message Too Old, No Replies

Need Help with Parsing Large IIS Log Files

     
7:42 am on Mar 15, 2016 (gmt 0)

Full Member

5+ Year Member Top Contributors Of The Month

joined:June 18, 2012
posts:341
votes: 1


Hello All,

How do you usually parse large IIS log files? I heard both Splunk and Botify are good at reading log files and presenting the data from SEO perspective. But I'm trying to find alternates to the paid tools before jumping into them. I tried excel which is good for small file sizes but failed in my case where there are multiple files of large sizes. I also tried Microsoft LogParser and don't seem to understand the CMD commands.

Any help would much be much appreciated. Thanks!
7:59 am on Mar 15, 2016 (gmt 0)

Senior Member from US 

WebmasterWorld Senior Member tangor is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Nov 29, 2005
posts:10557
votes: 1118


Dump your logs into Access, MySql, Oracle or whatever you have and work with the reporting functions from there. Your logs, after all, are nothing more than a flat database file.
8:59 am on Mar 15, 2016 (gmt 0)

Full Member

5+ Year Member Top Contributors Of The Month

joined:June 18, 2012
posts:341
votes: 1


Thanks. Can you please elaborate further on how I use Access to parse the Log files as I don't see any resources online? I just wonder why the MS forums suggest to use LogParser then.
9:21 am on Mar 15, 2016 (gmt 0)

Senior Member from US 

WebmasterWorld Senior Member tangor is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Nov 29, 2005
posts:10557
votes: 1118


Check the import functions built into Access. Works a treat. Just build your database appropriate for whatever your log output displays.
10:31 am on Mar 15, 2016 (gmt 0)

Full Member

5+ Year Member Top Contributors Of The Month

joined:June 18, 2012
posts:341
votes: 1


It looks like I need to have some basic skills to work around Access. Thanks for the help!
8:50 am on Mar 16, 2016 (gmt 0)

Full Member from NZ 

10+ Year Member

joined:July 28, 2003
posts: 318
votes: 7


Have you trried Log Parser Lizard (http://www.lizard-labs.com/log_parser_lizard.aspx)?

It makes it really easier to go through logs...