IIS Logs Max Per Hour

From: Simon Jelinek (simonjelinek_at_hotmail.com)
Date: 08/26/04 

Date: Thu, 26 Aug 2004 08:13:51 -0700

Hi

Being very new to SQL so iam hoping that this will be
easy.

Using a dts package to transfer IIS logs into a SQL
database i would now like to knpw of there is any
resource that gives some idea on the best stats to take
from IIS Logs.

i have create a query that is a count of [c-ip] i would
like to find out what is the max hourly count of [c-ip]
grouped by day the data is very mixed as when log a is
recorded could be 3 a second or not one for a few
seconds ? but generally data is at per second level?

Relevant Pages

  • Re: Automated analysis of logs?
    ... > into (especially IIS logs) and get not only statistics, ... save output in some various format like XML, IIS log or directly to the SQL ... Is SPAM over-loading your e-mail server, ... SurfControl E-Mail Filter is flexible, ...
    (Security-Basics)
  • Re: Selecting rows from a distinct selection of one field
    ... > You can get the first row for each IP with: ... >> I'm not that new to SQL, but still I can't figure this out. ... >> I'm writing some routines to check through IIS logs. ... >> Adam Smith ...
    (microsoft.public.sqlserver.programming)
  • Re: Selecting rows from a distinct selection of one field
    ... Please post DDL + sample data + desired result. ... > I'm not that new to SQL, but still I can't figure this out. ... > I'm writing some routines to check through IIS logs. ...
    (microsoft.public.sqlserver.programming)
  • Re: IIS Logs Max Per Hour
    ... > Using a dts package to transfer IIS logs into a SQL ...
    (microsoft.public.sqlserver.mseq)