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.

281 questions
27
votes
1 answer

How do I use LogParser to find out the LENGTH of a field in an IIS Log?

I'm trying to find LONG UserAgent strings with LogParser.exe in my IIS logs. This example searches for entries with the string 'poo' in them. LogParser.exe -i:IISW3C "SELECT COUNT(cs(User-Agent)) AS Client FROM *.log WHERE cs(User-Agent) LIKE…
Scott Hanselman
  • 17,492
  • 6
  • 70
  • 89
13
votes
4 answers

Query IIS logs with extra fields using LogParser

I have IIS log with extra field 'foo'. #Fields: foo date s-sitename ... foo1 2009-02-15 W3SVC1 ... foo2 2009-02-15 W3SVC1 ... As result all LogParser queries are broken: logparser -i:IISW3C "SELECT c-ip, s-ip FROM…
alex2k8
  • 39,732
  • 56
  • 158
  • 214
12
votes
2 answers

Send parsed console output in email

I am working with two Jenkins plugins, Email-Ext and Log Parser. I have the regular expressions for the Log Parser plugin how I want them, and I would like to include the output of the Log Parser plugin in the email that is sent out to users after…
ubiquibacon
  • 9,834
  • 25
  • 101
  • 175
8
votes
4 answers

What LogParser UI do you use?

I just started using Log Parser Lizard to examine my IIS and Event logs. What UI tool do you use on top of LogParser 2.2 to view your log files on production?
Elijah Manor
  • 17,603
  • 16
  • 69
  • 79
7
votes
3 answers

How can I find the average number of concurrent users for IIS to simulate during a load/performance test?

I'm using JMeter for load testing. I'm going through and exercise of finding the max number of concurrent threads (users) that our webserver can handle by simply increasing the # of threads in my distributed JMeter test case, and firing off the…
tresstylez
  • 1,689
  • 6
  • 26
  • 41
7
votes
2 answers

Powershell and logparser arguments

Im trying to run some logparser commands from powershell but Im having issues with passing the arguments across correctly, heres the excert from my script; d:\scripting\smtplogs\logparser\logparser.exe "SELECT TOP 50 Receiver, COUNT() INTO…
Andy Walker
  • 365
  • 2
  • 4
  • 9
7
votes
1 answer

Microsoft LogParser: How to use parameters in a file

I have started to use Microsoft LogParser in order to analyse IIS logs. LogParser allows using SQL query from a file and supply parameters to the query directly in a command line, for example: LogParser file:query.sql?date=2010-12-29…
Timofey
  • 2,350
  • 2
  • 33
  • 50
7
votes
1 answer

MS Log Parser 2.2 Query Error

I am trying to determine if a user downloaded a file from FTP using MS Log Parser 2.2 I have not been able to get parser SQL query going, although I have used several samples queries. Water Down Parser Query does not work: strSQL = "SELECT…
Internet Engineer
  • 2,414
  • 7
  • 34
  • 51
7
votes
2 answers

Get browser name and version from IIS log file in Log Parser

I am looking for find out the browser name and version, OS name and version from User Agent field of IIS log file through Log parser query. As the User-Agent string has different format for every browser and device how could I get the browser name…
user1905397
  • 131
  • 1
  • 3
  • 9
6
votes
1 answer

How do I pass multiple parameters to a logparser sql query?

Using logparser you can pass on parameters to the query you'd like to run such as: logparser file:query.sql?logs=somewhere\*.log -o:Sql -server:databaseserver -database:database -createtable:ON -i:IISW3C -iCheckPoint:somewhere\query.lpc…
svandragt
  • 1,575
  • 19
  • 36
5
votes
4 answers

What is the Best Way to Debug a Windows Service program in Visual Studio 2008

I am using the Microsoft Log Parser in a Windows Service. The program works in a regular web page but when I put the code in a windows service it does not work. I put Breakponts in the windows service but when I run the code the program does not…
Luke101
  • 56,845
  • 75
  • 204
  • 330
5
votes
1 answer

Logparser query to get cookie value

I have abc=1234 added to cookie. It shows up in IIS log. But the cs(Cookie) field shows other cookies also separated by semicolon. I want to use logparser to get the value of cookie abc. Can you please suggest a query? e.g. if cs(Cookie) has value…
Souvik Basu
  • 2,819
  • 4
  • 24
  • 42
4
votes
2 answers

Does Transact-SQL have a similar function to MS Logparser Quantize?

If you are familiar with Microsoft Log Parser you probably recognize the Quantize function which will truncate a value to the nearest multiple of another value. It is quite handy for grouping date-time fields into increments. Date-Time …
Jeff
  • 5,757
  • 1
  • 25
  • 30
4
votes
2 answers

How to use Log Parser Plugin in a Jenkins Workflow script

The Log Parser Plugin is now compatible with Workflow but how do I use it?
Lars Bilke
  • 4,228
  • 5
  • 37
  • 58
4
votes
1 answer

Jenkins: Log Parser Plugin configuration

i'm quite new in Jenkins. I would like to use the log parser plugin to parse the console output of jenkins. Like the documentation explains I have to add a file, which is containing my parsing rules. So there is my question: How do i upload files…
Ventu
  • 765
  • 1
  • 10
  • 22
1
2 3
18 19