-
iPraxa Inc
Distance: 9.9 Mi663 Trousdale St
91377 Oak Park -
Payless Janitorial Services
Distance: 12.7 MiPO Box 50711
93030 Oxnard -
Opf Inc
Distance: 14.3 Mi2200 Teal Club Rd
93030-8640 Oxnard -
Web Success Team LLC
Distance: 17.7 Mi23901 Calabasas Rd Ste 1025
91302-3389 Calabasas -
Channel Islands Design
Distance: 18.3 Mi2840 Harbor Boulevard Suite C4
93035 Oxnard
Description
Of course, I could compose a awk script, or a series of regular expressions, to locate information contained in IIS access logs. However, there's a handy tool that makes querying a batch of logs simple. It's something Microsoft released several years ago called Log Parser . The download is an MSI package that installs a command line executable and supporting files. The program uses an SQL-like syntax for locating data contained in log files of various formats. Even better, there's an application written by James Skemp called Log Parser Plus that provides a clean GUI for constructing the query statement. For example, say I've copied several log files from the web server to a temp directory, and I want to find all the accesses to /login from the 10.0.0.0/24 network. Plugging the criteria into the user interface creates a query like so: SELECT date, time, c-ip, cs-method, cs(User-Agent) FROM 'D:\temp\logs\ex100926.log' WHERE c-ip LIKE '10.0.0.%' AND cs-uri-stem = '/login' Clicking the perform query button shows the results in a datagrid. In this example, I've selected just one log file, but I could have run the query over all the files in the directory.