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.

LPSV2.D2.zip
 
 
 
 
 
4.6 Star
(138)
302,812 times
Add to favorites
Exchange
12/12/2014
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • Log Parser Studio & SQL Functions
    3 Posts | Last post March 21, 2013
    • New to LPS (and like it) but am stuck on trying to figure out how to grab part of a field.  
      
      Querying on Date, Time, cs-username, s-ip, cs-uri-stem and cs-uri-query on a logfile folder.
      
      What I want to do is to just grab a portion of the cs-uri-query field to use in the query.  I thought the proper syntax would be:
      substring(cs-uri-query,17,8) or substr(cs-uri-query,17,8)
      but when I try that, I get an error that says:
      
      "Error parsing query:  Syntax Error: <field-expr>: cannot find a valid <field-expr>:'substring(cs-uri-query,17,8)' [SQL query syntax invalid or unsupported]"
      
      I'm certain that's how it functions in TSQL, and I'm able to do a LIKE on the portion of that field I'm trying to select, so I'm a little confused.  
      
      What am I missing?  Are there other SQL functions that do/don't work in LPS?
      
      Thanks!
    • Log Parser 2.2 has similar but not always identical SQL type functions. However, SUBSTR()should work... 
      
      Try: SUBSTR( string <STRING>, start <INTEGER> [ , length <INTEGER> ])
      
      Example: SUBSTR(cs-uri-query, 0, 5)
      
       
    • A quick follow up that the Log Parser 2.2 manual has a complete list of Log Parser functions (there are quite a few of them). It is located in the directory Log Parser 2.2 was installed in. The default location is usually:
      
      C:\Program Files (x86)\Log Parser 2.2\LogParser.chm
      
      The latest version when released will also have a link directly to a function list.
  • Np Data from the Log Parser Studio
    2 Posts | Last post March 21, 2013
    • Also as mentioned in the document, there are no files located in the %AppData%\Microsoft\Log Parser Studio\LibraryName.XML ( in Appdata, i am looking at the LOCAL folder, not the ROAMING folder).
      
      Any advise on how get see the output ? I have just one log file ot look at to see if this works, but no luck until today.
      
      
    • You can change the CSV default output path in Options > Preferences > Default Output Path if I'm understanding the question. :)
  • No Data from the Log Parser Studio
    2 Posts | Last post March 21, 2013
    • Sorry Team..
      this became frustrating when i had installed log parser 2.2 and LPS on a Windows 7 64 bt machine and try to open an IIS activesync log but the output is blank. i have the right file type chosen.
      
      The same log file was opened by the Microsoft PSS engineer however it doesnt work on my machine... Please are there any pre-reqs for this tool. I have spent my last 10 hrs figuring out but no use ?
      
      
    • The only pre-req is .Net 4.0 and the complete install of Log Parser 2.2. Complete means that logparser.dll gets installed and registered which is part of the "complete" option in the installer.
      
      If I remember there is one ActiveSync query that shipped with a typo. I'm not in a place I can find it at the moment but will update when I do. If you can post the query or the name of the query you are running, I'll compare and reply.
  • Is there any update on upcoming versions?
    2 Posts | Last post March 21, 2013
    • I am using a custom log format with space separator and specific columns. It will therefore be very useful to be able to define custom log types.
      
      Any update on the TSV support?
    • The latest version is nearly ready. Currently, finishing up some new queries and there should be at least minimal support for modifying log type parameters AKA better TSV support.
  • Are there issues using LPS on HTTPERRR logs?
    3 Posts | Last post March 21, 2013
    • When I try to run a query against an HTTPERR log I get "Error parsing query: SELECT clause: Syntax Error: unknown field'cs-uri'.  The closest match for input format 'IISW3C is 'cs-uri-stem'. [Record filed dies not exist.]"
    • I am facing the same issue. HTTPERR log type is not recognized. When checking the LogType in the library xml file, the queries are configured with IISW3CLOG log type.
      
      @DCLF1, did you find a way to get it working?
      
      @Others, are httperr log files really supported?
    • There was a typo when setting the log type for most of the HTTPErr queries. Try loading the query, change the log type to HTTPErr, then save the query. That should fix it.
  • Great Tool, bat ...
    5 Posts | Last post March 22, 2012
    • When you run a query I get the following error:
      
      Unhandled Exception length cannot be less than zero
      
      See the end of this message for details on invoking 
      just-in-time (JIT) debugging instead of this dialog box.
      
      ************** Exception Text **************
      System.ArgumentOutOfRangeException: Length cannot be less than zero.
      Parameter name: length
         at System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy)
         at ExLPT.MainForm.queryTimer_Tick(Object sender, EventArgs e)
         at System.Windows.Forms.Timer.OnTick(EventArgs e)
         at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
         at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
    • Hi Andrea,
      
      Try downloading again. The download contains an updated version that corrected this issue. Looking at the error above, this looks like the version that doesn't contain that update. I will download again myself to make sure the updated code is present. Let us know if you have further issues.
      
      Kary
    • Wonderfull!! Now works well. Great tool.
      
      thank you.
    • Is this open source project? If yes, where I can find the source.
    • Good one..reports from IIS made really easy.
61 - 66 of 66 Items