topic Qlink View 8.5 reading for squid in QlikView

Qlink View 8.5 reading for squid

Tue, 03 Nov 2009 23:37:00 GMT

Good afternoon, I wonder if you have any way to make reading the log of squid through the QlikView to create a query.

prieper — Wed, 04 Nov 2009 02:12:26 GMT

Why not?
Can you post an example of the data? Tried to google, but found only general info on sqid.

Peter

Wed, 04 Nov 2009 19:40:52 GMT

Hello,

1256549611.363 8 10.100.50.191 TCP_DENIED/403 1520 GET http://62.146.66.184/update/idx/wks_avira-win32-en-pecl.info.gz rh10lnd NONE/- text/html

this is only one line of my squid for example . I need search this information in linux server.

Wed, 05 May 2010 08:27:04 GMT

Hello!

I add an example of Squid log file.

Maybe someone have a QV report wich may read Squid server log?

I will be waiting for Your help.

Thu, 06 May 2010 09:19:59 GMT

Realy no one have script to import Squid logs?

Thu, 06 May 2010 10:36:34 GMT

why you don't use "sarg"?

Fri, 07 May 2010 12:55:27 GMT

Hello Friend,

I use the sarg, the problem is , how to get the information from the sarg??, i need this information to created the internet auditing. Tk's

Mon, 17 Jan 2011 20:51:41 GMT

Hi Jonathan,

this script works OK in my squid / QV environment:

LOAD

@1,

@2,

@10

FROM

N:\access.log

(

txt, codepage is 1252, no labels, delimiter is spaces, no quotes);

The key is "delimiter is spaces" (in plural)

Hope this helps

Regards