MS Log Parser 2.0 w/NCSA Combined

Can Log Parser handle NCSA Combined format with cookie last?

[rdomingos]

I wonder if anyone is using Log Parser (version 2.0) to handle Apache/NCSACombined format with Cookie Last log files? I would like to parse to an SQL table all the fields for lines that contain a GET reference to an *.htm file, but I am encountering all sorts of errors as Log Parser does not recognise the log file when specified as a IISW3C, W3C or NCSA format...

Any help/examples greatly appreciated!

Regards, Rogerio

[hakre]

there is an log parser upgrade to version 2.1 available on microsoft [microsoft.com].

maybe this will help ya. changes:

Support for comparison of two expressions (rather than just an expression and a value) in the SQL grammar
The EXTRACT_TOKEN and RESOLVE_SID functions
New input format switches:
The resolveSIDs switch for the EVT input format
The fixedFields, nFields, and comment switches for the CSV input format
New output format switches:
The encodeDelim switch for the W3C output format
The transactionrowcount switch for the SQL output format
The encodeDelim switch for the CSV output format
The noemptyfile switch for the XML output format
New output format: The DATAGRID output type, which displays results in the LogParser dialog box as shown in the following screenshot.

- hakre