I have some t-SQL code that is looking for any table returns, however if the row returned are greater that 0 it is a upper error.
It is all working great, however when the channel limits are OFF and i check it now, the Message column returned the SQL name, which is what want, however when i turn on channels i get a "1 is greater than 0" message.
I tried %LastMessage and %Message, but nothing works.
How can i display the same value in the message field, even when alerting???
Article Comments
Dear Cypha,
Error messages always supersede other returns from a sensor. You could either use threshold triggers for your notification (this way your sensor would send an alert but remain green with the query message displayed in the message field), or create an additional sensor without any threshold where the message is displayed.
You can also define error / warning messages for a limit, but those messages are static and cannot be replaced by placeholders.
Best regards
Oct, 2014 - Permalink
Dear Cypha,
Error messages always supersede other returns from a sensor. You could either use threshold triggers for your notification (this way your sensor would send an alert but remain green with the query message displayed in the message field), or create an additional sensor without any threshold where the message is displayed.
You can also define error / warning messages for a limit, but those messages are static and cannot be replaced by placeholders.
Best regards
Oct, 2014 - Permalink