CODEWITHSUNDEEP
windowsparsinglogparser
amit kohan
amit kohan

Reputation: 1618

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.

Upvotes: 0

Views: 280

Answers (1)

Gabriele Giuseppini
Gabriele Giuseppini

Reputation: 1579

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 ...

Upvotes: 1

Related Questions