Lizard Labs
Lizard Labs is the home of award-winning software for Microsoft Windows operating systems. Log Parser Lizard is a GUI for Microsoft Logparser and uses a SQL-like query language to work with data in many formats. Ultimate Maps Downloader can download both satellite imagery and topographic maps from Google, Yahoo, Microsoft Bing, OpenStreet and ArcGIS.
Please help us improve our software to better meet your needs.
20 results found
-
How can I store changed column properties with my queries?
When I run a query against any type of logfile using the GUI, I can afterwards right-click on the column and change column properties. For instance, by default the value "0" (zero) is not shown, which is annoying, so I set the format string to "0.###", as opposed to the default #.### for numeric columns.
But when I run the query again, edited or not, these properties disappear and I have to go there again, which is very annoying and in the end makes it rather useless to use these properties.
I don't see any save-button in the properties window,…
3 votesThis is done in Log Parser Lizard version 5.1.2. Now you can save column properties in query by checking the ‘Save data grid layout’ check box in the Save Query dialog box.
-
join between two data sources
I am currently evaluating log parser. is it possible to join data between two different data sources. i.e. IIS query that joins with sql data source. if so, can you point me in the right direction.
1 voteIn Log Parser Lizard version 5.0 new keywords are introduced to merge, join, group queries (these can be very useful since the merged datasets can be used in Dashboards and Reports):
GO – create tables in single dataset without relation (useful in dashboard and reports)
MERGE – merge tables in one
LPL_UNION – same as MERGE
LPL_INTERSECT – intersection of two tables
LPL_PRODUCT – product of two tables
RELATION_ON_FIRST_COLUMN – create tables in single dataset and try to create a relation on first column (must be of same data type)
RELATION_ON_SAME_COLUMNS – create tables in single dataset and try to create a relation on all columns with same name
JOIN_ON_FIRST_COLUMN – joins results of two tables in another one on the first column
JOIN_ON_SAME_COLUMNS – joins tables on the columns with the same name -
From the query editor's ToolBar Allow Execute Query
From the toolbar that has the undo/redo, copy,paste,delete add an execute button there. I find that I having to o back to the ribbon's query button and then sometimes the ribbon is on another tab so I have to switch this first is a real pain and slows me down.
3 votesFixed in Log Parser Lizard Version 5.0
-
Allow Automatic Refresh
Have some way to configure a time period where the data is pulled from the data source automatically at some interval (in seconds). For example, lets say I am querying a SQL table called eventLogs and there are multiple writers adding events into this table. I would like to see an updated view.
3 votesThis feature is implemented in Log Parser Version 5.0. Check the “Run Query with parameters”.
-
Allow to copy selected data in output grid via pressing ctrl+c
Allow to copy selected data in output grid via pressing ctrl+c
1 voteFixed in Log Parser Lizard Version 5.0
-
store the "copy command line to clipboard" automatically with the query
servers can access db and run commands from the central repository. If you'd like to take it a step further write the commands with variable overrides per host and schedules for a powerful automation tool.
1 voteWe think this is Fixed in Log Parser Lizard Version 5.0, but will have to check it first if Auto Run queries was what you were looking for.
-
Customize PDF title
When I export a report to PDF, I would like to be able to customize the report. For instance, include the SQL command, have the title include the value of one (or more) of the constants, etc. Currently, the exported reports do not have sufficient context, e.g., date(s) of data used to generate the report, how generated, etc. Otherwise, it's a GREAT product! Thank you.
1 voteFixed in Log Parser Lizard Version 5.0 (Professional Edition). Now you can use WYSIWYG Report editor to customize the look of your reports.
-
Referencing a VB variable or constant
Using inline VB in a query, how can I declare a variable or constant at the top and reference it later?
<% Dim sMsg As String = "hello"%>
SELECT * FROM MYTABLE WHERE SOMECOLUMN='<% Return sMsg %>'
9 votesThis feature is implemented in Log Parser Lizard 4.0.3. You can find more info in comments.
-
Option to auto-expand columns in grid results
When querying IIS W3C logs I would like all columns to be auto-expanded to their auto-fit width, instead of wrapping the text.
6 votesCompleted in version 5.0. Field properties can be changed.
-
Obtain input from .zip files
It would be very convenient to specify a path to a .zip (or other) archive file or folder location in the FROM field and have a collection of compressed log files automatically extracted and used as input.
11 votesIn Log Parser Lizard version 5.0 compressed .gz archives can be read, but only for RegEx, Multiline RegEx and the new Regular Expression Enhanced Input formats.
-
Allow to type in multiple SQL querys into query editor
Allow you to put in multiple SQL / Log querys in a single query window.
Right now it's very limiting to only allow one SQL statement per query window.
I generally have a "scratch" pad which is just a text document that has common querys for a particular set of tasks all within one query document. THis is preferred to having 10 querys all in seperate files as the 10 querys build upon themselves for analysis, they are not mutually exclusive.
You should be able to highlight text in query window and press F5 to run the SELECTED query like…
5 votesIn Log Parser Lizard version 5.0 new keywords are introduced to merge, join, group queries (these can be very useful since the merged datasets can be used in Dashboards and Reports):
GO – create tables in single dataset without relation (useful in dashboard and reports)
MERGE – merge tables in one
LPL_UNION – same as MERGE
LPL_INTERSECT – intersection of two tables
LPL_PRODUCT – product of two tables
RELATION_ON_FIRST_COLUMN – create tables in single dataset and try to create a relation on first column (must be of same data type)
RELATION_ON_SAME_COLUMNS – create tables in single dataset and try to create a relation on all columns with same name
JOIN_ON_FIRST_COLUMN – joins results of two tables in another one on the first column
JOIN_ON_SAME_COLUMNS – joins tables on the columns with the same name -
Show the Log Parser command line with all the parameters set in the UI.
Showing the command line with all the parameters used, we could execute directly from the command line and avoid the resource (CPU, memory...) used by LPL.
6 votesThis is done in Version 3.0 released on 01/16/2013
-
Import queries from Log Parser Studio
Open Log Parser Studio library of queries and save it as a Log Parser Lizard library
1 voteThis is done in Version 3.0 released on 01/16/2013
-
Report designer
Create and design reports from the parsed data set.
3 votesIn Log Parser Lizard Version 5.0 new WYSIWYG Report Designer is implemented
-
New input format "TextFile input format (with RegEx)"
A whole content of a text file is one record and fields are extracted using regular expressions (similar as existing log4net input formats). Helpful for extracting data parsing bad e-mail files (and many other purposes)
1 voteThis is done in Version 3.0 released on 01/16/2013
-
Add the Create Table Option when exporting to SQL
I've managed to RegEx parse the log4net file but now want to push them into SQL. Can the properties option include "create the table" for me because I'm getting
'SQL table column "Message" data type is not compatible with SELECT clause item "Message" (type STRING) [Data supplied is of wrong type.] '
select DateTime, LogType, Message, Exception
into ProdLogs
from '\server\logfile.log'
where NOT (logType = 'INFO')7 votesThis is done in Version 3.0 released on 01/16/2013
-
Android logcat support
Would like the ability to parse Android logs from ADB logcat.
3 votesThis is done in Version 3.0 released on 01/16/2013
-
Copy-and-paste the output grid.
Add a feature that allows copy-and-paste the entire content of the output grid. While it is possible to export to an Excel files, it would be quicker to just copy-and-paste directly into Excel via clipboard.
1 vote -
Excel style pivot grid
When it comes to data mining and multi-dimensional analysis, an advanced and feature complete pivot table provides users unrivaled insights into daily operations. However, using the pivot capabilities of products like MS Excel meant introducing "out-of-process" solution within application. It would be nice to have pivot grid (OLAP grid) functionality built into Log Parser Lizard.
4 votesThis is done in Version 3.0 released on 01/16/2013
-
Command line support
Run saved queries from command line and output result to stdout
2 votesThis is done in Version 3.0 released on 01/16/2013
- Don't see your idea?