Usage of IIS Log files

Usage of IIS Log files

am 22.12.2007 07:46:23 von hassan

I had seen some web sites in the past on some sample scripts of the types of
queries and valuable data you can get from IIS logs.. I have all the info
collected. but i wanted to see some sample scripts on what I can do with the
data.

Thanks

Re: Usage of IIS Log files

am 22.12.2007 09:28:36 von David Wang

On Dec 21, 10:46=A0pm, "Hassan" wrote:
> I had seen some web sites in the past on some sample scripts of the types =
of
> queries and valuable data you can get from IIS logs.. I have all the info
> collected. but i wanted to see some sample scripts on what I can do with t=
he
> data.
>
> Thanks


Search for "LogParser".

Imagine importing the log file into a SQL table and then able to make
SQL queries against that table, plus generate charts/graphs of the
output tabular data, plus script process the result table in arbitrary
fashion. That's what LogParser allows you to do.

It comes with all the sample scripts and queries that you need. You
can always search for more.


//David
http://w3-4u.blogspot.com
http://blogs.msdn.com/David.Wang
//

Re: Usage of IIS Log files

am 22.12.2007 18:41:28 von hassan

David,

I already have log parser and am importing all the data into a SQL table.
The problem is I want to show some cool stuff to my boss about what the data
I have captured can do. Im not looking at how to use the tool, but more
towards the queries that can tell me things like who logged on, how many
hits, how many users,etc. ? I dont know what value IIS logs can provide i
guess is what it is.


"David Wang" wrote in message
news:9cbfa6e2-5154-4eb5-9da0-96848892f5a7@e23g2000prf.google groups.com...
On Dec 21, 10:46 pm, "Hassan" wrote:
> I had seen some web sites in the past on some sample scripts of the types
> of
> queries and valuable data you can get from IIS logs.. I have all the info
> collected. but i wanted to see some sample scripts on what I can do with
> the
> data.
>
> Thanks


Search for "LogParser".

Imagine importing the log file into a SQL table and then able to make
SQL queries against that table, plus generate charts/graphs of the
output tabular data, plus script process the result table in arbitrary
fashion. That's what LogParser allows you to do.

It comes with all the sample scripts and queries that you need. You
can always search for more.


//David
http://w3-4u.blogspot.com
http://blogs.msdn.com/David.Wang
//

Re: Usage of IIS Log files

am 22.12.2007 19:11:25 von avidfan

you are probably better off with an off the shelf tool unless you want to be
writing your own sql. check out Analog
http://www.analog.cx/
and the pretty reports it can generate:
http://www.chiark.greenend.org.uk/~sret1/stats/
and best of all, its free.


"Hassan" wrote in message
news:OE8siHMRIHA.4400@TK2MSFTNGP06.phx.gbl...
> David,
>
> I already have log parser and am importing all the data into a SQL table.
> The problem is I want to show some cool stuff to my boss about what the
> data I have captured can do. Im not looking at how to use the tool, but
> more towards the queries that can tell me things like who logged on, how
> many hits, how many users,etc. ? I dont know what value IIS logs can
> provide i guess is what it is.
>
>
> "David Wang" wrote in message
> news:9cbfa6e2-5154-4eb5-9da0-96848892f5a7@e23g2000prf.google groups.com...
> On Dec 21, 10:46 pm, "Hassan" wrote:
>> I had seen some web sites in the past on some sample scripts of the types
>> of
>> queries and valuable data you can get from IIS logs.. I have all the info
>> collected. but i wanted to see some sample scripts on what I can do with
>> the
>> data.
>>
>> Thanks
>
>
> Search for "LogParser".
>
> Imagine importing the log file into a SQL table and then able to make
> SQL queries against that table, plus generate charts/graphs of the
> output tabular data, plus script process the result table in arbitrary
> fashion. That's what LogParser allows you to do.
>
> It comes with all the sample scripts and queries that you need. You
> can always search for more.
>
>
> //David
> http://w3-4u.blogspot.com
> http://blogs.msdn.com/David.Wang
> //