I have a monitoring template set up on Zenoss to run a database query and use Nagios to check that the output of the query, which is a number, is within an acceptable range. When it's not, a CRITICAL level event is generated.
My question is: How can I make this monitoring template also generate a CLEAR level event when the output of the query is within the acceptable range. By doing this, any previously generated CRITICAL level events would be automatically closed once the device is running normally again.