Post reply

Automate creating the text log file in Windows environment

  • December 11, 2006 at 11:23 pm

    #170652

    Hi,

    One of the articles on this site tells how to read from Windows Event logs into a table, but does not specify how to "Automate creating the text log file in Windows environment".  Any ideas how to do this?

    Thanks.

  • December 12, 2006 at 4:52 am

    #677428

    I'm not sure what you mean.  What are you trying to create a text log file of?

    John

  • December 12, 2006 at 2:43 pm

    #677636

    I don't think there is way to read event log data from sql but you can use DumpEvt free utility to convert event log into sql import format...

    SomarSoft's DumpEvt is a Windows NT/200x program to dump the event log in a format suitable for importing into a database. Similar to the DUMPEL utility in the Microsoft Windows Resource Kit, but without some of the limitations. DumpEvt has been updated to now allow dumping the new Windows 200x event logs (DNS, File Replication, and Directory Service) 

    http://www.systemtools.com/somarsoft/index.html

     

    MohammedU
    Microsoft SQL Server MVP

  • December 13, 2006 at 9:21 am

    #677823

    Here's a great tool It reads the event logs and creates files. It uses an very SQL-like selection criteria so you can be very selective.

    http://www.microsoft.com/technet/scriptcenter/tools/logparser/default.mspx

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • December 13, 2006 at 4:50 pm

    #677953

    I am trying to create a text file from Windows event logs, so to be able to import them into a database and send some alerts.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply