Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
Apache? IIS? WebSphere? Linux? Windows? Solaris? – MrTuttle Jul 13 '11 at 21:45
In my case IIS, but hopefully the suggested tools can handle various webservers so I left it open. – Myster Jul 13 '11 at 22:15
up vote 3 down vote accepted

Have you considered MS Log Parser 2.2? The price is certainly right :-)

share|improve this answer
what's the learning curve like? – Myster Jul 13 '11 at 22:18
Not bad (if I can pick it up :-) ) – jl. Jul 14 '11 at 13:50
If you want a GUI layer over the top with some helpful pre-canned queries check out – Myster Feb 28 '12 at 2:22

I recently started to use splunk Site Here. It is not an open source tool but has a free version for under 500MB indexed daily data. It is able to import apache log files very easily and can do many different kind of queries.

Other open source apache log file parsers are analog and webalizer, but I think that splunk is much better for what you needd

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.