Yup. With sql server in query analyzer, run the following script in the db
you want logging. After that, go to your iis box(s) and create an odbc
connection to that database if it doesn't exist. Finally, on the logging
section of the iis properties, where it says log file format, it's normally
set up to w3c log file format. One of the options is ODBC logging. Switch
to that.
CREATE TABLE [dbo].[inetlog] (
[ClientHost] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[username] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[LogTime] [datetime] NULL ,
[service] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[machine] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[serverip] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[processingtime] [int] NULL ,
[bytesrecvd] [int] NULL ,
[bytessent] [int] NULL ,
[servicestatus] [int] NULL ,
[win32status] [int] NULL ,
[operation] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[target] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[parameters] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL
) ON [PRIMARY]
GO
-----Original Message-----
From: Matt Robertson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 25, 2001 12:18 PM
To: CF-Talk
Subject: RE: Webstat
> Personally, I use ODBC logging through IIS and report off of
> that. I just make sure I delete all the css, js, and vbs
> entries beforehand...
Are you saying there's a way for IIS to keep logs other than dumping data
into a text file? If so I'd really appreciate a pointer or two.
Cheers,
---------------------------------------
Matt Robertson [EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
