get-EventLog into SQL

adrian — Thu, 12 Nov 2009 06:00:00 GMT

OK maybe I'm posting my stuff with the wrong tags as I am not getting much responses, hopefully someone out there will see this one

I am having trouble outputting the data back to SQL, I am sure it's in my statements at the bottom of the script but I've not figured it out yet, any help appreciated

CLS
# Create SqlConnection object, define connection string, and open connection
$con = New-Object System.Data.SqlClient.SqlConnection
$con.ConnectionString = "Server=NHQQST502; Database=ITDB;
Integrated Security=true"
$con.Open()

# Define the SELECT statement and create SqlDataAdapter object
$cmdSelect = "SELECT dns_host_name FROM windows WHERE Pingable LIKE 'yes'"
$da = New-Object System.Data.SqlClient.SqlDataAdapter($cmdSelect, $con)

# Create and fill DataTable object
$dt = New-Object System.Data.DataTable
$da.Fill($dt) | Out-Null

#Write-Host

# Retrieve the contact ID, first name, and last name
foreach ($row in $dt.rows)
{
    # $Hostname = Write-Host $row.dns_host_name | ForEach-Object {Get-Eventlog -List -ComputerName $_}
    $dataset = New-Object System.Data.DataTable
    $dataset = $row.dns_host_name | ForEach-Object {Get-Eventlog -List -ComputerName $_}

    #Your are getting closer here

#     foreach ($row1 in $dataset){
    foreach ($row1 in $dataset){
        #$row.entries.count, $row.log
        $a = $row1.Entries.count
        $b = $row1.LogDisplayName
        $c = $row1.Log
        $d = $row1.MachineName
        $e = $row1.MaximumKilobytes
        $f = $row1.OverflowAction
        $g = $row1.MinimumRetentionDays
        $h = $row1.EnableRaisingEvents
        $i = $row1.SynchronizingObject
        $j = $row1.Source
        $k = $row1.Site
        $l = $row1.Container
        Write-Output "**********************" $a, $b, $c, $d, $e, $f, $g

        $SQLOut = "INSERT INTO el VALUES ('$a','$b','$c','$d','$e','$f','$g','$h','$i','$j','$k','$l')"
        $da1 = New-Object System.Data.SqlClient.SqlDataAdapter($SQLOut, $con)
        #$da1 = New-Object System.Data.SqlClient.SqlCommand($SQLOut, $con)
        $da1

    }
}

Search results for 'app:forums' matching tags 'PowerShell v2' and 'Event Logs'

get-EventLog into SQL