a) When you open a query up in the main generating window and then edit the query it does not refresh the setting.
Say a query is to look for a specfic IP address I run it ok if then I want to edit the query to look for anotehr IP address. Hitting 'generate' doesn't make run teh new query it runs the old (cached) one.
You need to close down the window and re-open the query. It is a real a pain.
Could you have the changes realtime please.
b) Change the display order of the queries and groups.
I cannot find a why to change the display order. I have have created several groups one for each webserver/farm. Now I want to more the display order of these. At the moment they are in the same order as generated. When I have many groups and queries within
the groups this can look a little messy.
c) Copy setting for queries/groups
I want to be able to copy groups and queries. E.g. I have designed several a group with many queries and I want the same group but with me just editing a few settings like the logfiel location, etc a copy would make this soooo much easier.
---
Thanks for the default queries too there are a few nice ones in there. I intend a publishing several useful ones myself as I am creating a whole load of them for the support team to use.
a) When you open a query up in the main generating window and then edit the query it does not refresh the setting.
Say a query is to look for a specfic IP address I run it ok if then I want to edit the query to look for anotehr IP address. Hitting 'generate' doesn't make run teh new query it runs the old (cached) one.
You need to close down the window and re-open the query. It is a real a pain.
Could you have the changes realtime please.
b) Change the display order of the queries and groups.
I cannot find a why to change the display order. I have have created several groups one for each webserver/farm. Now I want to more the display order of these. At the moment they are in the same order as generated. When I have many groups and queries within
the groups this can look a little messy.
c) Copy setting for queries/groups
I want to be able to copy groups and queries. E.g. I have designed several a group with many queries and I want the same group but with me just editing a few settings like the logfiel location, etc a copy would make this soooo much easier.
---
Thanks for the default queries too there are a few nice ones in there. I intend a publishing several useful ones myself as I am creating a whole load of them for the support team to use.
Hi, thnx for the compliment and feedback:
a) Did you change the query in the Popup Query Window (it appears in the bottom of the main Window) or from Queries dialog box (from toolbar)? If you changed it from the dialog box the changes won’t take effect immediately but on the next load of a query,
but if you change it in the popup query window they should take effect temporarily, and generate results with new query parameters (if you want, you can save changes on the query). This is not a bug, it is a feature :)
b) and c) Hmmmm.... Oooook, I get it. I’ll put more query management options in the next release of Log Parser Lizard. Also it will be possible to change groups for a query and much much more ;) As a workaround try to manually edit Queries.xml (a file in
an installation dir) with Notepad.
a) Aha I see the query button for the popup now at the bottom of the main window - I missed that before. I was changing the 'query dialog box windows for all the queries) before and as you know that doesn't refresh. Even if I save the query it the 'query
dialog box' still doesn't reflect the new values. I can reopen the 'query dialog box' and see the changes that have been made but hitting 'generate' does not reflect these changes.
It would be nice if it did though.
For b) above I was trying to do all the changes in the 'queries' window (titled Log Parser queries) I realise you can do reorder the individual queries in a group in the main window 'navigation' panels. So that is ok.
But ordering the groups.
And I thought you could do the ordering versions of the groups in the main navigate panel as there is a 'Navigate Pane Option' and in there is says 'Display buttons in this order' but.....it just has tick boxes. So it is not displaying buttons in this order
just 'display these buttons'. You cannot 'order' them at all from what I can see. I just don't understand what this is for as you also have "Add or remove buttons" option that does the same thing as this but with a nicer GUI. *shrug*
A new one or two
d) This is trivial but I would like a simple counter in second when it is runnig the query so I know how long it has been running for. I could go on the status bar [input records:x, Output Records:x ; Rows in table:x; Querying runnig time: x and (running)
or (completed) ]
So i know it is still running and I know how long a query takes to complete. I have several millions IIS log file rows a days for some farms.
e) Change the priority of Log Parser Lizard (I am going to call it LPL for short).
I don't know how easy this is to do but by defualt the LPL process runs on Normal Priority. When running a long queries it is slow and I cannot click on other windows/etc as it obviously takes up rtesources doing lots of work.
I was wondering if you could have an option of making LPL run in low priorty. Then I can do stuff.
I am a little worried about the effect on performance of the machine. I doubt it will do much but I feel more comfortable running it on Low priorty as my machines testing and staging servers (as they are the only ones that have access to the live production
boxes logs through the firewall) are still used and I want them as responsive as possibel as log are not .
Cheers for this again. Don't worry about not getting feedback from me worry about getting too much! ;)
I am have an error when trying to read my IIS logs. Conversion Type "DBNull" to type String is not Valid. I am sure I do not have something setup correctly but has anyone else seen this error? Thanks
Wanabe
2 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jul 16, 2008 07:19 PM|LINK
Scratch that. Just figured it out. New user and just installed today. Nice tool!
Rovastar
3321 Posts
MVP
Moderator
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jul 17, 2008 02:08 PM|LINK
Thanks for this tool. Just started using it. It comes in very handy. :)
I drop by some suggestions for the new version soon.
Rovastar
3321 Posts
MVP
Moderator
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jul 18, 2008 09:32 AM|LINK
Again what a nice tool. Here is some feedback.
a) When you open a query up in the main generating window and then edit the query it does not refresh the setting.
Say a query is to look for a specfic IP address I run it ok if then I want to edit the query to look for anotehr IP address. Hitting 'generate' doesn't make run teh new query it runs the old (cached) one.
You need to close down the window and re-open the query. It is a real a pain.
Could you have the changes realtime please.
b) Change the display order of the queries and groups.
I cannot find a why to change the display order. I have have created several groups one for each webserver/farm. Now I want to more the display order of these. At the moment they are in the same order as generated. When I have many groups and queries within the groups this can look a little messy.
c) Copy setting for queries/groups
I want to be able to copy groups and queries. E.g. I have designed several a group with many queries and I want the same group but with me just editing a few settings like the logfiel location, etc a copy would make this soooo much easier.
---
Thanks for the default queries too there are a few nice ones in there. I intend a publishing several useful ones myself as I am creating a whole load of them for the support team to use.
lizardlabs
40 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jul 18, 2008 11:06 AM|LINK
Hi, thnx for the compliment and feedback:
a) Did you change the query in the Popup Query Window (it appears in the bottom of the main Window) or from Queries dialog box (from toolbar)? If you changed it from the dialog box the changes won’t take effect immediately but on the next load of a query, but if you change it in the popup query window they should take effect temporarily, and generate results with new query parameters (if you want, you can save changes on the query). This is not a bug, it is a feature :)
b) and c) Hmmmm.... Oooook, I get it. I’ll put more query management options in the next release of Log Parser Lizard. Also it will be possible to change groups for a query and much much more ;) As a workaround try to manually edit Queries.xml (a file in an installation dir) with Notepad.
Any other feedbacks :) ?
Rovastar
3321 Posts
MVP
Moderator
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jul 18, 2008 02:01 PM|LINK
Thanks for the reply.
a) Aha I see the query button for the popup now at the bottom of the main window - I missed that before. I was changing the 'query dialog box windows for all the queries) before and as you know that doesn't refresh. Even if I save the query it the 'query dialog box' still doesn't reflect the new values. I can reopen the 'query dialog box' and see the changes that have been made but hitting 'generate' does not reflect these changes.
It would be nice if it did though.
For b) above I was trying to do all the changes in the 'queries' window (titled Log Parser queries) I realise you can do reorder the individual queries in a group in the main window 'navigation' panels. So that is ok.
But ordering the groups.
And I thought you could do the ordering versions of the groups in the main navigate panel as there is a 'Navigate Pane Option' and in there is says 'Display buttons in this order' but.....it just has tick boxes. So it is not displaying buttons in this order just 'display these buttons'. You cannot 'order' them at all from what I can see. I just don't understand what this is for as you also have "Add or remove buttons" option that does the same thing as this but with a nicer GUI. *shrug*
A new one or two
d) This is trivial but I would like a simple counter in second when it is runnig the query so I know how long it has been running for. I could go on the status bar [input records:x, Output Records:x ; Rows in table:x; Querying runnig time: x and (running) or (completed) ]
So i know it is still running and I know how long a query takes to complete. I have several millions IIS log file rows a days for some farms.
e) Change the priority of Log Parser Lizard (I am going to call it LPL for short).
I don't know how easy this is to do but by defualt the LPL process runs on Normal Priority. When running a long queries it is slow and I cannot click on other windows/etc as it obviously takes up rtesources doing lots of work.
I was wondering if you could have an option of making LPL run in low priorty. Then I can do stuff.
I am a little worried about the effect on performance of the machine. I doubt it will do much but I feel more comfortable running it on Low priorty as my machines testing and staging servers (as they are the only ones that have access to the live production boxes logs through the firewall) are still used and I want them as responsive as possibel as log are not .
Cheers for this again. Don't worry about not getting feedback from me worry about getting too much! ;)
joelangley
185 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Jul 21, 2008 12:01 PM|LINK
Great tool...I have used it for a bit now and it is really good...author is helpful as well! Thanks for sharing this tool with all of us.
tuantomy
6 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Sep 03, 2008 08:07 AM|LINK
Please try to use (work on web):
http://store.bamboosolutions.com/ps-95-5-system-log-manager.aspx
angelos.loiz...
1 Post
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Sep 09, 2008 07:55 AM|LINK
Hi, great tool and initiative. I could not get it to work though.
When I click on a button I get this error:
Could you please help ?
Thanx in advance.
Angelos
qbernard
5019 Posts
MVP
Moderator
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Sep 09, 2008 08:16 AM|LINK
Mm.. haven't try this GUI tool yet.
but did you got log parser installed in the box as well?
Bernard Cheah
asuman1179
5 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Sep 11, 2008 03:29 PM|LINK
I am have an error when trying to read my IIS logs. Conversion Type "DBNull" to type String is not Valid. I am sure I do not have something setup correctly but has anyone else seen this error? Thanks