+ Reply to Thread
Results 1 to 3 of 3

Thread: Squid Logfile Analysis by Username

  Share/Bookmark
  1. #1

    Reputation Reputation Reputation Reputation Reputation Reputation Reputation Reputation Reputation

    Join Date
    Feb 2006
    Location
    Derbyshire
    Posts
    1,374
    Thank Post
    175
    Thanked 207 Times in 168 Posts
    Rep Power
    53

    Default 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


    Reputation Reputation Reputation Reputation Reputation Reputation Reputation Reputation Reputation Reputation Reputation Reputation
    tom_newton's Avatar
    Join Date
    Sep 2006
    Location
    Leeds
    Posts
    2,489
    Thank Post
    272
    Thanked 342 Times in 259 Posts
    Rep Power
    78

  3. #3

    Reputation Reputation Reputation Reputation Reputation Reputation Reputation Reputation Reputation

    Join Date
    Feb 2006
    Location
    Derbyshire
    Posts
    1,374
    Thank Post
    175
    Thanked 207 Times in 168 Posts
    Rep Power
    53

    Default

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

     

Similar Threads

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

Posting Permissions

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