November 15, 2004 at 2:07 pm
Can anyone point me to any articles or share any information on how they report from IIS logs on usage? I am assuming the logs will be in DB table after using something like DTS to import them.
November 15, 2004 at 2:43 pm
See, if this helps:
http://www.iisfaq.com/admin/Portal/LinkClick.aspx?mid=2176&Link=3117
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 16, 2004 at 3:51 am
This is my firts post on the forum, i hope this information is usefull
You can make IIS log to an ODBC database directly on Windows Server OS,
there's a template for the datbase structure in %SystemRoot%\system32\inetsrv\logtemp.sql
-- note this is not recommended, it creates a lot of overhead compared to logging to file and if the connection to your database fails nothing will be logged except an error in eventlog---
On development servers however, this opens up a number of interesting possibilities in monitoring HTTP, SMTP, NNTP and FTP activity
This works for the W3SVC, SMTPSVC, FTPSVC and NNTPSVC services,
these can all log to the same table (i'd not recoomend this) or your can create separate tables
You'll have to create a DSN for the database and set the logging option to ODBC in IIS manager and enter the login details.
Joris van Lier
November 16, 2004 at 12:21 pm
Thanks for the information. I think the link gives some basic information I was looking for to import the logs into SQL and make soem sense of them.
In repsonse to the ODBC logging - I'm warry of trying to log directly to SQL since it comes with so many warnings. I think I'll try the import first to see if I can get what I need. But thanks to all for sending information my way.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply