Software →Log Parser Lizard Professional 7.8.0

Run SQL queries against plain text files
SQL queries can be explained as a special type of search operation, only much more powerful and with many more possible customization options. Usually, these queries can only be performed on databases, because they contain special terms that are not recognized by other file formats, but Log Parser Lizard enables you to run SQL queries against plain text files, thanks to its very own SQL syntax.
These queries can be related to file system information, such as to find the top 10 largest duplicate files on your hard disk, or even web services, like IIS logs about IP addresses, hit counts and HTTP status codes. You can also create logs from scratch, since the mentioned ones are all samples provided by the application at the installation.
Export the results to Excel or view chart images with the queried data
After you run the desired queries and view all the requested information, you can save the results to an Excel spreadsheet or PDF file for future reference, or to transfer them over the Internet as email attachments. The available input log formats include Windows Event logs, Active Directory services and Google BigQuery, which can handle massive amounts of web data.
As for the output formats, Log Parser Lizard enables you to save your queries as CSV, IIS log files and image charts. The charts depict a graphical representation of the queried data, to better illustrate differences or certain activities.
Conclusion
In the end, Log Parser Lizard is well worth the amount of trouble you run into before you learn to use its SQL-style syntax, because the information it offers is very useful and also particularly hard to find with any other kind of application that is not shell-based.
Operating System: Windows 7, 8/8.1, 10
Home Page - http://www.lizard-labs.com/