Are you tired of manually sifting through mountains of log data? Look no further than Log Parser Lizard!
Our powerful log parsing and data querying software allows you to easily extract valuable information from your logs using the power of SQL queries. With Log Parser Lizard, you can easily parse various system or application logs and then execute SQL queries against them with ease. The software provides a Graphical User Interface (GUI) for Microsoft Log parser 2.2, an advanced file parsing engine from Microsoft that runs on all versions of Windows.
Designed to support developers, administrators, auditors, and information security teams, Log Parser Lizard can query structured log data such as web server logs, Windows system events, application log files (log4j, log4net, nlog, serilog), CSV, TSV, JSON, XML, and more. Plus, it can also query databases on remote servers such as Microsoft SQL Server, SQLite, MySQL, OLE DB and many other data sources. With Log Parser Lizard, you can easily analyze your log data for log analysis, threat detection, data collection, easy data export, visualization, business intelligence (BI), reporting and extract, transform, load tasks (ETL).
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
Log Parser Lizard takes that power and wraps it up in a beautiful GUI, making it easy to understand and navigate through your log data:
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
Don't waste any more time sifting through log data manually. Download Log Parser Lizard today and start making data-driven decisions with ease. Try it now and see the difference it can make in your log analysis process.
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.
Web API Server
Built in Web Server allows you to run queries and get results in JSON format - usually to connect LPL queries with external data analysis software. Also the built-in web application allows you to access queries results from anywhere using your favorite web browser.
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.
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.
- Medi Files - use SQL to enumerates 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 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:
Log Parser Lizard may be used for FREE by:
- Individuals for personal non-profit purposes at home (most features are available, no support)
- Any local, state, federal or international government agency or institution (all features are available, no support).
- Educational institutions and students for non-commercial purposes related to learning, training, and research (all features, no support).
For commercial users there are editions of LPL: free trial 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 20 days for FREE so you can test it to see if it suits 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, Web Server, 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.
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:
Log Parser Lizard in BOOKS and COURSES:
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 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.
There are many books on GOOGLE and AMAZON in WHICH LPL WAS MENTIONED OR which we recommend as good reading covering the topics of log management and data mining and presentation.
What they say on Twitter:
-
Got to say that #Microsofts Log Parser https://t.co/UaKEjGsDCp is one seriously powerful and under appreciated tool.
— Cool Aardvark feels Spring is close (@cool_aardvark) March 10, 2021
Saved me hours today picking the right 25 rows from 100,000's in an IIS log -
After all these years, Log Parser 2.2 is still a damned handy little utility. Log Parser Lizard is pretty dang cool too!
— C:\hris\Kasten (@Chris_Kasten) June 14, 2018 -
Super nice UI, made some custom queries and it worked like a charm for tracking Hafnium activity! pic.twitter.com/Fq5i3ECgKY
— Darkoperator (@Carlos_Perez) March 15, 2021 -
Log Parser Lizard + Log Parser 2.2 + IIS logs = 😍🥰😍 pic.twitter.com/PUzMNcckQO
— Chad (@CG_iSecurity) February 9, 2021
Log Parser Lizard has consistently been awarded top ratings by independent testing labs and recommended by reviewers worldwide.
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
(Limited-Time Offer: discount from $199 USD)
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.