Hi Dojo, I have a use case where we monitor the outputs table for a particular channel on MWEdge devices, and we know that a certain channel should have X number of outputs, so we see X number of rows in the outputs table.
We have several services that use the MWEdge elements, and each service just alarms on the outputs for it's specified channel.
We would like to be alerted if the number of outputs drops, as we then know we have a problem. Is there any way to do this via the alarm template, or correlation perhaps? We just need an alert when a row(s) disappear from that table.
Thanks!
Hi Carl,
There is no way to configure an alarm template to throw an alarm when a row disappears. However there are some techniques that can be used to achieve the desired use case.
The first way to achieve this would be to add a standalone parameter that keeps track of the amount of rows in the table. The alarm template can then create an alarm when this drops below a certain number.
Alternatively you can add a State column to the table you want to monitor, this way when a row is deleted it is not immediately removed from the table but the value of this cell will be set to "Deleted". This can then be used in an alarm template to create an alarm.
Kind regards,