Questions tagged [logparser]

A log parser extracts (usually text) data from a log file into a more specific data structure, making the log information easier to process. A log parser can be implemented as a standalone application, or as a library for a specific programming language. LogParser is also the name of a free Microsoft tool which provides a SQL-like interface to log files of almost any format, from generic CSV, TSV, and XML files to more specific formats.

Many server-side applications create log files, usually in a more-or-less structured text format.

While this allows for maximum flexibility in accessing these logs with a wide variety of tools, it makes programmatic processing a bit of a pain, especially when no concise format specification is available for the logs.

This is where a log parser comes in: it is either a standalone application or a library designed for one or sometimes multiple programming languages, and converts the log file into more specific data structures, such rows in an Excel sheet or class instances.

The newly created data structures contain field names and are type-safe as much as possible, making further processing much easier.

296 questions
0
votes
2 answers

Using Start-process to kick off a LogParser process, error encountered

I'm using the following code to try to use Log Parser to fire off and dump the contents of a .csv file I have into a SQL database. I'm having to try to use a custom function to strip out non-alphanumeric characters so that the columns can be created…
Sean Long
  • 2,163
  • 9
  • 30
  • 49
0
votes
1 answer

Search log file for value with bash

I am trying to create a script which will query a log file (or files) for a particular value and using the values given print out not just the line that it is on but all the lines around it as long as they are not blank. Essentially I want to run it…
0
votes
1 answer

Logparser 2.2 on Sysevent.evt using strings

004 2008-11-23 02:18:49 0 …
user189446
0
votes
1 answer

How to split the single field into multiple fields in logparser

I am very new to log parser. I tried using the different formats and delimiters but that that does not work for me. My log file looks like below.. # Version xx # Feilds: date time c-ip # Software : Weblogic # Startdate : 2013-08-15 17:39:09 date…
0
votes
1 answer

Log parser not reading the new fields included in IIS Log

I use log parser 2.2 to read the IIS log and copy the log into a database. Initially IIS log was having the default fields and I was able to copy the log in to database. Now I included one more field in IIS log but the log parser does not return the…
dhaya
  • 1
  • 2
0
votes
1 answer

LogParser failing in WebApp

I've developed a WinForms app that I've that shows the bandwidth a single IIS site using LogParser. This worked quite well. I've now written the exact same thing in ASP.net, but then the following exception is thrown: Cannot find any file matching…
Tijs Hendriks
0
votes
1 answer

LogParser Lizard

I am using LogParser Lizard to parse Log4Net files and when I am trying to do a query such as: SELECT * FROM "C:\Logs*.log". I get an error saying "The process cannot access the file [...] because it is being used by another process" (correct, it is…
Stefan Iancu
  • 143
  • 1
  • 2
  • 13
0
votes
0 answers

Log Parser COM API being slow

I'm using LogParser COM API to query event logs in my WPF .NET 4.0 app, but now I'm facing a problem that the ExecuteQuery take too long to run. In the sample code which is Winform + .NET 2.0, the ExecuteQuery api of LogQueryClassClass return…
imgen
  • 2,803
  • 7
  • 44
  • 64
0
votes
2 answers

Logparser not work in C#

Error parsing query: The specified FROM-ENTITY "<1>" is invalid [The filename, directory name, or volume label syntax is incorrect.] <1> is working when use in sql in Log Parser 2.2, the folder is exist. Query is working if i following article -…
user1865039
  • 131
  • 1
  • 2
  • 10
0
votes
1 answer

How shall SQL statement be designed to also caluculate number of devices?

How shall I design sql statement to also calculate the number of devices within every User-Agent ID? I work in MS Log Parser Studio (LOGPARSER), working on programming different query Exchange logs (IIS W3C LOG) to compile statistics of mobile…
Christofffer
  • 413
  • 1
  • 5
  • 15
0
votes
2 answers

Library for parsing log file in Java

I've a log file with the following structure. unstructured raw text unstructured raw text .. .. .. ... ... unstructured raw text .. ..
Soumya Simanta
  • 11,523
  • 24
  • 106
  • 161
0
votes
2 answers

Assembly Issue with LogParserDLL (which I convert to Interop.MSUtil using 'tblimp' command)

I wish to use LogParser.DLL assembly, so I test it over normal console application, it worked, then I put it into a server, send to win 2003 for testing(i have no more free space to install services like database), ... it always returned…
Hassan Faghihi
  • 1,888
  • 1
  • 37
  • 55
0
votes
1 answer

Are there any scripts or other methods to parse tomcat logs?

I am new to Stackoverflow. So kindly pardon me if i have not made my homework of searching thoroughly. I have a problem in parsing text from tomcat localhost log and catalina.out file. We all know that we receive SEVERE alerts in either of these…
Spidey
  • 193
  • 1
  • 3
  • 11
0
votes
1 answer

LogParser crashes without error in C#

I'm trying to implement MS LogParser in a C# application. This compiles fine but inexplicably crashes on the logQuery.ExecuteBatch() method. The try/catch block doesn't catch it unless I specifically malform the szQuery, which suggests that…
David M
  • 2,763
  • 4
  • 21
  • 24
0
votes
2 answers

Log Parser 2.2 - Possible to LOOP?

I am attempting to make use of Microsoft's Log Parser 2.2. I am pointing my Log Parser at an XML file. I would like to obtain certain information from the XML file and then reuse this information within the query. I have created some pseudo code…
JHarley1
  • 167
  • 1
  • 3
  • 9
1 2 3
19
20