I generally use google analytics, but occassionally I need to examine log files, for example to see how many 301 redirects from an old website are issued to real user-agents (rather than robots)
Can anyone recommend a good tool for doing ad hoc queries against log files?