Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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