Log Parser is a very powerful and versatile tool that provides universal query access to text-based data, such as log files, XML files, and CSV files, as well as key data sources on the Microsoft Windows operating system, such as the event log, IIS log, the registry, the file system and the Active Directory services.
Because the command-line interface is not very intuitive, we have created our professional system utilities tool Log Parser Lizard. Log Parser Lizard is a GUI tool for managing queries and exporting results to Excel and charts. In addition we have added input filters for RegEx and log4net input log formats (with support for regular expressions) and SQL server T-SQL queries. In the installation package, you’ll find some helpful examples to help you start using Log Parser Lizard (and its SQL-like syntax) for a web log analyzer and system log analyzer.
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.
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.