Log Parser Studio

Log Parser Studio is a utility that allows you to search through and create reports from your IIS, Event, EXADB and others types of logs. It builds on top of Log Parser 2.2 and has a full user interface for easy creation and management of related SQL queries.

4.6 Star
306,462 times
Add to favorites
E-mail Twitter del.icio.us Digg Facebook
  • IISLog format
    2 Posts | Last post April 20, 2015
    • When I use LPS with a IIS log in IIS format the date and time display as 1/1/2000 when I run the same query in log parser 2.2 the date and time are shown correctly.
    • For now it needs to be removed as part of the query.
  • IIS Advanced Logging - can't get to work
    2 Posts | Last post April 20, 2015
    • I have LPSV2.D1, selected Log Type IISW3CLOG, set UseDoubleQuotes to True
      I get LogFilename and LogRow columns populated but all other columns are empty.
      I've tried to use the TSV format workaround but REPLACE_STR(cs(User-Agent),'""', '') as UserAgent only catches the first space so I still get the user agent split into other fields.
      I tried to export to PowerShell but I get 'Object reference not set to an instance of an object' (if I export the simpler IISW3CLOG query that exports ok).
      Am I missing something?
    • See this blog post:
  • Exchange2013
    2 Posts | Last post April 20, 2015
    • is is compatible with Exchange 2013
    • It is but the log types may vary (EEL, EELX, EWS, RPCA) etc. In other words there may be queries that were originally written for Exchange 2010 that may not work properly for Exchange 2013 logs but it depends on the protocol/log. Of course it is fully compatible when constructing your own queries.
  • COM Plug-In Support
    2 Posts | Last post April 20, 2015
    • Are there any options to support custom COM plug-in support for other log formats?
    • The question has come up but I haven't found a workable solution just yet.
  • Excellent
    2 Posts | Last post August 19, 2014
  • ADD or + functions
    1 Posts | Last post July 17, 2014
    • I'm trying to write my own query dealing with total bytes/kb/mb received and sent in IIS logs. I've got it working except for one thing. I want to add a final piece of data to select for which is the total mb handled (sent and received). I've tried to sum the SUM results of the two columns (sc-bytes and cs-bytes) with SUM, ADD, and + but have gotten errors with all of the attempts. Kary can you please help?
  • What about -iCOM option ?
    1 Posts | Last post June 20, 2014
    • Is it possible to use the COM plugin functionality provided by LogParser ? (I didn't manage to figure out how to do it with LPS 2.2)
      It might be an interesting addition, to parse some custom log files for example
  • Source Code
    1 Posts | Last post June 20, 2014
    • Any chance of releasing the source code for Log Parser Studio? 
      A GitHub or CodePlex repository perhaps? 
  • Windows 2012 R2 and Window 2008 R2 supporting version??
    1 Posts | Last post May 22, 2014
    • When I have installed logparser studio on Windows 2012 R2 and Window 2008 R2 and mapping some log files to parse, getting error message while executing any query. I tried it on 3 machines, 2 win2012 R2 and 1 win2008R2, no luck.
      Error message is: 
      Background thread error One or more errors occurred.
      System.Runtime.lnteropServicesCOMException (OxSOO7000D): Error
      setting property icheckpoint: Invalid value for parameter
      icheckpoint” [The data is invalid.]
      at System.Dynamic.ComRuntimeHelpers.CheckThrowException(1nt32
      hresult Exceplnfo& exceplnfo, U1nt32 argErr, String message)
      at CallSite.Target(Closure, CaIlSite, ComObject, String)
      Site site. TO argO, Ti argi)
      at CalISite.Target(Closure, CaIlSite ...
      Message Tracking: Exchange 2010- Top Talkers by Sender/Send Source
  • This is awesome!
    1 Posts | Last post April 15, 2014
    • I love LogParser, and this is a great addition to it!
21 - 30 of 68 Items