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

9 of 37 comments (clear)

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

    www.analog.cx

    1. Re:Analog by exhilaration · · Score: 2, Informative

      Yes, Analog, AWStats, and Webalizer (here's Webalizer Win32) are the three packages that my web host installs for all its users.

    2. Re:Analog by bjpirt · · Score: 3, Informative

      I currently use webalizer, but felt like it should be doing a lot more with the information in the log files. Hell, even I could spot more trends from just looking at the log file raw.

      So I took a look at AWStats and (although slower - it's written in perl not compiled c) it looks to have a lot more useful features.

      Usefully though, I came across this comparison chart comparing these three options plus another. Hope this helps.

      bjpirt

  2. Excel by BladeMelbourne · · Score: 3, Informative

    FYI - many web applications that export to a .xls file, are simply creating an HTML document, (hopefully with tables in it), and changing the header so the browser does not think the file is text/html.

    eg:

    Response.ContentType = "mime-type application/vnd.ms-excel"
    Response.AddHeader "content-disposition", "attachment; filename=auto-gen.xls"

    You can also do the same to generate M$ Word files - although they dont need a table inside. These files can be opened in M$ Office and OpenOffice.

    Mike

  3. awstats by Shaheen · · Score: 2, Informative

    I use AWStats on a home web server.

    It's written entirely in perl so it can work on Windows just fine as well. To see a sample go here.

    --
    You should never take life too seriously - You'll never get out of it alive.
  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

  6. Absoulte by BenTheDewpendent · · Score: 2, Informative

    Absolute log analyzer. exports to excel and many other things. Pro version is $250 but looks to be quite flexible.

  7. WUSAGE is the best, I think... by Cragen · · Score: 2, Informative
    Wusage is $25 for a single server, $75 for 5 domains, & $275 - unlimited. I think it's the best you can get -- available for all web servers and OS's, I think. I used it for years back when I was web-mastering. Have fun,

    *cragen.