Search code examples
windowsparsinglogparser

How to avoid logparser from storing input file name in each row?

I'm parsing a log file (IIS file) using logparser and works great but when I open generated file (csv) its first column is logfile name e.g. c:\temp\in_290414.log which is the input file.

How can I avoid it? Thanks.

Solution

  • Just be explicit in your SELECT clause with the fields you want out of the IIS log:

    SELECT time, date, url, etc INTO output.csv FROM ...