Reading Current IIS Log

rayapur · July 16th, 2003, 12:14 PM

Hi!
Is there a way to read current IIS Log? If I do it by openeing a stream I get an error that the file is already being used by another process.

Please advice.
Thanks in advance.
-uday

Imar · July 16th, 2003, 12:17 PM

Hi there,

One thing you could try is to create a copy of the file and read that. That worked for me with some other application that locked the log files.

Alternatively, you could log to a database, like SQL Server instead of to a file. That makes it a lot easier to query real-time data. If you need some more info about that, let me know.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

rayapur · July 16th, 2003, 12:30 PM

Hi! Thanks for the reply. Copying the file would not work for me as the file size could be very large. Please give me more info about logging to database.
Thanks.
-Uday.

rayapur · July 16th, 2003, 12:52 PM

Hi!
Meanwhile I happened to search for the database logging. I got the info on it by doing iis search. If there are known issues with it and solutions please advice me.
Thanks.
-Uday.

Imar · July 16th, 2003, 12:53 PM

Hi there,

Here's what you need to do:

1. Create a database table with the following code:

Code:

CREATE TABLE InternetLog
(
    ID int IDENTITY (1, 1) NOT NULL,
    ClientHost varchar(255), 
    UserName varchar(255),
    LogTime datetime, 
    Service varchar( 255), 
    Machine varchar( 255),
    ServerIP varchar( 50), 
    ProcessingTime int, 
    BytesRecvd int,
    BytesSent int, 
    ServiceStatus int, 
    Win32Status int,
    Operation varchar( 255), 
    Target varchar(255), 
    Parameters varchar(255) 
)

2. Create a DSN to your database using the ODBC Control Panel.

3. Open IIS, and then your website. On the Properties dialog for your site, choose ODBC Logging from the drop-down. On the ODBC Logging Properties dialog fill in the details for your DSN, Table name and the username / password combination that you need to log in to your database.

If you use SQL Server, I think you'll need to use SQL Security instead of Integrated Security, but I am not 100% sure about that.

HtH

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.