Hey msivill,
Basically the requirement is :
_time A B C D
2018-11-14 07:56:00 1 0 0 0
2018-11-14 07:57:00 1 1 0 1
2018-11-14 07:58:00 1 1 0 0
2018-11-14 07:59:00 0 0 1 0
2018-11-14 08:00:00 1 1 1 0
2018-11-14 08:01:00 1 0 0 0
2018-11-14 08:02:00 1 0 0 1
2018-11-14 08:03:00 1 0 0 0
2018-11-14 08:04:00 0 0 1 0
2018-11-14 08:05:00 1 1 0 1
2018-11-14 08:06:00 1 0 0 0
streamstats to check for each column (A,B,C,D) and if there is continuous 0 for any column for 4 minutes, it should alert.
As in the above output for B column (between 08:01 - 08:04) and for D (between 07:58 - 08:01) we have continuous 0 so alert should be triggered that B and D column has issue.
... View more