Search results matching tag 'output'

How To Output the Filename Where Match Occurs?

mOrrIsEmSaBeR — Thu, 12 Nov 2009 16:58:33 GMT

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 possible to output the file name where the match occurs?

e.g.

Query: SELECT DESC INTO OutPutFile.csv FROM C:\\Somefolder\\*.* HAVING DESC LIKE '%My Match%'

the output file will only contain the DESC Field.

And I wanted to have the DESC Field and also the FILENAME.

Thanks in advance,

André Pedro Peixoto

Bug with LogParser - Truncates event log Message string in Datagrid

agc1 — Thu, 22 Oct 2009 19:32:21 GMT

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

Merge two outputs

saturno — Tue, 20 Oct 2009 16:46:31 GMT

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 be (for example) just one html page? (chart on top, and data below).

I also would like to embed in the output the LogParser statistics presented in the end of processing:

Elements processed:

Elements output:

Execution time:

How can I achieve this?

P.S.: I have the Logparser Toolkit (Syngress), and altough it is quite extensive, I didn't found the answer for this questions...

Seems that ETW-live works only with NAT

suhanovsergey — Thu, 06 Aug 2009 11:56:13 GMT

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 was empty even after I had interrupted LogParser with Ctrl+C. I would be pretty ok with any other text-based output format but I couldn't make any output format work as I want. It seems that ETW-live input work ok only with NAT output with default options (-rtp:10) which makes it useless for realtime dumping purposes. "LogParser "SELECT * FROM ExampleTrace" -i:ETW" works OK, "LogParser "SELECT * FROM ExampleTrace" -i:ETW -rtp:-1" does nothing. Of course there is a workaround: use LogQuery and write the data however/whereever I want. Is it a bug or I am doing something wrong?

Re: Log Parser 2.2; csv to SQL

volitanthorse — Wed, 08 Jul 2009 02:01:09 GMT

[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 this problem more detailed:

1, The logparser command Which I used to convert csv to sql:

LogParser "SELECT [(PDH-CSV 4.0) (Pacific Daylight Time)(420)] AS Time, [\\******\Process(explorer)\Private Bytes] AS PrivateBytes, [\\******\Process(explorer)\Virtual Bytes] AS VirtualBytes INTO MyTable FROM C:\perflogs\perflog1.csv" -i:CSV -o:SQL -server:*******\******* -database:MyDatabase -driver:"SQL Server" -username:sa -password:******* -createTable:OFF

2, Before I run that command, I have a database MyDatabase and a table MyTable created already.

3, The number of column in MyTable is 4; and the number of column in csv file is 3.

So how can I convert the 3 columns from csv into 3 columns of sql database, meanwhile, insert a customized column (which is not exist in csv file) to the 4th column of the database.

Thanks very much.

Log Parser 2.2; csv to SQL

volitanthorse — Tue, 07 Jul 2009 08:34:27 GMT

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 in input csv file) into sql server during same csv to sql operation?

Thanks very much.

Output to SQL 2008 DB

RMarrero — Fri, 19 Jun 2009 16:56:57 GMT

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:5000

It works fantastic,but how can I specify ALL event logs instead of just one type; Application, Security, System, etc.

And how can I make them all write and play nicely with one another so they can easily be separtated for quick referrence and accessed using a .net application?

Code for using COM object for C# .Net with SQL Output

Solburn17 — Mon, 08 Jun 2009 20:45:18 GMT

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 LogParser2 {
    public partial class _Default :System.Web.UI.Page {
        // constants
        const string iCHECKPOINT_FILE_LOCATION = @"c:\checkpoint.lpc"; // iCheckpoint allows incremental parsing

        protected void Page_Load(object sender, EventArgs e) {
            GetSystemEventLogToSql();
        }

        private void GetSystemEventLogToSql() {
            try {
                // Instantiate the LogQuery object
                LogQueryClassClass LogQuery = new LogQueryClassClass();

                // Instantiate the Event Log Input Format object
                COMEventLogInputContextClassClass EvtInputFormat = new COMEventLogInputContextClassClass();

                // Set Input Parameters.
                EvtInputFormat.direction = "BW";

                // iCheckpoint parses input incrementally. Give it a location.
                EvtInputFormat.iCheckpoint = @"c:\checkpoint.lpc";

                // Instantiate the Event Log Output Format object
                COMSQLOutputContextClassClass EvtOutputFormat = new COMSQLOutputContextClassClass();

                // Set Output Parameters
                EvtOutputFormat.driver = "SQL Server";
                EvtOutputFormat.server = "ServerName";
                EvtOutputFormat.database = "DatabaseName";
                EvtOutputFormat.username = "UserName";
                EvtOutputFormat.password = "Password";

                // I created the tables and added an ID Column. It needs to be ignored during the insert.
                EvtOutputFormat.ignoreIdCols = true;

                // Create the query
                // tblLogWebSystem is the name of the table I am inserting these records into in my DB
                string Query = @"SELECT * FROM TO tblLogWebSystem";

                // Execute the query into SQL
                LogQuery.ExecuteBatch(Query, EvtInputFormat, EvtOutputFormat);

                Response.Write("Done");
            }
            catch(System.Runtime.InteropServices.COMException exc) {
                Response.Write("Unexpected error: " + exc.Message);
            }
        }
    }
}

How to write daily Bandwidth usage in SQL table

osahaf — Wed, 15 Apr 2009 19:37:21 GMT

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.

How to insert text into Log Parser output from query string

andersce — Wed, 08 Oct 2008 19:28:25 GMT

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 Access Driver (*.mdb)};Dbq=C:\Download\LogParser\LogParser.mdb;

With an output of:

ORA-19625: file error
'ORAO/S-Error: file not found

I need the output to look like:

SLREFW04,Oracle,#27OCT2008#,'ORA-19625: file error'
SLREFW04,Oracle,#27OCT2008#,'ORAO/S-Error: file not found'

How do I add the text values with the SELECT query? I'm running this query in vbscript so I would really like to assign variables and insert those into the query so I can loop through all my servers.Is there a way to go straight to sql server or would I have to create a csv file and then run log parser on that? Thanks in advance