Dear Experts,

I need urgent help in Squid Server Reporting for my office. i am using squid 3.1 i need some help for squid reporting purpose. My Objective is to generate reports on these following points:

1. Person wise internet usage (personal & official & most visited URL's)

2. Date wise/day wise report for specific users.
3. Access log user wise
4. deny log user wise


I need any Technique to generate these report,,


Thanks & Regards

This is a voluntary site, and as such it is unfair to demand "urgent" attention. There are a myriad of Squid logging services out there that you can easily find from google, and you don't appear to have done any research at all in this area.

sorry for the word of "urgent" actually i have lots of pressure from my office that's why. i am new on squid and i also research on Google but i didn't find good solution. so kindly i need some commands or Technique for those points.



Thanks

Google "squid sarg"

Maybe you do, but that doesn't mean that any technique that generates a report will be a good one for you to adopt.

So, whatever the details are, you need some info on your users. The first consideration is whether this is, for example, legal and ethical, as, in some jurisdictions, spying on users is not regarded as a good thing. This may depend on what the users have signed up to (for example, it may be a condition of internet use that the users sign something that says they can only use it if certain 'spying-like' measures are allowed, and these may or may not be restricted by that covenant). You also don't say anything about what legal code applies, so that's your problem, not ours. Well, it always was your problem, but now you don't even get to say 'a man on the internet told me it was all right', because 'the man on the internet' didn't have the information to make a judgement.

Next up is what you know about the user making requests: it is possible depending on your 'network architecture' (sorry about being pretentious, but it is quicker, honest) that squid doesn't know who is doing what, but which IP is doing what, so you have to answer the question 'Do I know which IP relates to which person? and, potentially 'Is that identification reliable enough for my purposes?'. So, that brings in your purposes: if, for example, there are certain circumstances in which your organisation might sack someone for what you perceive them as having accessed, then you had better get this right.

If you spelunk the squid log files, you should have some idea of what I am talking about; something like sarg or squidguard is a nice adjunct to squid, but they don't create information, only analyse the information that is there. So, if the information that you want isn't there, you can analyse it however you want and you'll still not have it.

1 members found this post helpful.