As one of the best GUIs out there for MS Log Parser, Log Parser Lizard simplifies access to data in a range of text formats, including log files, XML files, CSV files, the registry, the file system, and especially Active Directory.
Version: 8.1.0Log Parser Lizard is a log parsing and data querying desktop tool.
License: Free To Try $129.00
Operating System: Windows
Designed to support information security teams with powerful SQL querying against 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.
LPL also provides a great Graphical User Interface (GUI) to Microsoft Log parser 2.2, an advanced file parsing engine from Microsoft that runs on all versions of Windows.LPL is great for data visualization, business intelligence (BI), reporting and extract, transform, load tasks (ETL) too.
Run SQL queries against plain text files and other sources just as you would any SQL compliant database:SELECT DISTINCT src-ip FROM firewall.log WHERE action='DROP'
SELECT TOP 100 *
FROM c:\webserver.log WHERE sc-status = 501
SELECT cs-uri-stem, COUNT(*) FROM c:\InetPub\Logs\ex*.log GROUP BY cs-uri-stem
SELECT to_lowercase(extract_extension(cs-uri-stem)) AS PageType, SUM(sc-bytes) FROM ex131118.log, ex131119.log
GROUP BY PageType
LPL is a simple desktop utility for enterprise grade-data mining. No cloud or web server needed. Any file is a database with Log Parser Lizard.
Version 8.1.0: New release