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
307,015 times
Add to favorites
E-mail Twitter del.icio.us Digg Facebook
  • Exchange 2016
    1 Posts | Last post October 22, 2019
    • Does it work with Exchange 2016?
  • Does is work with Exchange 2013-2016
    1 Posts | Last post October 04, 2019
    • Does it work with all the version of Exchange, meaning Ms Ex2013 and more
  • Not working with custom IIS 10 Logs
    1 Posts | Last post August 16, 2019
    • Log Parser Studio is a great tool!  However, It is not working with IIS 10 logs that have a custom attribute.
      Even a basic SELECT * query does not return anything, and there is no error.  Any help would be great!
  • Is this Software free?
    1 Posts | Last post March 04, 2019
    • Is this software free of charge?
  • Safe to Download?
    1 Posts | Last post February 06, 2019
    • Virus Total .com shows the file is infected with W32.AIDetectVM.malware, detected by BKAV.
  • Receiving Error when trying to run LPS
    2 Posts | Last post February 05, 2019
    • Faulting application name: LPS.exe, version:, time stamp: 0x52b080d9
      Faulting module name: unknown, version:, time stamp: 0x00000000
      Exception code: 0xc0000005
      Fault offset: 0x00630065
      Faulting process id: 0x7430
      Faulting application start time: 0x01d4b81d3a2c131f
      Faulting application path: C:\Program Files (x86)\LPSV2.D2\LPSV2.D1\LPS.exe
      Faulting module path: unknown
      Report Id: defecc7b-796f-4b22-8d65-02f330611ae5
      Faulting package full name: 
      Faulting package-relative application ID: 
      Application: LPS.exe
      Framework Version: v4.0.30319
      Description: The process was terminated due to an unhandled exception.
      Exception Info: System.AccessViolationException
         at MSUtil.ILogQuery.get_versionMaj()
         at ExLPT.GlobalFunctions.checkForLogParser()
         at ExLPT.MainForm.Form1_Load(System.Object, System.EventArgs)
         at System.Windows.Forms.Form.OnLoad(System.EventArgs)
         at System.Windows.Forms.Form.OnCreateControl()
         at System.Windows.Forms.Control.CreateControl(Boolean)
         at System.Windows.Forms.Control.CreateControl()
         at System.Windows.Forms.Control.WmShowWindow(System.Windows.Forms.Message ByRef)
         at System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef)
         at System.Windows.Forms.ScrollableControl.WndProc(System.Windows.Forms.Message ByRef)
         at System.Windows.Forms.Form.WmShowWindow(System.Windows.Forms.Message ByRef)
         at System.Windows.Forms.Form.WndProc(System.Windows.Forms.Message ByRef)
         at System.Windows.Forms.Control+ControlNativeWindow.OnMessage(System.Windows.Forms.Message ByRef)
         at System.Windows.Forms.Control+ControlNativeWindow.WndProc(System.Windows.Forms.Message ByRef)
         at System.Windows.Forms.NativeWindow.Callback(IntPtr, Int32, IntPtr, IntPtr)
    • Hi Guys,
      Please how to use this tools to get users acitivity owa exchange 2013
      Test this comand with logparser  no result 
      C:\Program Files (x86)\Log Parser 2.2>LogParser.exe "select * from C:\W3SVC1\u_ex161023.log to c:\log\output2.csv WHERE cs-method LIKE '%get%' and cs-uri-stem L
      IKE '%owa%'
  • I need a logparser cmd code for find out the details of a particular domain
    1 Posts | Last post October 15, 2018
    • HI ,
      I need to find out users of a particular domain that are hitting SharePoint sites by using Log Parser Studio. Can any one knows the code ,please help me by posting the code.
  • syntax question
    2 Posts | Last post January 24, 2018
    • Hi,
      I can't find the syntax how to generate a Pie Chart or any chart with command line in Log Parser Studio.
      need help
    • Here is an example:
      LogParser "SELECT sc-status, COUNT(*) AS Times INTO Chart.gif 
      FROM <1> GROUP BY sc-status ORDER BY Times DESC" -
      chartType:PieExploded3D -chartTitle:"Status Codes"
      Keep in mind that the second column must be numeric.
  • Is this tool still recommended?
    1 Posts | Last post January 24, 2018
    • I wonder if Log Parser and Log Parser Studio is a tool I can recommend to use in productive environment. Don't get me wrong: I really like these tools. They are really great! But within the relevant MS-forums there are much more questions than answers if at all. Are they outdated?
  • Memory error
    1 Posts | Last post May 18, 2017
    • I get the following error message everytime I run a query
      Using perfmon I can confirm that i dont have any problems with my memory or cpu
      Exception calling "ExecuteBatch" with "3" argument(s): "Not enough memory [Unknown Error]"
      At E:\utils\Scripts\Powershell\LogParser\500 PROD.PS1:97 char:1
      + $rtnVal = $LogQuery.ExecuteBatch($SQLQuery, $InputFormat, $OutputFormat);
      + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
          + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
      i get the same error message even if I use the log parser studio console
1 - 10 of 68 Items