Re: I don't uderstand ISA Logs

From: Tony Su (anonymous_at_discussions.microsoft.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 12:11:57 -0800

IMO you can filter without too much of an issue.

If you're filtering only your own web content, you can
define specific strings and use those to indicate desired
entries.

If your're filtering Internet content, then you <may> be
able to search on specific strings the same way as for
your own content, but I doubt it. My guess is that you may
want to exclude specific strings.

Depending on your skills as a programmer, you should be
able to build a flexible design where you can modify your
list of strings to fine tune how it works.

Tony Su

>-----Original Message-----
>It is not possible, clicks and pictures inside a web page
are translated
>into HTTP requests, which look all the same to the ISA
server. The only
>thing you can do is guess what site is visited.
>
>Usually text/* files are clicked on (some exceptions
though).
>Can use time to filter this out. When timings are very
close, this MIGHT
>indicate a single page.
>
>Complexity increases when:
>user used multiple browser windows (visits are
interleaved somewhat)
>pages require resources from other web sites (such as
counters and ads,
>which are the most common).
>
>You can do much with SQL to filter something out, but you
probably need much
>more complex logic do so.
>
>Before starting this job I would rather investigate
whether you really need
>to know what links the user clicked. I cannot imagine a
situation where you
>want to know this...
>
>- Joris
>
>"MIchele Massari" <mmassari@omniway.sm> wrote in message
>news:112cb01c41672$d199b1d0$a001280a@phx.gbl...
>> Hi,
>> Overall I'm sorry for my bad english...
>>
>> I'm developing an application that analyze ISA server
>> logs.
>>
>> I don't understand how I can group the records in SQL to
>> diplay only actual user 'clicks', not just 'hits' in the
>> log files.
>> I try to better explain myself:
>> 1. With the browser i open the url www.isaserver.org,
>> then I click on Books section and finally i close the
>> browser.
>> 2. ISA write a several records... (images, js, css, html
>> in the frames...)
>> 3. With a SQL Query I want obtain only 2 records as:
>> User1 2/2/04 15.35 www.isaserver.org 150Kb
>> User1 2/2/04 15.39 www.isaserver.org/pages/books.asp
190Kb
>>
>> I hope you have understand my problem...
>>
>> Please Help me...
>>
>> Michele from Italy
>
>
>.
>

Relevant Pages
Loading