Selavie, What I actually need to do is tell LogParser about extended fields beyond those covered in NCSA Combined. I have a field for the duration of the request and a few others.

DEinspanjer, Logparser 2.2 supports the NCSA input format. It can parse log files in the NCSA Common, Combined, and Extended Log file formats. The Log Parser input format generates input records for the following fields: - LogFilename - LogRow - RemoteHostName - RemoteLogName - UserName - Date Time ...

Our company makes use of a couple of different web servers including a SOAP server, Apache, and Tomcat. In most cases, we log in NCSA Combined format and we usually extend it with other useful information such as the duration of the request, etc. I could certainly be mistaken, but I was under the impression...

Gabriele: It's an honor to help. Thanks for your hard work on this tool. I'm psyched about 2.2 and the new book! Kevin

Congratulations, you have found a new bug in the NCSA input format.... ...the problem is with the " characters embedded in the field. The bug is fixed now. We're planning on doing almost-monthly releases of updates; this fix will be in version 2.2.10. Thanks for reporting it!!!!! P.S.: if you can't wait...

I get the error message, "Log row terminates unexpectedly" ... "row number 64544", but I manually inspect that row and don't see anything unusual. Here's the line: 64.107.192.18 - - [14/Feb/2005:05:05:06 -0500] "GET /main.css HTTP/1.0" 304 - " http://www.example.com/product.phtml?p=965&OVRAW=\"search...

Replied in the 'General' forum. Please refrain from posting to multiple forums - we follow _all_ of them :-) ------------------------------ This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft...

Hi, I am new to LogParser... can someone provide me with some input as to what the type of input file I would need to use in order to do the following: I would like to parse out each GET and POST method in the access.log file. The log has entries similar to the ones below… notice there are two unique...

Thanks Gabriele. I was trying to include the date in earlier permutations but couldn't get those to work. The source of the problems I was encountering earlier is the format mask for minutes and months. Although the help file does show the timestamp format for months as being M,MM,MMM, or MMMM I just...

That's because you're asking it the entries logged after 9:30 of January 1 year 0... You can either go for: WHERE TO_TIME(DateTime) > TO_TIMESTAMP('09:30:00', 'hh:mm:ss') OR WHERE DateTime > TO_TIMESTAMP('2004-06-29 09:30:00', 'yyyy-MM-dd hh:mm:ss') ------------------------------ This posting is...