Very cool!
I looked everywhere in IIS, and it turns out my win2kpro box doesn't have the odbc
option you referenced. Now that you showed me what to look for, I checked my server
and sure enough, the option is there.
I've had to do custom logging once or twice before, and have never been happy with the
double-effort on the server. This should be fun to play with. Opens up other doors
besides custom reporting. I can build a front end that does anything CF can do.
Interesting indeed. I don't use SQL Server (mySQL for Windows) but I should be able to
make a filespec that functions just fine in mySQL.
Thanks, Costas!
--Matt--
---------- Original Message ----------------------------------
from: Costas Piliotis <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Wed, 25 Jul 2001 13:21:32 -0700
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
