Hi, Back again Ok I have gotten logparser 2.1 installed and am still having issues selecting by a date/time. I've been trying the following: D:\>logparser -i:ncsa "SELECT * FROM c:\citys_access_052104.txt WHERE DateTime > TO_TIMESTAMP('09:30:00', hh:mm:ss')" This is returning all rows, not just...

The only way to get 2.1 is to download the whole IIS6 Resource Kit. However, once you have downloaded the Resource Kit installer, you can choose to install Log Parser only. ------------------------------ This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script...

Yes I'm using 2.0. Is 2.1 available without having to download the IIS 6.0 resource kit? Or a preview of 2.2? -Brett

You're using 2.0, correct? 2.0 did not support anything other than constants on the right-side of operators. ------------------------------ 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, Now that I'm able to successfully parse my log file, I'm trying to pull records for a specific time interval. Something like the following. Logparser -i:NCSA "SELECT * FROM test.log WHERE DateTime > TO_TIMESTAMP('05/21/04','mm/dd/yy')" ERROR: Syntax Error: <content>: no valid content (missing...

Hi, Now that I'm able to successfully parse my log file, I'm trying to pull records for a specific time interval. Something like the following. Logparser -i:NCSA "SELECT * FROM test.log WHERE DateTime > TO_TIMESTAMP('05/21/04','mm/dd/yy')" ERROR: Syntax Error: <content>: no valid content (missing...