Forum Moderators: open

Message Too Old, No Replies

Need Help with Parsing Large IIS Log Files

         

shaunm

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

10+ Year Member Top Contributors Of The Month



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!

tangor

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

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



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.

shaunm

8:59 am on Mar 15, 2016 (gmt 0)

10+ Year Member Top Contributors Of The Month



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.

tangor

9:21 am on Mar 15, 2016 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



Check the import functions built into Access. Works a treat. Just build your database appropriate for whatever your log output displays.

shaunm

10:31 am on Mar 15, 2016 (gmt 0)

10+ Year Member Top Contributors Of The Month



It looks like I need to have some basic skills to work around Access. Thanks for the help!

freitasm

8:50 am on Mar 16, 2016 (gmt 0)

10+ Year Member Top Contributors Of The Month



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

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