Streamline Your Log Data Analysis with Log Parser Lizard

 

 

Unlock the power of efficient log parsing and data querying with Log Parser Lizard. Our software empowers you to quickly extract critical insights from logs using SQL queries. It features a user-friendly Graphical User Interface (GUI) for Microsoft Log Parser 2.2, a file parsing engine from Microsoft, compatible with all versions of Windows.

 

Ideal for developers, administrators, auditors, and information security teams, Log Parser Lizard facilitates SQL querying on various structured log data types. These encompass web server logs, Windows system events, and application log files such as log4j, log4net, nlog, and serilog, in addition to CSV, TSV, JSON, and XML formats. The software also supports querying databases on remote servers and is compatible with Microsoft SQL Server, SQLite, MySQL, and OLE DB, among others. With Log Parser Lizard, tasks in log data analysis, threat detection, data collection, exporting, visualization, business intelligence (BI), reporting, and ETL are simplified and more effective.

 

Efficiently analyze log files with SQL queries using Log Parser Lizard, eliminating the need for database storage:

 

SELECT DISTINCT src-ip FROM firewall.log WHERE action='DROP'

SELECT TOP 100 * FROM c:\webserver.log WHERE sc-status <> 200

SELECT cs-uri-stem FROM c:\InetPub\Logs\ex*.log
GROUP BY cs-uri-stem HAVING COUNT(*) > 50

SELECT to_lowercase(extract_extension(cs-uri-stem)) AS PageType, SUM(sc-bytes)
FROM ex131118.log, ex131119.log GROUP BY PageType

 

Enhance your log data navigation and comprehension with the intuitive GUI of Log Parser Lizard, making the process straightforward and effective.

 

 

Log Parser Lizard: Every File Becomes a Queryable Database

 

MS Logparser and Log Parser Lizard are indispensable for system administrators and developers, optimizing tasks such as forensics, debugging, log collection, big data analysis, data visualization, and reporting. Their integration into data management processes is crucial for efficiency and insight.

• Trusted by thousands of users worldwide for its reliability and functionality.
• With over a decade of industry presence, our solution is recognized for its established expertise.
• Certified as safe and secure, as evidenced by our clean status on VirusTotal.
• Offers superior features compared to leading premium products, yet remains accessible and budget-friendly.

 

Transform your log data analysis with Log Parser Lizard. Download now to elevate your data-driven strategies and unlock new levels of productivity in your log and data analysis tasks.

 

 

FREE DOWNLOAD

 

 

 

Favorite Features Among Our Users:

 

 

 

 

All available input formats:

 

 

Log Parser Lizard stands as the premier GUI for Microsoft Logparser, offering unmatched capabilities and flexibility. This powerful query tool delivers universal SQL access to a variety of text-based data, including log files, XML files, and TSV/CSV text files. It also excels in parsing text files with Regular Expressions and GROK. Beyond text data, it adeptly handles essential Windows data sources like Windows Event Log, IIS logs, the registry, the File System, and Active Directory services. For enhanced customization, developers can create Microsoft VB.Net Plugins to extend LPL's functionality. Below is a comprehensive list of all supported input formats:

• W3C Input Format - Parses log files in the W3C Extended Log File Format: Microsoft Internet Information Services (IIS), FTP, Apache, Exchange Tracking, SharePoint, Personal Firewall, Microsoft ISA Server, Windows Media Services, Simple Mail Transfer Protocol (SMTP), etc.
• Windows Event Log - Reads event information from local and remote System, Application, Security, and custom event logs, as well as from Event Log backup files (.evtx).
• Active Directory Services - Enumerates Active Directory objects using SQL.
• Comma-separated values (CSV) - CSV text files are generated by a large number of applications and tools, including Microsoft Excel and PerfMon.
• Tab-separated and space-separated values (TSV) - This format is also the output of many command-line tools.
• Regular Expression Enhanced - Most flexible for parsing text-based log files (supports Regular Expressions and GROK aliases) - any text file is a database.
• Log4j and Log4net XML Format - Apache log4j/log4net XML file format.
• JSON Formatted Log - Reads JSON formatted log files.
• GROK/RegEx Text Parser - Grok is the best way to parse unstructured log data into something structured and queryable. Instead of writing complex regular expressions, use the simple Logstash GROK syntax to quickly build a reader of text-based files - easiest to use, yet powerful.
• XML Input Format - Multiple XML documents and configuration files can be parsed in different ways.
• TEXTLINE Input Format - Parses text files in any format not supported natively. Better than grep.
• IIS W3C Logs - MS IIS web sites logging in the W3C Extended format.
• File System - Better use SQL to enumerate the files and directories.
• Media Files - Use SQL to enumerate video, image, and audio files and get the metadata info.
• Registry values - Enumerates local or remote registry keys and values.
• Logparser COM Input Plugin - With custom plugins, you can query any data source.
• IIS Log File Format.
• IIS Centralized Binary Log File.
• Enterprise Tracing for Windows (ETW).
• Multi-line RegEx (Log4Net or NLOG) Input Format.
• SQL Server T-SQL Query - Use LPL to query relational databases too.
• C# (C-Sharp) .Net Data Source - Run simple C# code and display data in grid.
• HTTP Error log.
• IIS ODBC.
• NCSA Log File Format.
• NetMon Network Monitor.
• TEXTWORD Input Format.
• URLScan IIS filter.
• RegEx Input Format.
• OLE DB SQL Query (MySQL, Oracle, Access, PostgreSQL, etc.).
• Text file RegEx Input Format.
• Google BigQuery.
• Ultimate Dates Table.
• Ultimate Numbers Table.
• HTML Table Reader.
• Excel File Reader.
• Visual Basic .Net Data Source.
• PowerShell Script.
• Microsoft SQL Server Compact Edition (CE).
• SQLite.

 

 

Free Premium Features: