Log Parser Plus example query

Requests for robots.txt with ip and user agent

This query grabs all requests for the robots.txt file, outputting ip address and user agents, with counts for each.
Keywords:
  • iisw3c
Statement:
logparser -i:w3c -o:xml "SELECT c-ip AS [ClientIp], cs(user-agent) AS [ClientUserAgent], COUNT(*) AS [Requests] INTO robots.xml FROM u_ex1009*.log WHERE cs-uri-stem = '/robots.txt' GROUP BY ClientIp, ClientUserAgent ORDER BY ORDER BY Requests DESC"
Notes: This particular query outputs the data to XML, and renames columns because of that. See <a href="http://strivinglife.com/words/post/The-benefits-of-using-a-file-for-Log-Parser-SQL-queries.aspx" rel="external">The benefits of using a file for Log Parser SQL queries</a> for more information. Leave a comment on this query.

View more examples.


blog comments powered by Disqus