Since streamid column is not supported in HTTPErr input log format, all the queries are failing even if I am specifically mentioning the column names. How to get around this problem ? Will you able to add support for streamid column
in LogParser HTTPErr query handler ?
1 Post
HTTPErr input log format is not working when 'streamid' column is present
Mar 09, 2019 12:46 PM|Pratyay|LINK
Since streamid column is not supported in HTTPErr input log format, all the queries are failing even if I am specifically mentioning the column names. How to get around this problem ? Will you able to add support for streamid column in LogParser HTTPErr query handler ?
#Software: Microsoft HTTP API 2.0
#Version: 1.0
#Date: 2019-03-02 09:06:31
#Fields: date time c-ip c-port s-ip s-port cs-version cs-method cs-uri streamid sc-status s-siteid s-reason s-queuename
2019-03-02 09:06:31 123.211.412.127 25144 10.0.0.4 80 - - - - - - Timer_ConnectionIdle -
2019-03-02 09:07:36 123.211.412.127 38801 10.0.0.4 80 - - - - - - Timer_ConnectionIdle -
2019-03-02 09:08:11 123.211.412.127 45184 10.0.0.4 80 - - - - - - Timer_ConnectionIdle -
Error Details
C:\Program Files (x86)\Log Parser 2.2>LogParser.exe -i:HTTPErr "SELECT top 5 date, time, cs-version, cs-method, cs-uri FROM 'D:\HTTPERR\httperr2.log'" -e 10
date time cs-version cs-method cs-uri
---------- -------- ---------- --------- ------------------------------
2019-03-02 09:06:31 - - - - - - Timer_ConnectionIdle -
2019-03-02 09:07:36 - - - - - - Timer_ConnectionIdle -
2019-03-02 09:08:11 - - - - - - Timer_ConnectionIdle -
2019-03-02 19:21:26 - - - - 400 - Verb -
2019-03-02 19:21:26 - - - - 400 - Verb -
Task completed with parse errors.
Parse errors:
Unknown field streamid found in #Fields directive
1 Post
Re: HTTPErr input log format is not working when 'streamid' column is present
Oct 23, 2019 02:14 PM|caseee|LINK
Same error here.
Made something like this:
. "C:\Program Files (x86)\Log Parser 2.2\LogParser.exe" "select * into 'C:\logs\errors.xml' from C:\Windows\System32\LogFiles\HTTPERR\*.*" -i:tsv -iseparator ''space'' -lineFilter +"#" -iheaderfile c:\logs\header.txt
with header.txt:
date time c-ip c-port s-ip s-port cs-version cs-method cs-uri streamid sc-status s-siteid s-reason s-queuename