+ Post New Thread
Results 1 to 3 of 3
How do you do....it? Thread, Squid Logfile Analysis by Username in Technical; Just to save me spending the afternoon looking for a tool that doesn't exist, any insights appreciated. Currently still using ...
  1. #1

    Join Date
    Feb 2006
    Location
    Derbyshire
    Posts
    1,381
    Thank Post
    181
    Thanked 211 Times in 171 Posts
    Rep Power
    65

    Squid Logfile Analysis by Username

    Just to save me spending the afternoon looking for a tool that doesn't exist, any insights appreciated.

    Currently still using Censornet V3.x here, quite happy with the filtering but the reporting aspect of it is a bit clunky. It's good for a quick heads up of any banned sites but the 'Sites accessed by' type reports aren't that handy. I believe the reporting is based on webalizer - have had a look at the homepage for this and also Sarg but can't seem to find a demo report that matches what I'm trying to come up with...

    I'd like to get a report sorted where I can drill down to a single username then get a list of domains which have been access along with the time - but not broken right down into a million unreadable links, eg if they've accessed unsuitablesite.com for 10 minutes (yes, I know it'll only show the times pages were requested - that's fine!) then it would just show unsuitablesite.com 1150-1200 etc, at the moment, I can drill down to a user, then a single site, then get a massive list of pages within the domain etc. I suppose I could try and do some magic exporting it all to Excel but if anyone's already using an in depth log parser that can handle something like this I'd appreciate a linky as an early xmas present

  2. #2


    tom_newton's Avatar
    Join Date
    Sep 2006
    Location
    Leeds
    Posts
    4,475
    Thank Post
    866
    Thanked 850 Times in 672 Posts
    Rep Power
    196

  3. #3

    Join Date
    Feb 2006
    Location
    Derbyshire
    Posts
    1,381
    Thank Post
    181
    Thanked 211 Times in 171 Posts
    Rep Power
    65
    Cheers, will give it another look - sample reports weren't working when I tried and I wasn't in the mood for handing out email addresses just to get a demo. Getting somewhere with LightSquid now, it can do a time based report by day but not break down entirely by domain - so for example cgi1.ebay.co.uk, cgi.ebay.co.uk and eBay - The UK's Online Marketplace all show up as different hits. Better than a poke in the eye, if I run it standalone against some logs with a bit of manual filtering first I might get what I need out of it

SHARE:
+ Post New Thread

Similar Threads

  1. [Ubuntu] Squid - Log Analysis
    By Hightower in forum *nix
    Replies: 20
    Last Post: 24th February 2009, 04:19 PM
  2. Performance Analysis
    By kiran in forum MIS Systems
    Replies: 1
    Last Post: 24th January 2009, 11:28 AM
  3. Peformance analysis
    By lancaster.david in forum MIS Systems
    Replies: 0
    Last Post: 24th May 2007, 01:17 PM
  4. CMIS Analysis
    By Kained in forum MIS Systems
    Replies: 0
    Last Post: 25th April 2007, 09:41 AM
  5. Logfile analysis
    By iking in forum How do you do....it?
    Replies: 20
    Last Post: 28th December 2005, 03:54 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •