Thank you so much, this is exactly what I was looking for!

Since you want DISTINCT IP's, and each IP might appear multiple times in the log each with a different time, which time do you want to sort on? The last time found for each IP? If it's the last time you want, you can go with this: SELECT c-ip, MAX(DateTime) USING TO_TIMESTAMP(date, time) AS DateTime...

Hello, I would like to parse the last visiting IPs from the log files and am having trouble building the query string. This obvisously can't work: SELECT DISTINCT c-ip FROM ex040528.log ORDER BY TO_TIMESTAMP(date, time), logrow DESC As I'm new to SQL-like queries I would really appreciate any help on...

Thanks for the response. My definition of concurrent users is the number of different IP addresses connected to my website at a single point in time - connected status to port 80.

What are you looking for exactly? The AVG number of requests occurring in each second can be calculated with a 2-step query as follows: 1 - Calculate the number of requests in each second and save to a temporary CSV file: SELECT TO_TIMESTAMP(date, time) AS MyTimestamp, COUNT(*) AS HitsPerSec INTO Temp...

Hello...I am wondering if anyone has a command line logparser query that will calculate the AVG number of concurrent users for a given set of IIS logs. I am experiencing problems with the Select statement to capture, count and avg the data. I was hoping someone had one handy they could post. Thanks,

Well, first off, these files are not "real" IISW3C files. Blank lines can't appear in IISW3C files, and that's why LP is barfing on the blank lines. Do the column headings change in a file? If not, you can try with the "W3C" input format. I've tried with Log Parser 2.1 on a W3C file with blank lines...

Hi I have a number of IISW3C (Extended Format) log files that I am attempting to parse using LogParser 2.0. I'm running this on a Windows 2000 Server machine. On each log import, I need to update a database with the number of successful and failed rows. At certain intervals in the IISW3C log file, there...