« Previous Next »

• 09-16-2008, 7:12 PM

  In reply to

  akentanaka Joined on 09-11-2008, 8:31 AM Posts 6

  Re: New GUI tool for MS Log Parser, Log Parser Lizard Reply Contact 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 !

• 09-17-2008, 10:11 AM

  In reply to

  Dean@53Bank Joined on 09-17-2008, 2:07 PM Posts 2	Re: New GUI tool for MS Log Parser, Log Parser Lizard Reply Contact Can Log Parser Lizard be used to browse IISW3C logs on other network servers?  I can't seem to get the FROM syntax right.

• 09-18-2008, 3:56 AM

  In reply to

  lizardlabs Joined on 12-05-2007, 6:53 AM Posts 24

  Re: New GUI tool for MS Log Parser, Log Parser Lizard Reply Contact Dean@53Bank: 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. www.lizardl.com

• 09-18-2008, 4:16 PM

  In reply to

  Dean@53Bank Joined on 09-17-2008, 2:07 PM Posts 2	Re: New GUI tool for MS Log Parser, Log Parser Lizard Reply Contact Thank you.  That definitely cleared things up for me.  Love the tool by the way.

• 09-22-2008, 6:01 PM

  In reply to

  Foureyes Joined on 09-22-2008, 9:56 PM Posts 1

  Re: New GUI tool for MS Log Parser, Log Parser Lizard Reply Contact  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!

• 09-23-2008, 5:12 AM

  In reply to

  lizardlabs Joined on 12-05-2007, 6:53 AM Posts 24

  Re: New GUI tool for MS Log Parser, Log Parser Lizard Reply Contact Foureyes:  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! 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. www.lizardl.com

• 09-25-2008, 6:23 AM

  In reply to

  sunithavasudevan Joined on 09-25-2008, 10:15 AM Posts 3

  Re: New GUI tool for MS Log Parser, Log Parser Lizard Reply Contact 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)

  Tags: logparser

• 09-25-2008, 12:11 PM

  In reply to

  Rovastar Joined on 03-13-2008, 2:00 PM London, UK Posts 1,777	Re: New GUI tool for MS Log Parser, Log Parser Lizard Reply Contact  You just use the path c:\myfiles\logs*.* etc or the unc path \\myserver\mydirectory\ etc It uses the LogParser syntax for everything. http://www.iisportal.com

• 10-06-2008, 5:00 AM

  In reply to

  lizardlabs Joined on 12-05-2007, 6:53 AM Posts 24

  Re: New GUI tool for MS Log Parser, Log Parser Lizard Reply Contact 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. www.lizardl.com

• 10-15-2008, 7:19 PM

  In reply to

  Edgar the Parser Joined on 08-25-2008, 7:58 PM Denver, CO Posts 10

  Re: New GUI tool for MS Log Parser, Log Parser Lizard Reply Contact 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! P.E.N.

• 10-16-2008, 5:01 AM

  In reply to

  lizardlabs Joined on 12-05-2007, 6:53 AM Posts 24

  Re: New GUI tool for MS Log Parser, Log Parser Lizard Reply Contact Hi Edgar-the-Parser, maybe you have broken installation of MS Log Parser 2.2? Try to reinstall MS Log Parser 2.2 and see if it helps. Log Parser Lizard is using Log Parser COM API as a parsing engine, so if anyone get error messages like this "...bla-bla-bla COM class ... bla-bla ... CLSID {8CFEBA94-3FC2-45CA-B9A5-9EDACF704F66} ... bla-bla-bla..." on any kind of operation system (XP, Vista, Server 2008, etc...) or after an update or something, just try to reinstall MS Log Parser 2.2 and see if LPL works fine. If it still don’t work, maybe you should try something else (reinstall .Net 2.0, Log Parser itself, etc... :). Bye. www.lizardl.com

• 10-16-2008, 11:55 AM

  In reply to

  Edgar the Parser Joined on 08-25-2008, 7:58 PM Denver, CO Posts 10	Re: New GUI tool for MS Log Parser, Log Parser Lizard Reply Contact Yes, that was it. I reinstalled the Log Parser 2.2 after which Lizard resumed working again. Thank you very much! P.E.N.

• 10-27-2008, 11:45 AM

  In reply to

  tom2000 Joined on 10-23-2008, 2:36 AM Posts 3

  Re: New GUI tool for MS Log Parser, Log Parser Lizard Reply Contact   angelos.loizou:  Hi, great tool and initiative. I could not get it to work though. When I click on a button I get this error: "Retrieving the COM class factory for component with CLSID {............ID.........} failed due to the following error: 80040154   Could you please help ?    Thanx in advance.   Angelos   I am getting the same error.. here is the log entry. 2008-10-27 11:38:38,572 47257 [3360] ERROR LLABS  - Exception: System.Runtime.InteropServices.COMException Message: Retrieving the COM class factory for component with CLSID {8CFEBA94-3FC2-45CA-B9A5-9EDACF704F66} failed due to the following error: 80040154. 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)   anyone know what the issue may be? thanks     EDIT: Nevermind guys, i figured out what was wrong

• 11-06-2008, 4:05 AM

  In reply to

  sunithavasudevan Joined on 09-25-2008, 10:15 AM Posts 3

  Re: New GUI tool for MS Log Parser, Log Parser Lizard Reply Contact I am using the GUI Log Parser tool from Lizardlabs.I would like to know how can i pass parameters to my query (IIS logs)? in the command line log parser i give the file name as :   c:\program Files\Log Parser 2.2>LogParser -o:DATAGRID file:IAS-Chat_Transcript_from_IIS.sql?logfiles=G:\CustomerDocs\Symmantec\Latest_logs(Mar2008)\EX01_0302200 8to03032008\ex*+rooms='80cfa2f1-d863-44d2-a6b4-9ab32ae9b2ac'  Point to note from the above path: 1. IAS-Chat_Transcript_from_IIS.sql is the file that contains my query. 2.logfiles is my key constant or the parameter that gets replaced in the query written in the .sql file. 3.+rooms='80cfa2f1-d863-44d2-a6b4-9ab32ae9b2ac' is again another parameter that i pass to the query in IAS-Chat_Transcript_from_IIS.sql .So based in this parameter the query retrieves data related to room guid having the above mentioned values from [cs-uri-query] column of the IIS log.  I required to know how i can pass this +rooms='80cfa2f1-d863-44d2-a6b4-9ab32ae9b2ac'  in the Log parser Lizard GUI tool?   Thanks for your help, Regards, Sunitha

• 11-06-2008, 4:06 AM

  In reply to

  sunithavasudevan Joined on 09-25-2008, 10:15 AM Posts 3	Re: New GUI tool for MS Log Parser, Log Parser Lizard Reply Contact qwee