Real time logging to SQL

Is there a product out there for doing real time IIS logs to SQL?

I know that you can do it in an event using the Microsoft Log Analyzer,
but I'm looking for something that will do it in real time.

Thanks!

--Dave

Tom
Thu Apr 15 08:42:24 CDT 2004

"Dave Navarro" <dave@dave.dave> wrote in message
news:MPG.1ae8585ca24cff499897f1@news-40.giganews.com...
> Is there a product out there for doing real time IIS logs to SQL?
>
> I know that you can do it in an event using the Microsoft Log Analyzer,
> but I'm looking for something that will do it in real time.

That's built-in. Just pick ODBC logging on the "Web Site" tab for the Web
Site Properties.

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserver2003/community/centers/iis/

Keith
Thu Apr 15 08:51:08 CDT 2004

The easiest way, in my opinion, is just to build it into the application via
ISAPI or even as an ASP function.

"Dave Navarro" <dave@dave.dave> wrote in message
news:MPG.1ae8585ca24cff499897f1@news-40.giganews.com...
> Is there a product out there for doing real time IIS logs to SQL?
>
> I know that you can do it in an event using the Microsoft Log Analyzer,
> but I'm looking for something that will do it in real time.
>
> Thanks!
>
> --Dave

Dave
Thu Apr 15 13:38:12 CDT 2004

In article <c5m2vo$8s92@kcweb01.netnews.att.com>, "Tom Kaminski [MVP]"
<tomk (A@T) mvps (D.O.T) org> says...
> "Dave Navarro" <dave@dave.dave> wrote in message
> news:MPG.1ae8585ca24cff499897f1@news-40.giganews.com...
> > Is there a product out there for doing real time IIS logs to SQL?
> >
> > I know that you can do it in an event using the Microsoft Log Analyzer,
> > but I'm looking for something that will do it in real time.
>
> That's built-in. Just pick ODBC logging on the "Web Site" tab for the Web
> Site Properties.

Except that it's limited as to what it logs, correct? I thought I read
something about not being able to log referrers and other stuff using
ODBC logging.

--Dave

Tom
Thu Apr 15 15:28:39 CDT 2004

"Dave Navarro" <dave@dave.dave> wrote in message
news:MPG.1ae8a0ba2b84273d9897f2@news-40.giganews.com...
> In article <c5m2vo$8s92@kcweb01.netnews.att.com>, "Tom Kaminski [MVP]"
> <tomk (A@T) mvps (D.O.T) org> says...
> > "Dave Navarro" <dave@dave.dave> wrote in message
> > news:MPG.1ae8585ca24cff499897f1@news-40.giganews.com...
> > > Is there a product out there for doing real time IIS logs to SQL?
> > >
> > > I know that you can do it in an event using the Microsoft Log
Analyzer,
> > > but I'm looking for something that will do it in real time.
> >
> > That's built-in. Just pick ODBC logging on the "Web Site" tab for the
Web
> > Site Properties.
>
> Except that it's limited as to what it logs, correct? I thought I read
> something about not being able to log referrers and other stuff using
> ODBC logging.

Correct - it does not give you the same amount of detail/options as the W3C
format.

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserver2003/community/centers/iis/