Log Analysis Tools for Windows?

FunkMonkey asks: "I administer a custom web app for my company (unfortunately, it's a Windows-only company -- servers and all), and I've been asked to find a web log analysis tool that our users can use to look at standard stats (number of visits/hits, etc.), as well as the ability to filter by authenticated users (including putting those users into groups). Additionally, the tool must be free or under $100.00, and be able to generate Excel (or Excel-compatible) reports. My app generates ECLF reports, so just about any web log analyzer should be able to read the logs themselves. I see this as a good opportunity to weasel some Open-Source stuff into the company. Any help you can offer -- suggesting apps, tips, forums to which I could post this question, etc. -- would be most welcome. Thanks in advance!"

Comments

Analog

[embo]

You should look at Analog. It is free, and open source. While it probably doesn't export straight to Excel, you would likely have two choices there:

First, since it's open source, you could add support to export to CSV fairly easily.

Second, Analog can export to what it calls "COMPUTER" output, which is designed for easy parsing. Couple the COMPUTER output with a little Python or PERL, and you'll have a CSV file fairly quickly.

When you're finished looking at Analog, make sure you also consider Report Magic for Analog to make things look pretty in a browser.

Re:Analog

[xmas2003]

Roger that recommendation on Analog - works good for me - and was helpful in doing an analysis of the Slashdot Effect on Christmas Lights which includes actual output from Analog that you might find interesting.