Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlink View 8.5 reading for squid

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

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

Peter

Not applicable
Author

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.

Not applicable
Author

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.

Not applicable
Author

Realy no one have script to import Squid logs? Sad

Not applicable
Author

why you don't use "sarg"?

Not applicable
Author

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

Not applicable
Author

Hi Jonathan,

this script works OK in my squid / QV environment:



LOAD

@1,

@2,

@3

,

@4

,

@5

,

@6

,

@7

,

@8

,

@9

,

@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