False email alerts

[killiam]

Hi,

the problem we have is the following, we have configured a sql test, to check the status of some databases. And we have configured to send and email when the status is bad and god.

So we have type a logical expresion which is the next, one the BAD STATUS ACTIONS:

('%StatusID% '=='08') and (%Recurrences%==3)

So we only want to be emailed when the status is bad (no other status)

And on the GOOD STATUS ACTIONS is configured with standard mode, and we have checked "action depends on bad one" (I cannot select the master action)

The problem is that we are being emailed, alerted saying that this database is UP (without being alerted with the previous email saying that status of the ddbb is bad. So I do not understand why we are being emailed....

¿Can Anyone help to solve this problem?

Thanks in advance

[KS-Soft Europe]

The problem is that "action depends on bad one" is applicable to the "standard" actions only. It wil not work with "advanced mode" actions. That's why you was unable to select appropriate master action.

There are several possible solutions:

The first one is disable "Treat Unknown status as Bad" option in "Test Properties" window. In this case you can use "standard" action to be emailed after 3 consecutive bad statuses occured. Hence you may setup "standard" "Good" action with "action depends on bad one" option.

The second is to use "advanced" mode action for "good" action. You should use %LastStatus% and %PreviousStatusDuration_Sec% variables. For instance, you setup HostMontior to perform the test every 5 minutes (300sec). So, to it takes 600 sec to cover 3 consecutive bad results. So, you may try to use expression like the following:

Code: Select all

('%SimpleStatus%'=='UP') and (%Recurrences%==1) and ('%LastStatus%' =='Bad') and (%PreviousStatusDuration_Sec%>=600)

The third solution also may use "advanced mode" actions, but it is more complicated because it requires using "Warning" status for first two "Bad" results. In this case you may use following expression for the "Bad" action:

Code: Select all

('%StatusID% '=='08') and (%Recurrences%==1) 

and the following expression for the "good" action:

Code: Select all

('%SimpleStatus%'=='UP') and (%Recurrences%==1) and ('%LastStatus%' =='Bad')

Regards,
Max