Re: Merging Windows 2003 event logs
- From: Chris Johnson <cej@xxxxxxxxxxxxxxxxx>
- Date: Fri, 16 Jun 2006 16:37:03 +0100
Chris Johnson wrote:
Hi all,
Just a quick question: is there any tool or method to merge a number of Windows application and system event log files into two log files (one complete for application, and another complete for system)?
I've found a rather nice solution: The Microsoft utility LogParser [http://www.logparser.com/]. With it, I've been able to easily load and merge each event log into a SQL Server, something like this:
logparser "SELECT * INTO SysLog FROM WS1\System.evt" -o:SQL
-server:IS5660DEV -database:cejplayground -driver:"SQL Server"
-createTable
logparser "SELECT * INTO SysLog FROM WS2\System.evt" -o:SQL
-server:IS5660DEV -database:cejplayground -driver:"SQL Server"
logparser "SELECT * INTO SysLog FROM WS3\System.evt" -o:SQL
-server:IS5660DEV -database:cejplayground -driver:"SQL Server"
Fantastic :-)
Chris...
.
- References:
- Merging Windows 2003 event logs
- From: Chris Johnson
- Merging Windows 2003 event logs
- Prev by Date: Windows 2003 TS reboots
- Next by Date: Re: Can a user have admin rights on their computer but not on the domain?
- Previous by thread: Merging Windows 2003 event logs
- Next by thread: Re: System error 1326 has occurred - Logon failure:
- Index(es):
Relevant Pages
|
