That should have said of course that when I try to set it up in Log Parser Lizard I get the error. It doesn't give the error on first entering the properties but it doesn't seem to save them and gives the errors on exit.
BTW, you give values of True and False for headerRow, Log Parser uses ON and OFF.
this looks like a nice tool. Unfortunately I keep getting "Attempted to read or write protected memory. This is often an indiction that other memory is corrupt."
Just what I need. The ability to use variables for server and instance above so I can point at any of my production servers would be good
I’m using log parser lizard mainly for statistics on IIS logs, event logs and active directory and for parsing log4net logs with regular expressions for system diagnostics. I don’t have much experience in parsing textline and tab separated files. But you
can try to set ‘options’ in the query. Ex:
select top 500 substr(text,0,22) as Date, substr(text,23,9) as Source, substr(text,32) as Message from '\\#SQLSERVER#\c$\#INSTANCE#\LOG\ERRORLOG' where Message not like '%Log backed up%' and Message not like '%DBCC TRACEON%'and Message not like '%Login failed%'
and Message not like '%Database backed up%' and Message not like '%Database log truncated%'and Message not like '%DBCC CHECKDB%'
and add SQLSERVER and INSTANCE in program options (on the toolbar).
veritas
Just That should have said of course that when I try to set it up in Log Parser Lizard I get the error. It doesn't give the error on first entering the properties but it doesn't seem to save them and gives the errors on exit
I can see that there are some issues and bugs when changing the type of a saved query and his properties :(, but I believe that there is workaround (delete the old query and copy-paste to the new one) until I fix them. Thank you for pointing them out. I
will fix them as soon as possible.
kcb263
this looks like a nice tool. Unfortunately I keep getting "Attempted to read or write protected memory. This is often an indiction that other memory is corrupt."
I am using LPL on a Win XP SP2 and Win 2003 Server. I very rarely have this kind of messages. Mainly when I am selecting groups from Active Directory with a lot of members and try to scroll up/down :(. Can you specify a bit more about conditions under which
you have these messages?
I'm not sure what is happening on my end here. I receive that error when I try running even one of the basic queries (all .htm files) pointing to a local .log file which I copied over to my C:\.
I hope you didn't misinterpret my feedback as being upset. I was just posting the error message in hopes that someone has come across this before and could help troubleshoot.
IMO, what we really need is a way to prompt the user for input.
Did you mean something like this. If you, enter query like (for example) ‘select * from <1> where Date = (@MyDate as date)', when you run it, the program will show dialog box for entering parameter @MyDate and pass it to the LogParser? Or
you have somethin else in mind?
Has anything like this been added by any chance? I really like the tool, but I need a way for my users to be asked for parameters or I may have to pass on using this great tool. Thanks in advance.
Has anything like this been added by any chance? I really like the tool, but I need a way for my users to be asked for parameters or I may have to pass on using this great tool. Thanks in advance.
This and some other features (like better GUI, more properties for graphs, query parameters...) will be added in the next release of the application (probably by the end of summer). If someone has some ideas and special needs please be free to contact me
and I will see what can be done.
I noticed that there is a pop-up query box that appears below the log entries in the GUI. Can this be used to modify the query on the fly for the log file? Not sure what it's pupose is and/or how to use it?
On that same note, is it possible to pull in an entire log and be able to filter the results as needed?
veritas
4 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jan 08, 2008 03:21 PM|LINK
That should have said of course that when I try to set it up in Log Parser Lizard I get the error. It doesn't give the error on first entering the properties but it doesn't seem to save them and gives the errors on exit.
BTW, you give values of True and False for headerRow, Log Parser uses ON and OFF.
kcb263
27 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jan 08, 2008 06:52 PM|LINK
this looks like a nice tool. Unfortunately I keep getting "Attempted to read or write protected memory. This is often an indiction that other memory is corrupt."
lizardlabs
40 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jan 09, 2008 08:28 AM|LINK
I’m using log parser lizard mainly for statistics on IIS logs, event logs and active directory and for parsing log4net logs with regular expressions for system diagnostics. I don’t have much experience in parsing textline and tab separated files. But you can try to set ‘options’ in the query. Ex:
select top 500 substr(text,0,22) as Date, substr(text,23,9) as Source, substr(text,32) as Message from '\\#SQLSERVER#\c$\#INSTANCE#\LOG\ERRORLOG' where Message not like '%Log backed up%' and Message not like '%DBCC TRACEON%'and Message not like '%Login failed%' and Message not like '%Database backed up%' and Message not like '%Database log truncated%'and Message not like '%DBCC CHECKDB%'
and add SQLSERVER and INSTANCE in program options (on the toolbar).
I can see that there are some issues and bugs when changing the type of a saved query and his properties :(, but I believe that there is workaround (delete the old query and copy-paste to the new one) until I fix them. Thank you for pointing them out. I will fix them as soon as possible.
I am using LPL on a Win XP SP2 and Win 2003 Server. I very rarely have this kind of messages. Mainly when I am selecting groups from Active Directory with a lot of members and try to scroll up/down :(. Can you specify a bit more about conditions under which you have these messages?
Please don’t curse the programmer for the bugs.
kcb263
27 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jan 09, 2008 05:35 PM|LINK
I'm not sure what is happening on my end here. I receive that error when I try running even one of the basic queries (all .htm files) pointing to a local .log file which I copied over to my C:\.
I hope you didn't misinterpret my feedback as being upset. I was just posting the error message in hopes that someone has come across this before and could help troubleshoot.
Looking forward to getting it working!
lizardlabs
40 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jan 11, 2008 08:06 AM|LINK
I’m also using Log Parser 2.2 (standalone installation, not the one that goes with IIS Resources kit).
lizardlabs
40 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
May 21, 2008 03:10 PM|LINK
I have created a small web site to support my products (includeing Log Parser Lizard).
Now you can find latest versions of Log Parser Lizard (GUI for MS Log Parser) on this link www.lizardl.com
Thank you all.
kcornwell
17 Posts
Can't get the Lizard working on Server2008
May 24, 2008 09:23 PM|LINK
Can't get the Lizard working on Server2008 x64. I have installed LogParser from MS (if that matters).
When I try to run the app I get the following...
Description:
Stopped working
Problem signature:
Problem Event Name: APPCRASH
Application Name: Log Parser Lizard.exe
Application Version: 1.0.0.0
Application Timestamp: 4756832e
Fault Module Name: KERNEL32.dll
Fault Module Version: 6.0.6001.18000
Fault Module Timestamp: 4791ada5
Exception Code: e0434f4d
Exception Offset: 000000000002649d
OS Version: 6.0.6001.2.1.0.272.7
Locale ID: 1033
Any suggestions?
Nolty
1 Post
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jun 05, 2008 06:30 PM|LINK
Has anything like this been added by any chance? I really like the tool, but I need a way for my users to be asked for parameters or I may have to pass on using this great tool. Thanks in advance.
lizardlabs
40 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jun 18, 2008 07:56 AM|LINK
This and some other features (like better GUI, more properties for graphs, query parameters...) will be added in the next release of the application (probably by the end of summer). If someone has some ideas and special needs please be free to contact me and I will see what can be done.
Wanabe
2 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jul 16, 2008 05:49 PM|LINK
Hello,
I noticed that there is a pop-up query box that appears below the log entries in the GUI. Can this be used to modify the query on the fly for the log file? Not sure what it's pupose is and/or how to use it?
On that same note, is it possible to pull in an entire log and be able to filter the results as needed?
Thanks!