View Image

Log Parser Lizard GUI is a log parsing and data querying software. Log parser can parse various system or application logs in a way that you can execute SQL queries against them. Log Parser Lizard gives Graphical User Interface (GUI) to Microsoft Log parser 2.2, an advanced file parsing engine from Microsoft that runs on all versions of Windows. Log Parser Lizard is designed to support developers, administrators, auditors and information security teams with powerful SQL querying on structured log data such as: web server logs, Windows system events, application log files (log4j, log4net, nlog, serilog), CSV, TSV, JSON, XML, etc. LPL can also query databases on remote servers such as Microsoft SQL Server, SQLite, MySQL, OLE DB and many other data sources. Log Parser Lizard is used for log analysis, threat detection, data collection, easy data export, visualization, business intelligence (BI), reporting and extract transform load tasks (ETL).

Some features:

Use SQL to read logs
Querying large amounts of log data for specific information is easy with familiar SQL syntax. You can even write a complex SQL query (with functions, group by, joins, unions, etc.)

Look & Feel
We put a lot of effort into creating a modern Office inspired Multiple Document Interface with ribbons and tabs, to guarantee the best user experience. You want to use an application that looks nice if you spend a lot of time looking at log files.

Query editor
The query editor has syntax highlighting and code auto-completion, code snippets, query constants, in-line VB.NET code, and more!

Query Manager
The query management feature provides a nice way to organize Log Parser queries.

Easy Navigation and Data Visualization
The results output in a default table view (data grid) similar to Excel, but with more advanced features at your fingertips. Sorting, grouping, searching, filtering, conditional formatting, formula fields, column chooser, and split view. Additionally, you can transform the data in a Excel, HTML, MHT or PDF report, and consolidate the data into a chart for clearer readability. You can use command line to automate the process.

Data Filtering
From Query Builder and Instant Find to Auto-Filter row. A simple to use Excel inspired UI for creating advanced filter expressions to filter in-memory data.

Open Large Log Files
There is no limit on the size of the file(s) that can be processed with log parser. You may process any number of very large files. Takes only a few seconds to count all rows in gigabytes of log files (depending on your hardware).

Understands Custom Log Formats
Regular Expressions and Grok is currently the best way to parse unstructured log data into something structured and queryable. You can even compress and read logs without unpacking (LPL input types can read compressed and/or encrypted .gz logs). Log4net/log4j XML is also supported out-of-the-box.

Pivot table & tree map
When it comes to data mining and multi-dimensional analysis, an advanced and feature complete pivot table and tree map provides business users unrivaled insights into daily operations.

Easy to use Dashboards
Building dashboards using the designer is a simple matter of selecting the appropriate UI element (Chart, Pivot Table, Data Card, Gauge, Map or Grid) and dropping data fields onto corresponding arguments, values, and series. It’s built so you can do everything inside Log Parser Lizard: from data-binding and dashboard design to filtering, drill down and server side query parameters. Available only in Professional edition.

WYSIWYG Report Designer
WYSIWYG Report Designer is a Microsoft Word® inspired reporting platform, designed to simplify the way in which the users generate business reports. Report designer leverages the intuitive nature of a word processor and integrates the power of a banded report designer into one.