13 Replies Latest reply: May 2, 2014 5:57 AM by Carlo Scherma RSS

    Log Apache analysis with QlikView

      I have to analyze a log file of a portal and would like to use as a tool ClikView. The file has the extension. Log

      The format of the log is to Apache and I should extract the information contained in it.

      A sample of the file is as follows:


      61432c789518088e2c708f122d260f9178b87059 - - [04/Mar/2014:06:25:04 +0100] "GET /page/Stig_Boqvist HTTP/1.1" 200 4561 "-" "Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)"

       

      445fd14a49ff5469ed4ee51f5a2b6a7f5efea22b - - [04/Mar/2014:06:25:05 +0100] "GET /data/Waldkirchen.jrdf HTTP/1.1" 200 8612 "-" "Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)"

       

      949d8c5d984bdbb6ca32364d80a4e2469e8a8e25 - - [04/Mar/2014:06:25:06 +0100] "GET /page/Homer_Dickenson HTTP/1.1" 200 4533 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"

      ....

       

       

      The information I want to know are:

      - Content displayed more

      - User agent used to make requests etc.

       

      Basically I should be doing the business intelligence analysis on this log file. Can you help me or give me some suggestions?You can read the contents of the file and parse it directly? Taking for example the dashboard?

       

      Thank you in advance for your reply

       

      greetings

      Carlo