Skip to content

Instantly share code, notes, and snippets.

@atadams

atadams/gist:3789183

Last active October 11, 2015 02:28
Show Gist options
  • Save atadams/3789183 to your computer and use it in GitHub Desktop.
Save atadams/3789183 to your computer and use it in GitHub Desktop.
Download ZIP
Log Parser: Examples
Raw
gistfile1.md

Select Top User Agents

logparser -i:w3c "SELECT top 20 cs(User-Agent) AS Browser, COUNT(*) AS Requests FROM *.log GROUP BY Browser ORDER BY Requests DESC"

Select Top Client IPs

logparser -i:w3c "SELECT top 20 c-ip AS visitIp, COUNT(*) AS Requests FROM *.log GROUP BY visitIp ORDER BY Requests DESC"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment