I thought I will be coding in Perl to parse my custom logs (http://forums.iis.net/t/1151663.aspx). Since I dont have a clue in coding in Perl i tried other log4net trial and opensource apps to parse my logfiles. But
nothing beats Log Parser Lizard.
The author is very friendly and accommodating too.
This is probably the only tool that I will be willing to pay for if it ever gets to donateware status. ^-^
Can Log Parser Lizard be used to browse IISW3C logs on other network servers? I can't seem to get the FROM syntax right.
Just use “FROM \\MyServer\LoggingShare\ex*.log” to parse logs from another server on a shared folder. LPL uses MS Log Parser engine and his query syntax. For more information refer to Log Parser Help and other posts on this great forum.
I can't get the program to start. I'm running on Win2003 x64. Is that why?
When I start the program, I see nothing (no window, no error message). "Log Parser Lizard.exe" shows in the Task Manager for a few seconds then disappears.
I can't get the program to start. I'm running on Win2003 x64. Is that why?
When I start the program, I see nothing (no window, no error message). "Log Parser Lizard.exe" shows in the Task Manager for a few seconds then disappears.
I have Dot-Net 2.0, sp1 installed, and LogParser 2.2. IIS is running in 64-bit mode.
Thanks!
Log Parser Lizard should write all unhandled exceptions in log files located in \Program Files\LizardLabs\Log Parser Lizard\Logs. Please look there for more info or send the logs (if they exists) to me so I’ll take a look for a solution. I don’t have much
of experience with Win 2k3 x64 but please try to reinstall Microsoft .Net framework 2.0 (and 1.1 if you can). Since LPL uses a lot of managed and unmanaged code maybe some of dependencies are broken and simple reinstall will fix them. I would also like to
know if someone successfully uses LPL on 64 bit OS. Thnx.
This is a nice tool.It should also include the help for using the LogParser Lizard application along with the help for LogParser2.2.
I have a question :If i have to pull deatils from a IIS log which in a different location(other than in the default location c:\windows\system\32\LogFiles\...) how can provide this in my query .
Eg:
SELECT Date
, QUANTIZE(time,300) AS [timeUTC] -- Group in 5 minute intervals
, SUM(CASE sc-status WHEN 200 THEN 1 ELSE 0 END) AS [S200] -- Count Successful hits
, SUM(CASE sc-status WHEN 500 THEN 1 ELSE 0 END) AS [S500] -- Count Server Errors hits
, AVG(time-taken) AS [AvgTime] -- Calculate the average response/processing time
FROM %LogFiles%
WHERE cs-uri-stem = '/sdccommon/lachat/poll/check.asp' -- The Chat Polling Page
Hi to all. @akentanaka gave me this idea :) So... if what I created has benefited you in some way, please consider making a monetary donation to support my products. My guiding principle is that all of my free software should be freely available in their
full form to everyone, so I won't hold it against you and cut some features if you don't donate, but I would appreciate it if you do. For more information on how-to-help please visit
www.lizardl.com. Thnx.
Hello lizardlabs! Very good job with the Log Parser Lizard. Thank you! I have a question for you though. Running the program on XP SP3, I get the following message when trying to open a query from the left-hand pane:
2008-10-15 12:02:01,078 13390 [2424] ERROR LLABS - Exception: System.IO.FileNotFoundException
Message: Retrieving the COM class factory for component with CLSID {8CFEBA94-3FC2-45CA-B9A5-9EDACF704F66} failed due to the following error: 8007007e.
Source: Log Parser Lizard
at LogParserLizard.LogParser..ctor()
at LogParserLizard.frmLogReportBase..ctor()
at LogParserLizard.frmLogReportCommand..ctor()
at LogParserLizard.frmMain.OpenQueryForm(Int32 QueryId)
at LogParserLizard.frmMain.UltraExplorerBar1_ItemClick(Object sender, ItemEventArgs e)
All versions of .NET are installed on the machine. Appreciate your time!
akentanaka
6 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Sep 16, 2008 11:12 PM|LINK
I thought I will be coding in Perl to parse my custom logs (http://forums.iis.net/t/1151663.aspx). Since I dont have a clue in coding in Perl i tried other log4net trial and opensource apps to parse my logfiles. But nothing beats Log Parser Lizard.
The author is very friendly and accommodating too.
This is probably the only tool that I will be willing to pay for if it ever gets to donateware status. ^-^
LizardLabs, you rock !
Dean@53Bank
2 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Sep 17, 2008 02:11 PM|LINK
Can Log Parser Lizard be used to browse IISW3C logs on other network servers? I can't seem to get the FROM syntax right.
lizardlabs
40 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Sep 18, 2008 07:56 AM|LINK
Just use “FROM \\MyServer\LoggingShare\ex*.log” to parse logs from another server on a shared folder. LPL uses MS Log Parser engine and his query syntax. For more information refer to Log Parser Help and other posts on this great forum.
Dean@53Bank
2 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Sep 18, 2008 08:16 PM|LINK
Thank you. That definitely cleared things up for me. Love the tool by the way.
Foureyes
1 Post
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Sep 22, 2008 10:01 PM|LINK
I can't get the program to start. I'm running on Win2003 x64. Is that why?
When I start the program, I see nothing (no window, no error message). "Log Parser Lizard.exe" shows in the Task Manager for a few seconds then disappears.
In the Event Logs I get a Dot-Net Runtime error:
"Faulting application log parser lizard.exe, version 1.0.0.0, stamp 48565da6, faulting module kernel32.dll, version 5.2.3790.4062, stamp 462643a7, debug? 0, fault address 0x000000000000dd10."
I have Dot-Net 2.0, sp1 installed, and LogParser 2.2. IIS is running in 64-bit mode.
Thanks!
lizardlabs
40 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Sep 23, 2008 09:12 AM|LINK
Log Parser Lizard should write all unhandled exceptions in log files located in \Program Files\LizardLabs\Log Parser Lizard\Logs. Please look there for more info or send the logs (if they exists) to me so I’ll take a look for a solution. I don’t have much of experience with Win 2k3 x64 but please try to reinstall Microsoft .Net framework 2.0 (and 1.1 if you can). Since LPL uses a lot of managed and unmanaged code maybe some of dependencies are broken and simple reinstall will fix them. I would also like to know if someone successfully uses LPL on 64 bit OS. Thnx.
sunithavasud...
3 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Sep 25, 2008 10:23 AM|LINK
This is a nice tool.It should also include the help for using the LogParser Lizard application along with the help for LogParser2.2.
I have a question :If i have to pull deatils from a IIS log which in a different location(other than in the default location c:\windows\system\32\LogFiles\...) how can provide this in my query .
Eg:
SELECT Date
, QUANTIZE(time,300) AS [timeUTC] -- Group in 5 minute intervals
, SUM(CASE sc-status WHEN 200 THEN 1 ELSE 0 END) AS [S200] -- Count Successful hits
, SUM(CASE sc-status WHEN 500 THEN 1 ELSE 0 END) AS [S500] -- Count Server Errors hits
, AVG(time-taken) AS [AvgTime] -- Calculate the average response/processing time
FROM %LogFiles%
WHERE cs-uri-stem = '/sdccommon/lachat/poll/check.asp' -- The Chat Polling Page
GROUP BY Date
, QUANTIZE(time, 300)
ORDER BY QUANTIZE(time, 300)
logparser
Rovastar
3321 Posts
MVP
Moderator
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Sep 25, 2008 04:11 PM|LINK
You just use the path c:\myfiles\logs*.* etc or the unc path \\myserver\mydirectory\ etc
It uses the LogParser syntax for everything.
lizardlabs
40 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Oct 06, 2008 09:00 AM|LINK
Hi to all. @akentanaka gave me this idea :) So... if what I created has benefited you in some way, please consider making a monetary donation to support my products. My guiding principle is that all of my free software should be freely available in their full form to everyone, so I won't hold it against you and cut some features if you don't donate, but I would appreciate it if you do. For more information on how-to-help please visit www.lizardl.com. Thnx.
Edgar the Pa...
13 Posts
Re: New GUI tool for MS Log Parser, Log Parser Lizard
Oct 15, 2008 11:19 PM|LINK
Hello lizardlabs! Very good job with the Log Parser Lizard. Thank you! I have a question for you though. Running the program on XP SP3, I get the following message when trying to open a query from the left-hand pane:
2008-10-15 12:02:01,078 13390 [2424] ERROR LLABS - Exception: System.IO.FileNotFoundException
Message: Retrieving the COM class factory for component with CLSID {8CFEBA94-3FC2-45CA-B9A5-9EDACF704F66} failed due to the following error: 8007007e.
Source: Log Parser Lizard
at LogParserLizard.LogParser..ctor()
at LogParserLizard.frmLogReportBase..ctor()
at LogParserLizard.frmLogReportCommand..ctor()
at LogParserLizard.frmMain.OpenQueryForm(Int32 QueryId)
at LogParserLizard.frmMain.UltraExplorerBar1_ItemClick(Object sender, ItemEventArgs e)
All versions of .NET are installed on the machine. Appreciate your time!