Extract Info From Event Viewer

• Jimmy Jen

  SSCrazy

  Points: 2915

  More actions

  November 4, 2004 at 1:45 pm

  #86835

  Is there a way to extract the data out from event viewer using T-SQL to a table ?

  Thanks,

  Jimmy

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 4, 2004 at 1:51 pm

  #529002

  I don't think this is possible using plain T-SQL. However this might be interesting for you:

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

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• Wesley Brown

  SSChampion

  Points: 12045

  More actions

  November 4, 2004 at 2:12 pm

  #529008

  DumpEL is available from the Windows Resource kit, I use it to dump the log then load it into a table parse it any way you like.

  Wes