SQL Error database Monitoring

Hi Matt

Thank you for the suggestions. I can see what you mean and it would - as I requested - result in a "Fire Action" for every error-record...

Only thing about it is that this would not handle a separate "Success/Fixed" action for each record.

I'm thinking that if it was possible to fire an alert with some kind of a Unique ID (linked to that specific record) and keep that ID for reference - and in the event of the error/event ID being removed/marked as solved - it should fire a "Success/Fixed".

This is a bit complicated - I know... And I'm not sure if it is at all solvable.

I will digg further into this and think of possible ways to solve this - but maybe this is an idea for a new feature - so that one can monitor a error-log database or other kinds of databases and create actions/alerts on a per-record basis.

Kind regards Karsten

Hi Matt

Thank you very much! That sounds doable! Thank you for leading the way...

I will go ahead and try it out and eventually post a reply here when it has been tested!

Kind regards Karsten

Hi Matt

A work in Progress... I'm facing some challanges. Can't figure out what's going on.

Here is a copy of my script so far:

$Res = Exec-Sproc -Conn $SqlConnection -Sproc "Web.GetpoweradminServermonitorAlarms"

if ($Res -gt $null)
{

foreach ($Row in $Res)
{
    $StoredError = $mon.GetValue($Row[0])
    $mon.ReportResults()
    if ($StoredError -eq "")
    {
        $NewError="yes"
        $ErrorDetail = "`r`n" + $Row[1] + "`r`n" + $Row[2] + "`r`n" + $Row[3]
        $mon.StoreValue($Row[0],$ErrorDetail)
        $mon.Details = $ErrorDetail
        $mon.FireActions=$true
    }
    else
    {
        $NewError="no"
        $mon.Details = $StoredError
        $mon.FireActions=$true
    }
}

}

To summen up - the script runs a stored procedure that returns 2 rows/records.

Problem 1: The stored procedure is returning 2 records (Checked in Management Studion):

ID | Title | Exeption | Environment | Processed

79 a a Udvikling False
80 b b Test False

When I run the script inside the Console (Production) i get this result:

Multiple responses were received from the script. They would be processed as: Do Not Fire Actions:

Fire Actions: a a Udvikling

Fire Actions: b b Test

When I test the script for real (Let it run on a Schedule - it only returns the first record (action is send mail). And immediatly it gets "Fixed".

What am I missing?

Hope this gives meaning!

Kind regards Karsten Stolten