Log parser looking for items in cs-uri-query example.

Here is a command using Log parser to retrieve a specific value in the cs-uri-query item.

LogParser -I:iisw3c "SELECT * INTO Filename.csv FROM \\ServerName\\ServerName\ShareName\W3SVC111\*.log where cs-uri-query Like '%http://bc0.cn/1.js%'" -o:CSV

Published Monday, January 15, 2007 10:22 PM by steve schofield
Filed under:

Comments

# re: Log parser looking for items in cs-uri-query example.

Tuesday, June 26, 2007 11:15 AM by Brian

Great example, just helped me a bunch.

# re: Log parser looking for items in cs-uri-query example.

Thursday, September 20, 2007 1:48 PM by Allen

Why would this query generate a Syntax Error: <term2>: no valid LIKE mask?

%LP% -i:iisw3c -o:W3C "SELECT * INTO FOOBAR.txt FROM ex070919.log where cs-uri-query Like '%winstonboys%'"

But the following query does not?

%LP% -i:iisw3c -o:W3C "SELECT * INTO FOOBAR.txt FROM ex070919.log where cs-uri-query Like '%26domains%'"

NOTE: %LP% is set to: SET LP="C:\Program Files\Log Parser 2.2\logparser"