« Previous Next »

Thread: Output to SQL 2008 DB

Last post 06-20-2009 3:36 AM by RMarrero. 1 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (2 items)

Sort Posts:

  • 06-19-2009, 12:56 PM

    • RMarrero
    • Not Ranked
    • Joined on 04-11-2009, 8:53 PM
    • Posts 5

    Output to SQL 2008 DB

     Hello Gents,

     I'm using the follow LogParses string to write all 'Security' Event logs to a specific SQL DB:

    LogParser -i:EVT -o:SQL "SELECT * INTO EventLog FROM Security" -server:SERVERNAME\SQLEXPRESS -database:LogHog -driver:"SQL Server" -createTable:ON -maxStrFieldLen:5000

     It works fantastic,but how can I specify ALL event logs instead of just one type; Application, Security, System, etc.

     And how can I make them all write and play nicely with one another so they can easily be separtated for quick referrence and accessed using a .net application?

  • 06-20-2009, 3:36 AM In reply to

    • RMarrero
    • Not Ranked
    • Joined on 04-11-2009, 8:53 PM
    • Posts 5

    Re: Output to SQL 2008 DB

    I got it figured out :)  TY!

Page 1 of 1 (2 items)
Microsoft Communities