Log Parser Lizard is a top GUI tool for MS Log Parser that facilitates easy access to data from various text formats like log files, CSV files, and more. The software can efficiently access data from Active Directory, making it an ideal solution for parsing data.
Log Parser Lizard is an impressive software tool for parsing and querying log data. It is specifically designed to cater to information security teams that require powerful SQL querying on structured log data. This tool can analyze various types of log data files, including web server logs, Windows system events, and application log files like log4j, log4net, nlog, serilog, CSV, TSV, JSON, XML, just to name a few.
Log Parser Lizard has a remarkable capability to query numerous databases on remote servers, such as Microsoft SQL Server, SQLite, MySQL, OLE DB, and many other data sources. The software has an excellent Graphical User Interface that offers a seamless experience to exploit the advanced file parsing engine from Microsoft, the Microsoft Log parser 2.2. It runs on all Windows versions.
Beyond its primary use case for data querying and parsing, Log Parser Lizard is also ideal for data visualization, business intelligence, reporting, as well as extract, transform and load tasks (ETL). Users can run SQL queries on plain text files or any other SQL compliant database.
A plethora of SQL queries can be run with LPL, some of which include SELECT DISTINCT src-ip FROM firewall.log WHERE action='DROP' , SELECT TOP 100 * FROM c:\webserver.log WHERE sc-status = 501, and SELECT cs-uri-stem, COUNT(*) FROM c:\InetPub\Logs\ex*.log GROUP BY cs-uri-stem . The software can also extract page types, transform them to lowercase using the to_lowercase function, and sum the sc-bytes for the respective page types, as shown in SELECT to_lowercase(extract_extension(cs-uri-stem)) AS PageType, SUM(sc-bytes) FROM ex131118.log, ex131119.log GROUP BY PageType.
Log Parser Lizard is perfect as a desktop utility for enterprise-grade data mining. The best part is that it does not require any cloud or web server. This software can convert any file into a database, thereby making it easier and more efficient for querying data.
Log Parser Lizard has a remarkable capability to query numerous databases on remote servers, such as Microsoft SQL Server, SQLite, MySQL, OLE DB, and many other data sources. The software has an excellent Graphical User Interface that offers a seamless experience to exploit the advanced file parsing engine from Microsoft, the Microsoft Log parser 2.2. It runs on all Windows versions.
Beyond its primary use case for data querying and parsing, Log Parser Lizard is also ideal for data visualization, business intelligence, reporting, as well as extract, transform and load tasks (ETL). Users can run SQL queries on plain text files or any other SQL compliant database.
A plethora of SQL queries can be run with LPL, some of which include SELECT DISTINCT src-ip FROM firewall.log WHERE action='DROP' , SELECT TOP 100 * FROM c:\webserver.log WHERE sc-status = 501, and SELECT cs-uri-stem, COUNT(*) FROM c:\InetPub\Logs\ex*.log GROUP BY cs-uri-stem . The software can also extract page types, transform them to lowercase using the to_lowercase function, and sum the sc-bytes for the respective page types, as shown in SELECT to_lowercase(extract_extension(cs-uri-stem)) AS PageType, SUM(sc-bytes) FROM ex131118.log, ex131119.log GROUP BY PageType.
Log Parser Lizard is perfect as a desktop utility for enterprise-grade data mining. The best part is that it does not require any cloud or web server. This software can convert any file into a database, thereby making it easier and more efficient for querying data.
What's New
Version 8.1.0: New release