Log Parser Lizard

  • Execute SQL queries against structured log data
  • Query Microsoft SQL Server database using T-SQL
  • Provides a modern GUI to Microsoft Logparser 2.2
  • Powerful UI elements: editors, grids, charts, pivot tables, dashboards, reports, trees, maps, filters...
Message from the author:

Working on desktop tools is hard business these days. In this coronavirus (COVID-19) world mess, it is tough to keep things rolling properly. For us and for many others as well. There are parts of a project that is just straight work. Sometimes it's building and supporting, sometimes, marketing, and sales. Regardless, we need financial support to keep pushing for improvements and stay a float.

So, if the price was the reason you avoid using Log Parser Lizard, we offer 10%, 20%, 40%, 50%, 60%, 70%, 80%, 90% discount on single user licenses (standard and professional edition). Just choose the price you think LPL is worth it or the price you can afford. On the order form use one of these coupon codes COV10, COV20, COV30, COV40, COV50, COV60, COV70, COV80, COV90 to get the discount (please note that if you use these codes we can't offer any technical support). This offer will stay here for a while but probably will be removed at some point in the future.

You can also become a patron on Patreon. We are also looking for sponsors or advice on sponsorship. Please write us at office @ lizard-labs.com if you are interested in putting ads on this site or if you can share any advice on sponsorship (what is the usual monthly price for ads, what we can expect for this site (relatively small number of IT pro visitors), which companies do sponsorship or even better recommend LPL to them and reach us, etc). If we can collect at least 3000 USD monthly from one or several sponsors we can offer LPL for free and make it even more popular among IT professionals.

–ěr just share this page on your social media (it takes just a couple of seconds to share but will help us a lot.).

Thank you very much for your support. Stay safe.

 

 

When was the last time you have checked the log files for suspicious activity? Now would be a good time to review them!

 

 

Log Parser Lizard is a log parsing and data querying desktop tool. 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.

 

Oldie but goldie! Microsoft Logparser is an enhanced query software that digs through information in log files seamlessly and efficiently using SQL queries without storing log data into database:

 

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

 

And Log Parser Lizard is wonderful because it shows that data in a beautiful GUI:

 

log parser

 

Any file is a database with Log Parser Lizard.

 

 

MS Logparser and Log Parser Lizard together are essential tools in every system administrator and developer's toolbox for forensics, debugging, collecting logs, big data analysis, data visualization and reporting

  • Being used by more than 200.000 people all around the world. Including your friends and colleagues, of course!
  • We've been in the industry for over a decade, and our experience corresponds to that.
  • Certified and often awarded by major IT security testing labs. Tested thoroughly on VirusTotal and was found absolutely clean.
  • We provide better features than leading expensive paid-for products and we do it for affordable price

 

 

FREE DOWNLOAD       LEARN MORE        CHECK PRICES

 

 

 

Some features our users love:

 

 

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. Available only in Professional edition.

Printing and Data Export

MS Logparser has built in Extract, transform, and load (ETL) data pipeline, used to collect data from various sources, transform the data according to business rules, and load it into a destination SQL Server data store. In addition, Log Parser Lizard implements powerful printing and data export engine (especially good for Excel files) that supports numerous file formats to export data (XLS, XLSX, PDF, RTF, TXT, MHT, CSV, HTML, Image formats, etc...)

Ready for Big Data

If you are using (or planning to use) Google’s Big Data services (particularly Google BigQuery) to process your large data/log files (IIS or not – doesn't meter), with Google's servers doing all the big data heavy lifting, you can use Log Parser Lizard to be able to fly through vast data sets with all the visualization options they're accustomed to in the software.

Performance

Log Parser Lizard is designed to address your toughest requirements regardless of dataset size and information complexity. The user interface is built for speed - always fast and always responsive.

Plus tons of other useful features!

You will have to install Log Parser Lizard to explore these and many more other features, help files and examples included in the package... download now.

 

 

LEARN MORE

 

 

 

 

All available input formats:

 

 

Log Parser Lizard is a GUI for Microsoft Logparser, definitely the best one available on the market today. Log Parser is a very powerful and versatile query software tool that provides universal query access (using SQL) to text-based data, such as log files, XML files, and TSV/CSV text files, as well as key data sources on the Microsoft Windows operating system, such as the Windows Event Log, IIS log, the registry, the File System, the Active Directory services and much more. If you are a developer, you may build a custom Microsoft VB.Net Plugin for LPL too. This is the list of all available input formats:

  • W3C Input Format - parse 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 - enumerate 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 is also the format of the output of many command-line tools.
  • Regular Expression Enhanced - most flexible for parsing text based log files (supports Regular Expression s and GROK aliases) - any text file is a database.
  • Log4j and Log4net Xml Format - Apache log4j/log4net XML file format
  • JSON Formated Log - read JSON formatted log files.
  • GROK/RegEx Text Parser - Grok is currently the best way in to parse unstructured log data into something structured and queryable. Instead of writing complex regular expressions, use the simple Logstach 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 - parse 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 enumerates the files and directories.
  • Registry values - enumerates local or remote registry keys and values.
  • Logparser COM Input Plugin - with custom plugins, you can literally 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

 

 

 

 

Purchase Premium Features:

 

 

There are two editions of LPL, Standard and Professional. The Professional edition caters for the extra needs of professional system administrators and developers - and quite a few power users as well. After the installation you can use LPL for 60 days for FREE (30 days to try premium features) so you can test it to see if it suites your needs. After that just purchase a license code to unlock a wealth of extra features, including exporting data in Excel, HTML, MHT or PDF, multi-dimensional analysis with pivot table and tree map, store queries in SQL Server database for easily share among users and computers in organization, Dashboards Designer and WYSIWYG Report Designer and more!

  • No further downloads are required - just activate your trial installation. Be up and running in less than a minute.
  • All licenses are perpetual (non-expiring) with free minor updates.

 

 

BUY NOW

 

 

 

 

What they say about Log Parser Lizard:

 

 

  • Scott Hanselman: „ What's this? Oh YES. It's intellisense and tooltips, baby! I can't say how much faster this tool made me once I had figured out LogParser. It's funny how you have to suffer at the command line before you can really appreciate a good GUI. “- Analyze your Web Server Data and be empowered with LogParser and Log Parser Lizard GUI

    " LogParser is good, we know, but LogParserLizard is great." - Scott Hanselman's Ultimate Developer and Power Users Tool List for Windows - Scott Hanselman is a former professor, former Chief Architect in finance, now speaker, consultant and works for Microsoft as a Principal Program Manager, aiming to spread good information about developing software. They say Scott Hanselman is the Chuck Norris of .NET.

  • Russ McRee : " You’re probably familiar with Log Parser, but I’ll bet you didn’t there was a great GUI-based tool with which to leverage its raw power with ease. Log Parser Lizard is one of those indispensable tools that treads lightly on your system but offers a huge bang for the buck. " - toolsmith: Log Parser Lizard - Russ McRee works for Microsoft's Online Services Security & Compliance team. He writes toolsmith, a monthly column in ISSA Journal. Russ has spoken infosec events such Defcon, Black Hat, RSA,and FIRST and has published in the likes of Information Security, Linux Magazine, (IN)SECURE, and SysAdmin. As an advocate of a holistic approach to information security, Russ' website is holisticinfosec.org. He also serves as a volunteer handler for the SANS Internet Storm Center.

 

 

 

 

These guys started with a FREE VERSION, too:

 

 

Now we are proud to call them OUR customers. You can join them too.

 

 

 

 

 

Log Parser Lizard in BOOKS and COURSES:

 

 

Book on web site forensics Book: Website invasion scene This book is written in Chinese. Summary: Through the analysis of web log, analysts can use log parser lizard (LPL) to quickly understand hacking techniques, and then fix vulnerabilities. This book introduced the Information Security OWASP TOP 10 (information security) and the basic operation of log parser lizard (LPL) software.


Course: Log Parser Fundamentals By Robert Boedigheimer

 

Learn how to use Log Parser to write queries against many different input formats. Robert Boedigheimer works for Schwans Shared Services, LLC providing business solutions with web technologies. Robert has been developing web sites for the past 15 years. He is an ASP.NET MVP, an author, and a 3rd degree black belt in Tae Kwon Do. Robert regularly speaks at national and international events.

 


Log Parser Lizard is mentioned on RSA Conference

   

RSA Conference logoRSA Conference is a cryptography and information security-related conference, currently held annually in San Francisco, California, United States; London, England; and Chengdu, China. It is a forum for IT professionals to gather and share the latest knowledge and advancements in the area of Internet security.

 

 

 

 


Below is a list of books on AMAZON in WHICH LPL WAS MENTIONED OR which we recommend as good reading covering the topics of log management and data mining and presentation:
 

       


 

 

 

 

Log Parser Lizard has consistently been awarded top ratings by independent testing labs and recommended by reviewers worldwide.

 

secure order 15 days money back guarantee satisfaction guaranteed icon Fast delivery icon 100 clean download award

 

Today LPL has more than 200,000 users worldwide - and now you can join them too. Download right now, you'll be very glad you did!

 

 

 

CLICK HERE TO DOWNLOAD THE INSTALLER 

Download not starting? Try this direct download link to download this absolutely clean installer (Windows MSI package) for free.

 

 

 

Wanna buy a license? Great (also thanks :), there is no need to install LPL again.
Just click here to purchase your registration code for immediate delivery:


BUY LICENSE CODE NOW

 

Happy Log Parsing!

 

 

Latest version released recently. To find out more tutorials on Log Parser Lizard or notes about latest update, please refer the support portal.