How to Insert Powershell output into a SQL Table

• sunshine-587009

  SSCrazy Eights

  Points: 8981

  More actions

  March 20, 2015 at 4:32 pm

  #315858

  Hi!

  I'd like to know how to get windows events script below into a SQL Server Table. Any assistance is greatly appreciated.

  Get-WinEvent -LogName application -MaxEvents 200 | where {$_.LevelDisplayName -eq "Error"}

  Kind Regards,

  S

  ¤ §unshine ¤

• David Webb-CDS

  SSCoach

  Points: 17398

  More actions

  March 20, 2015 at 4:38 pm

  #1785488

  There are a couple of cmdlets I found that are very helpful.

  Out-Datatable converts a variable into a datatable type

  Write-Datatable writes a datatable type variable to a table in SQL Server

  I don't have the original links (sorry) but Googling them should bring them up pretty quickly.

  ---

  And then again, I might be wrong ...
  David Webb