Re: Reading IIS Logs into SQL Server
From: David Wang [Msft] (someone_at_online.microsoft.com)
Date: 06/12/04
- Next message: M.Siler: "Publish via FP 2003 to IIS6 do I need FPSE installed?"
- Previous message: David Wang [Msft]: "Re: Files not downloading properly"
- In reply to: Frank Rizzo: "Reading IIS Logs into SQL Server"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 11 Jun 2004 18:27:09 -0700
Log Parser, a freely available tool from Microsoft, sounds the ideal
solution to this. It allows one to make SQL queries against regularly
delimited log files, including IIS and many others, like event log, and
optionally inject the results into SQL or display on the console. It has
both commandline and COM interface. I've only scripted it from the
commandline as administrator, but assuming your ASP page has privileges to
access the log file in question, I assume it should work.
There are many users of Log Parser out there (I think there's a MS newsgroup
as well), so you should search a little for additional support.
-- //David IIS This posting is provided "AS IS" with no warranties, and confers no rights. // "Frank Rizzo" <Frank_X_Rizzo@hotmail.com> wrote in message news:e5a750db.0406081854.62d8cd71@posting.google.com... I have searched around for an answer to my question before posting here. I want to scan IIS ( IIS5 and IIS6 ) log files peridocally, load them into a SQL Server table based on some filtering criteria such as what pages a user came in (cs-method) on, what session they had (cs(User-Agent)), and where they came from (cs(Referer)). I then will take that data and create simple usage reports. I have only found the IISLog built-in COM object. The logs files size is between 10 and 40MB per day. Will this cause me any problems? Is this the best way to read and process IIS logs? Does anyone whos sells web reporting tools also provide a COM inteface so I could use the functionality in ASP? Thanks --Frankie
- Next message: M.Siler: "Publish via FP 2003 to IIS6 do I need FPSE installed?"
- Previous message: David Wang [Msft]: "Re: Files not downloading properly"
- In reply to: Frank Rizzo: "Reading IIS Logs into SQL Server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
