If you ever tried to analyze IIS Logs, you might be familiar with the LogParser tool from Microsoft, which allows you to make sql-like queries to many text-based log files, such as IIS logs and XML files, and also on other windows data sources, like the event log, registry, file system and Active Directory.
Unfortunately, this great tool comes as a command-line utility without a user interface, making its use difficult. Fortunatelly, I have come across a nice graphical user interface tool called Log Parser Lizard GUI.
Log Parser Lizard GUI uses LogParser under the scenes to provide a much better user experience, while maintaining the power of LogParser. Some of its features include an sql query editor window, results pane, multiple queries, export to multiple formats, charts, and the ability to save your queries for later use.