Hi, i hope you can help me it is the first time that i do something with logparser. My problem is, that I have to get logs from the NTbackup tool, the Syntax for this Event is: logparser -stats:off "SELECT TimeGenerated, EventID, SourceName, Strings FROM Application WHERE SourceName = 'NTBackup' AND...

When I try to run this simple output for security event 517 Logparser 2.210 crashes with message " Log Parser tool has encountered a problem and needs to close. We are sorry for the inconvenience". When I try to run the same query without the Where statement, all records are returned including the 517...

There's a problem with checkpointing while copying data from EventLog to SQL database. If the SQL Server (where the LogParser is periodically writing data to) is unreachable (on account of network problems, for instance) LogParser is still making checkpoint. And next time, when SQLSRV is accessible,...

There's a problem with checkpointing while copying data from EventLog to SQL database. If the SQL Server (where the LogParser is periodically writing data to) is unreachable (on account of network problems, for instance) LogParser is still making checkpoint. And next time, when SQLSRV is accessible,...

I am writing a script to collect security events on some servers and put them in an SQL database. The script runs fineon some servers but fail on others with error: The event log file is corrupted. The script and the error are shown below. Any help is greatly appreciated Sam C:\Program Files\Log Parser...

I just figured this one out. Add the parameter -ignoreIdCols: ON .

I am reading evt files from several servers into a SQL server database. I need a unique column so I added an ID column to my table. Now when I try to import more records into my database I get an error because the input schema from the evt files does not match my table because now I have this new ID...

Hi I have made a script to collect all security logs from a amount of servers and put the result into a SQL databse. And it works fine with a schedule task that is running every evening. But one day the logparser.exe went into "debug mode" and therefore it stoped collecting data. After some troubleshooting...

Sorry for taking so long to reply, I was out of commission for awhile. That works, thanks for the help.

It would seem I had two versions installed on this machine. All is well now.