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\ServerNameShareNameW3SVC111*.log where cs-uri-query Like '%http://bc0.cn/1.js%'" -o:CSV

2 thoughts on “Log parser looking for items in cs-uri-query example.”

  1. Why would this query generate a Syntax Error: : 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 FilesLog Parser 2.2logparser”

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s