Slashdot Mirror

← Back to Stories (view on slashdot.org)

Log Analysis Tools for Windows?

Posted by Cliff on from the for-those-who-can't-escape-the-borg dept.

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!"

5 of 37 comments (clear)

  1. Analog by henrik · · Score: 4, Informative

    www.analog.cx

  2. Analog by embo · · Score: 4, Interesting

    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.

  3. err.... um.... by Anonymous Coward · · Score: 4, Funny

    what are you getting paid for again?

  4. A Microsoft tool for a Microsoft job? by Jorkapp · · Score: 4, Informative

    Consider using Microsoft's Log Parser 2.x (2.1 Included in IIS 6.0, 2.0 availible as Download for Win2k/XP/2k3, and is only 2mb.

    It doesn't output to .xls files, but it does let you run SQL like queries against log files of any format. Its availible as command line and as a series of scriptable COM objects.

    http://www.microsoft.com/downloads/details.aspx? di splaylang=en&familyid=8cde4028-e247-45be-bab9-ac85 1fc166a4

    --
    Frink: Nice try floyd, but you were designed for scrubbing, and scrubbing is what you shall do.
  5. Some of these by $exyNerdie · · Score: 4, Informative

    You can try some of these:

    http://awstats.sourceforge.net/

    http://www.multicians.org/thvv/webtrax-help.html

    http://www.ftls.org/en/examples/cgi/ewla.shtml

    http://www.watchwise.net/

    http://www.weblogexpert.com/

    For a detailed list of web log analyzers, go to this page. It has listing of various platform specific and platform independent analyzers:
    http://www.uu.se/Software/Analyzers/Access-analyze rs.html