sql_log_monitor

sql_log_monitor.ps1

#SQL Log monitor script
# http://ramblingcookiemonster.github.io/SQLite-and-PowerShell/

#Query DB, Select any events that match error code 3047 in last 5 minutes. If any match, restart service, else do nothing.

$database = '.\log.db3'
[datetime]$enddate = Get-Date -Format f
$startdate = $date.AddMinutes(-5)

#Query the DB
$query = Invoke-SqliteQuery -Datasource $database -Query "SELECT TimeStamp,ErrorCode FROM LOG WHERE errorcode = '3047'"

#Filter for records in our time range 
$result = Where-Object {[datetime]$query.datetime -ge $startdate -and [datetime]$query.datetime -lt $enddate}

if ($result -ne $null){restart-service EmailRobot}