Search results matching tag 'logparser'

Prining

hg363 — Thu, 22 Oct 2009 21:50:45 GMT

Hi to all forum members.

Is there an SQL script in existance or can one be configured that when executed with Log Parser would show which printers a client printed to from a MS Windows XP Pro PC?

And if this is possible can the script then be inflated to show what dates the print jobs were sent to the printers and if possible the print job name and how many pages?

If some one could kindly show me how this can be done, it would be most helpful, regards HG363 UK London

How do you convert date format from dd/mm/yyyy to yyMMdd?

thaichi23 — Thu, 22 Oct 2009 08:42:46 GMT

Hello all,

I have my IIS to record daily so the log name is ex091022.log. I want logparser to find the log that has the current date similar to "select * from ex%date%.log"

The only problem is that %date% returns 10/22/09 and that will not automatically grab the right log. I want to grab the date in the yyMMdd format. Is this possible?

My logparser statement works great but this is the only problem. I am going to save the logparser query as a .bat file and let task schedular run this everday at a certain time so that way it automatically grabs the current date's log and slaps it into SQL.

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

How to query IIS log entries logged in the past N minutes?

ApexIT — Tue, 22 Sep 2009 17:28:58 GMT

Host in located in EDT and IISW3C logs are logging to GMT.

I found the example for EVT logs in logparser help, e.g.:

>logparser "SELECT * FROM Application WHERE TimeGenerated >= TO_LOCALTIME( SUB( SYSTEM_TIMESTAMP(), TIMESTAMP( '20', 'mm' ) ) )"

How can I retrieve IISW3C entries from the last N minutes?

Does Logparser support manifest-based provider?

hengyi — Thu, 16 Jul 2009 22:04:35 GMT

I'm using the manifest-based provider to write the ETW messages. When I use logparser to load the .etl file, it throws the error "Error: Cannot find provider of event {guid}". But the provider is registered and I can use Event Viewer to see these messages. Does Logparser support manifest-based provider?

Since I'm using x64 Windows 20008, could it also because 32-bit Logparser can't find the 64-bit provider? Is there a 64-bit version of Logparser?

iCheckpoint in code

Hopefully — Wed, 24 Jun 2009 13:33:03 GMT

Howdy,

I am writing a little number to alert me of heavy hits to my web server. I'm using vb.net and the COMIISW3CInputContextClass class to do it. I was wondering, could anyone help me figure out how to get a iCheckpoint put into the code so it checks from the last spot reported on in the web log? Here is what I have...Thanks!

Dim oLogQuery As New MSUtil.LogQueryClass
Dim myInputFormat As New MSUtil.COMIISW3CInputContextClass
Dim myOutputFormat As New MSUtil.COMChartOutputContextClass
' Create the query
Dim getTheTopHitters As String = "SELECT TOP 10 c-ip as heavyhitters, COUNT(*) AS Hits FROM '" & myFilePath & "\*.*' GROUP BY heavyhitters ORDER BY Hits DESC"
' Execute the query
Dim oRecordSet As MSUtil.ILogRecordset = oLogQuery.Execute(getTheTopHitters, myInputFormat)

Early Binding in VB6/VBA

Oorang — Fri, 29 May 2009 21:16:49 GMT

I am trying to set a reference to the logparser.dll (C:\Program Files\Log Parser 2.2\LogParser.dll), and when I do, the IDE closes the browse window without an error. But no reference is set. The net effect is that I can't make this work with early binding?

Parse a text file with "|" as field delimiter and "^" as record delimiter

albertop — Thu, 07 May 2009 14:48:48 GMT

Hi,

Is it possible to parse a text file which is basically a CSV file but it has "|" as field delimiter and "^" as record delimiter?

Example:

This is field 1|This is field 2|This is field 3^
This is field 1|This is field 2|This is field 3^

If yes, how?

Regards,

Alberto.

Logparser 2.2

rlawson — Mon, 27 Apr 2009 15:12:52 GMT

If logparser 2.2 compatible with windows 2008/64bit? to see security .evt logs

I I am using logparser 2.2 and it was working perfect until the domain controllers were upgraded to windows 2008 64bit, now I get a file is corrupt.

Need help

Thanks

Complete newbie question: Parse multiple logs in multiple subfolders...

solojer — Tue, 21 Apr 2009 15:01:36 GMT

I'm trying to figure out how to form the FROM when I have multiple log files in multiple subfolders, such as: C:\LogFolder\ C:\LogFolder\Log1\* C:\LogFolder\Log2\* C:\LogFolder\Log3\* etc.. If I use... SELECT * FROM C:\LogFolder\* ... it doesn't seem to search all subfolders... ? Thanks for your attention to this!