Log Parser Studio

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 of charge?

Virus Total .com shows the file is infected with W32.AIDetectVM.malware, detected by BKAV.

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 

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.

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.

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?

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

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...

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%'