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)
301,724 times
Add to favorites
Exchange
12/12/2014
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • 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: 2.0.0.100, time stamp: 0x52b080d9
      Faulting module name: unknown, version: 0.0.0.0, 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%'
      Regards 
  • 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
  • How do you get Log Parser Studio to query selected log and not local log?
    2 Posts | Last post April 06, 2017
    • When I run an "events" query on a selected event log file, LPS is querying the local event log and not the file I selected under Log File Manager.  I've verified the log I want to query against is checked in the Log File Manager and the log file is the correct type for the query. 
    • Found my problem...
  • how do you check the hit count with this utility ?
    2 Posts | Last post January 13, 2017
    • hi guys how do you check the hit count with this utility ?
    • Sure... To just get the hits for say all of IIS:
      
      SELECT COUNT(*) FROM '[LOGFILEPATH]'
      
      To get the hits for a virtual directory:
      
      SELECT COUNT(*) FROM '[LOGFILEPATH]'
      WHERE cs-uri-stem LIKE '%/myvirtualdirectory%'
      
  • LogParser Open Source
    1 Posts | Last post September 17, 2016
    • Can Microsoft make LogParser 2.2 open source ? We need better ReverseDns functionality, using IP lookup table/s and probably other features like Whois or Country. I requested this for a commercial Log analyzer but was declined. Good work with LPS :-) Ta
1 - 10 of 65 Items