«

http://www.aspfaq.com/2473

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"Garyrek" <> wrote in message
news:...
> how do I analyze web server log files, any third party tool?
>
> Thanks
>
> "Jeff Cochran" <> wrote in message
> news:...
>> On Thu, 1 Apr 2004 16:06:47 -0800, "Garyrek" <>
>> wrote:
>>
>> >Hi Manohar / Aaron
>> >I should have mentioned this earlier, this way the table gets too big
>> >henceforth database, is there any other way like storing in a file or
> using
>> >pagecounter component?
>>
>>
>> Why not analyze the web server log files for thyis information
>> instead?
>>
>> Jeff
>>
>> >"Manohar Kamath [MVP]" <> wrote in message
>> >news:u4Ixs$...
>> >> Store individual hits, with timestamp, that way you are more data that
> you
>> >> can report on -- weekly, hourly, or even minutely
>> >>
>> >> Link Hit Time
>> >> ---------- -----
>> >> 1 1 4/1/2004 1:12:23 AM
>> >> 1 2 4/1/2004 1:12:24 AM
>> >> 2 3 4/1/2004 1:12:25 AM
>> >>
>> >> Collecting more data can only help you.
>> >>
>> >> --
>> >> Manohar Kamath
>> >> Editor, .netWire
>> >> www.dotnetwire.com
>> >>
>> >>
>> >> "Garyrek" <> wrote in message
>> >> news:%...
>> >> > this? I store hits counter, firsthit and lasthit in the database
> having
>> >> this
>> >> > I could only show all the hits since creation to last hit but NOT
>> >> > for
>> >last
>> >> > one week or couple of days....
>> >> > "Manohar Kamath [MVP]" <> wrote in
> message
>> >> > news:...
>> >> > > Are you not storing this in a database? That would be the ideal
>> >> > solution --
>> >> > > just implement a simple function that logs hits to a page, along
> with
>> >a
>> >> > time
>> >> > > stamp. It is also very flexible to report on whatever other
> parameters
>> >> you
>> >> > > want to report on.
>> >> > >
>> >> > > --
>> >> > > Manohar Kamath
>> >> > > Editor, .netWire
>> >> > > www.dotnetwire.com
>> >> > >
>> >> > >
>> >> > > "Garyrek" <> wrote in message
>> >> > > news:...
>> >> > > Hi
>> >> > >
>> >> > > I have a requirement where I need to make a report for each auto
>> >dealer
>> >> > how
>> >> > > many hits they got on specified date range, so for each car detail
>> >page
>> >> I
>> >> > > increment the counter and total it while doing that I store the
> last
>> >hit
>> >> > > date, this gives the total hits for the dealer BUT does not
> facilitate
>> >> > date
>> >> > > range
>> >> > >
>> >> > > How do I give the user a date range so that he can check how many
> hits
>> >> the
>> >> > > dealer got lets say for last week OR last couple of days?
>> >> > >
>> >> > > Thanks much!
>> >> > >
>> >> > > Gary
>> >> > >
>> >> > >
>> >> >
>> >> >
>> >>
>> >>
>> >
>>
>
>