Welcome to HostingForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Real time logging to SQL

 
   Web Hosting Problem Solving Community! (Home) -> IIS RSS
Next:  IIS Out-Of-Process Pooled Applications  
Author Message
dave10

External


Since: Apr 15, 2004
Posts: 2



(Msg. 1) Posted: Thu Apr 15, 2004 12:29 pm
Post subject: Real time logging to SQL
Archived from groups: microsoft>public>inetserver>iis (more info?)

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

 >> Stay informed about: Real time logging to SQL 
Back to top
Login to vote
user641

External


Since: Aug 22, 2003
Posts: 1637



(Msg. 2) Posted: Thu Apr 15, 2004 12:42 pm
Post subject: Re: Real time logging to SQL [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"Dave Navarro" <dave.DeleteThis@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
<a style='text-decoration: underline;' href="http://www.iistoolshed.com/" target="_blank">http://www.iistoolshed.com/</a> - tools, scripts, and utilities for running IIS
<a style='text-decoration: underline;' href="http://mvp.support.microsoft.com/" target="_blank">http://mvp.support.microsoft.com/</a>
<a style='text-decoration: underline;' href="http://www.microsoft.com/windowsserver2003/community/centers/iis/" target="_blank">http://www.microsoft.com/windowsserver2003/community/centers/iis/</a><!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Real time logging to SQL 
Back to top
Login to vote
user164

External


Since: Aug 01, 2003
Posts: 172



(Msg. 3) Posted: Thu Apr 15, 2004 12:51 pm
Post subject: Re: Real time logging to SQL [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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 RemoveThis @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<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Real time logging to SQL 
Back to top
Login to vote
dave10

External


Since: Apr 15, 2004
Posts: 2



(Msg. 4) Posted: Thu Apr 15, 2004 5:38 pm
Post subject: Re: Real time logging to SQL [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

In article <c5m2vo$8s92@kcweb01.netnews.att.com>, "Tom Kaminski [MVP]"
<tomk (A@T) mvps (D.O.T) org> says...
 > "Dave Navarro" <dave.DeleteThis@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<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Real time logging to SQL 
Back to top
Login to vote
user641

External


Since: Aug 22, 2003
Posts: 1637



(Msg. 5) Posted: Thu Apr 15, 2004 7:28 pm
Post subject: Re: Real time logging to SQL [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"Dave Navarro" <dave.DeleteThis@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.DeleteThis@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
<a style='text-decoration: underline;' href="http://www.iistoolshed.com/" target="_blank">http://www.iistoolshed.com/</a> - tools, scripts, and utilities for running IIS
<a style='text-decoration: underline;' href="http://mvp.support.microsoft.com/" target="_blank">http://mvp.support.microsoft.com/</a>
<a style='text-decoration: underline;' href="http://www.microsoft.com/windowsserver2003/community/centers/iis/" target="_blank">http://www.microsoft.com/windowsserver2003/community/centers/iis/</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Real time logging to SQL 
Back to top
Login to vote
Display posts from previous:   
   Web Hosting Problem Solving Community! (Home) -> IIS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]