Log Parser Studio is a great free tool from Microsoft TechNet Gallery that allows you to run SQL statements against Log files. This tool is available as a Zip file, once extracted open “LPS.exe”. Two examples are below but there is also a category (Code – SQL – Log Parser Studio) for more detailed queries.