When I try the input as IISW3C I get an errror that says "Unknown field s-action found in #Fields directive" Thanks, JW

Did you try reading the BlueCoat logs in IISW3C format? They look pretty similar.

Hello, Could anyone help me convert this BlueCoat Reporter log file format... #Fields: date time time-taken c-ip sc-status s-action sc-bytes cs-bytes cs-method cs-uri-scheme cs-host cs-uri-port cs-uri-path cs-uri-query cs-username cs-auth-group s-hierarchy s-supplier-name rs(Content-Type) cs(User-Agent...

[QUOTE User="LogParser User : aarons44"]Quote: Forgive me if this is a silly question, might mightn't the problem be with your call to objRecord.GetValue? You are passing it Text, but not in quotes which I think would mean that VB would be looking...[/QUOTE] Yes, that is the answer! Thanks!

Forgive me if this is a silly question, might mightn't the problem be with your call to objRecord.GetValue? You are passing it Text, but not in quotes which I think would mean that VB would be looking for some object named Text. Did you try objRecord.GetValue("Text")?

I have the following code in a script file: Set oShell = WScript.CreateObject("WScript.Shell") Set objLogParser = CreateObject("MSUtil.LogQuery") Set objInputFormat = _ CreateObject("MSUtil.LogQuery.TextlineInputFormat") strQuery = "SELECT Text FROM " & _ "'testdata.txt'" Set objRecordSet = objLogParser...

Oh, it works perfect. thanks a lot.

Did you specify the input format? -i:NCSA

Performance will most likely degrade severely on large files, but using SQL IN gets the job done ... select Index,Text  from YourData.txt  where Index in ( SELECT add(Index,1)  FROM YourData.txt  WHERE text like '%Nancy Carlsbad%' ) or Index in ( SELECT Index...

hi there, I even sent apache's access.log to logparser, but it can't work correctly. It seemed the log file as textline format, what should i do to get the right data from it? Thanks.