Delete ELMAH_Error table rows from Andi db earlier than today - x days.

prune_elmah.ps1

param (
  [string]$server,
  [string]$dbname,
  [int]$daysToKeep,
  [Parameter(Mandatory=$false)]
  [string]$logsrc = "Andi Solr Update"
)

function logError([string]$logsrc, [string]$msg) {
    # write error msg to Application EventLog
    Write-EventLog -LogName Application -Source $logsrc -EventId 500 -EntryType Error -Message $msg -Category 0
}

function logInfo([string]$logsrc, [string]$msg) {
    # write info msg to Application EventLog
    Write-EventLog -LogName Application -Source $logsrc -EventId 200 -EntryType Information -Message $msg -Category 0
}

function logWarning([string]$logsrc, [string]$msg) {
    Write-EventLog -LogName Application -Source $logsrc -EventId 400 -EntryType Warning -Message $msg -Category 0
}

try {
  Push-Location
  $pre = Invoke-Sqlcmd -ServerInstance $server -query "USE $dbname; select count(0) as count from ELMAH_Error where TimeUtc <= (GetDate() - $daysToKeep)"
  Invoke-Sqlcmd -ServerInstance $server -query "USE $dbname; delete from ELMAH_Error where TimeUtc <= (GetDate() - $daysToKeep)"
  $post = Invoke-Sqlcmd -ServerInstance $server -query "USE $dbname; select count(0) as count from ELMAH_Error where TimeUtc <= (GetDate() - $daysToKeep)"
  Pop-Location

  $dateAgo = (get-date).AddDays(-$daysToKeep)
  $msg = "Pruned Andi error log entries from $dbname prior to $($dateAgo.ToShortDateString()). `n$($pre.count - $post.count) rows affected."
  logInfo $logsrc $msg
  echo $msg
  exit 0
}
catch [Exception] {
  $ex = $_.Exception
  $msg = "Error pruning Andi error log entries from $dbname. `n`n$ex"
  logError $logsrc $msg
  echo $msg
  exit 1
}