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

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

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

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

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

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

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?

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.

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

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