Hi Selveste,
Do you have the option to set the Suppression key to count instead of value?
From the sql_response Help doc:
Note: In the Query Response time and Row count sections, you must specify a low threshold Value when the following features are enabled:
- Alarm and QoS in the Response time and Row count tabs
- The No Record Returned section in the <Query Name> node
***Specify 0 as the low threshold Value in these sections if the Suppression key is set as count in the No Record Returned section in the <Query Name> node. If you do NOT specify any value, the probe CLEARS any alarm generated for no records.
You can run a bogus query against a CA UIM table to simulate the no records returned result such as:
select * from CM_DEVICE where dev_name = 'me'
Test it and you should get no rows/nothing returned. If that is not the case alter the query.
For the row count I left the Low Threshold field empty.
Then every time the query ran, the alarm was generated but then cleared as expected as you can tell from the nas transaction history view.