topic IIS Weblog Analysis in QlikView

IIS Weblog Analysis

Mon, 11 May 2009 14:01:46 GMT

Hi,

I'm currently trying to analyse an iis weblog file.
Seems to be quite a lot of filtering stuff. Has anyone of you already experience with this topic?
Any hints?
Thanks

Regards

Aloah

IIS Weblog Analysis

rwunderlich — Tue, 12 May 2009 02:42:20 GMT

I have done this. It's possible to read them with QV scrip, but it easier if you preprocess the logs with MS Logparser. Then you don't have to worry about field positions or multiple headings.

-Rob

IIS Weblog Analysis

Tue, 12 May 2009 04:25:47 GMT

Here's a link to some info on the MS Logparser about which Rob wrote:

http://qlikviewnotes.blogspot.com/2008/12/extracting-data-using-microsoft.html

Re: IIS Weblog Analysis

felixobes — Fri, 17 May 2019 17:45:01 GMT

Within the load script, just use the option "comment is #" and it will not bring you those lines.

Then just use subfield() to separate the data components into useful bits.