Hello, I'm running logparser in a C# application, and I'm using the ExecuteBatch method. This runs nicely (I think) because I do get the output file, but the method returns false. Now the main question I wanted to ask is. since my query is searching in a bunch of files, I was wondering if it's...

It appears that LogParser truncates the event log message string if using either the DataGrid or SQL outputs (I haven't tested other outputs yet) Is this a bug with LP or is there a setting that I haven't seen to enable the entire message to be sent to the DataGrid or SQL? Thanks

Hi everyone, I have two LP queries that return different results from the same origin. One output's a 3d exploded pie chart, and a second that return a table with 4 columns with a sumarized result of a second query. How can I run this both (separate) queries keeping in mind that the result should...

Hello, I want to dump events from live ETW session into XML file at realtime. Another tool is going to parse this file as it is being written. I tried this command: "LogParser "SELECT * INTO out.xml FROM ExampleTrace" -i:ETW -o:XML". That created zero-size file 1.xml and the file...

[quote user="joelangley"] Yes, it is possible. Can I ask though how are you getting the data into SQL. Are you using .NET or Scripts or straight from within logparser. [/quote] Thanks joelangley. I am getting data from csv to SQL using command straight from within logparser2.2. Let me explain...

Hi, I am using log parser 2.2 to convert perfmon csv data to SQL server database, with -createTable:ON. The column of input perfmon csv file and the column of new generated table are consistent, it's OK. But I want to know that is there any way I can insert a addition customized column (not exist...

Hello Gents, I'm using the follow LogParses string to write all 'Security' Event logs to a specific SQL DB: LogParser -i:EVT -o:SQL "SELECT * INTO EventLog FROM Security" -server:SERVERNAME\SQLEXPRESS -database:LogHog -driver:"SQL Server" -createTable:ON -maxStrFieldLen...

Here's my code that works. I actually dumped log files from System, Application and Security logs into the database. using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; // Log Parser 2.2 using MSUtil; namespace...

I need help with an automated batch job that writes hourly bandwidth usage from previous day log file. More specifcally, how do dynamically generate the file name for my query. Any help will be appreciated.

I'm trying to query a text file and build an output that includes inserted text in selected fields. Query that works: LogParser "SELECT Text INTO Status FROM C:\Download\LogParser\full.backup.log where Text like '%Error%' " -i:TEXTLINE -o:SQL -oConnString:"Driver={Microsoft...