How to use mssql2k to query IIS logs

This article mainly explains "how to use mssql2k to query IIS log", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to use mssql2k to query IIS logs.

The IIS log format is txt by default, which looks awkward.

Here are some ways to get rid of damn txt.

1 create an iis, add an InetAdmin user, specify the user as the owner of the iis database, and set the relevant permissions.

2 execute the logtemp.sql query file and establish the table. Its contents are as follows:

Create table inetlog (

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))

3 according to the default value of IIS5's ODBC log, enter the ODBC data source manager to establish a "system DSN" named "HTTPLOG" to connect with the iis database, and use the InetAdmin account when establishing.

4 change "activity log format (V)" to "ODBC Logging".

Then you can query it yourself as needed, such as which IP visited what at what time. Most importantly, you can clearly know which IP is sweeping you non-stop.

At this point, I believe you have a deeper understanding of "how to use mssql2k to query IIS logs". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!