Log Parser Lizard


provides a modern graphical user interface to Microsoft Log Parser for analyzing logs using SQL queries.

Any file is a database with Log Parser Lizard

 

 

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 provides a great Graphical User Interface (GUI) to Logparser 2.2, an advanced file parsing engine from Microsoft that runs on all versions of Windows OS. No cloud or web server needed. It is a versatile desktop tool that gives automated SQL query access to any system log or text-based data including Web Server Logs (IIS, Apache, W3C, SharePoint, MS Exchange, FTP, etc...), Windows System Events and even application log files (generated with log4net, Nlog, SeriLog, etc.). Also great for Data Visualization (dataviz), Business Intelligence (BI) and Extract Transform Load (ETL) tasks.

 

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 pfirewall.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:

 

 

 

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, inline 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).
  • Multiline 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.)
  • Facebook Query Language - FQL
  • Text file RegEx Input Format
  • Google BigQuery
  • Ultimate Dates Table
  • HTML Table Reader
  • Excel File Reader
  • Visual Basic .Net Data Source
  • PowerShell Script

 

 

 

 

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!

 

 

 

DOWNLOAD LOG PARSER LIZARD v7.0 

Download not starting? Try this direct download link. 

 

 

 

If you already installed LPL, there is no need to download it again. Just click here to purchase your registration code online for immediate delivery:

 

 


BUY LICENSE CODE NOW

 

Happy Log Parsing!

 

 

Latest version 7.0 released on July 18, 2019. Latest patch, Log Parser Lizard v7.0.1, released July 31, 2019.
Page updated August 25, 2019 by Lizard Labs Software.