• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 463
  • Last Modified:

How to import NT/2000 application event logs into an sql database

We want to import our NT/2000 application event logs into an sql database on a daily basis for analysis, is there a way that we can do this manually or are there any tools available to automate the process. Ideally we'd want to generate a new application log each day & store the previous days logs for importing either manually or automatically.
0
richardwakefield
Asked:
richardwakefield
1 Solution
 
JamesDSCommented:
richardwakefield

Take a look at EventComb, part of the MS Security Operations Guide:
http://www.winnetmag.com/Article/ArticleID/27132/27132.html

Cheers

JamesDS
0
 
oBdACommented:
Check this for an automated solution:
GFI LANguard Security Event Log Monitor
http://www.gfi.com/lanselm/
0
 
markoidwilsonCommented:
Hello,

Just a idea wher to start. Try using DUMPEL.exe from the 2k resource kit http://www.microsoft.com/windows2000/techinfo/reskit/tools/existing/dumpel-o.asp this will dump a event log to a txt file from there I would use DTS to import the data to SQL. There is a handy wizard to perform the task Go to stratmenu/progams/microsoft sql server/import export data
Need any help give me a shout see what I can do.

0
 
Nabeeh ElDarderyCommented:
try this  Log Parser

http://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=8cde4028-e247-45be-bab9-ac851fc166a4

Log Parser 2.0 is a powerful, versatile tool that makes it possible to run SQL-like queries against log files of almost any format and produce the desired information either on the screen, in a file of any desired format or into a SQL database. Log Parser is available as a command-line tool and as a set of scriptable COM objects.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now