Hi All
we have a text item mssql.monitoring.POSTCOSTGL executing a custom script with the below triggers. item runs at every 10m.
my issue is on SQL Monitoring In Processing ["POSTCOSTGL"]: the requirement is to trigger when the last 3 values are = to 3. note that we have tried also {SQL Monitor POSTCOSTGL:mssql.monitoring.POSTCOSTGL.last(#3)}=3 but its triggered when the value is became 3 at the first time.
note that the item is text the reason is we collect and email text exceptions on SQL Monitoring Unsuccessful ["POSTCOSTGL"].
we will appreciate your prompt response.
we have a text item mssql.monitoring.POSTCOSTGL executing a custom script with the below triggers. item runs at every 10m.
| Average | SQL Monitoring Error ["POSTCOSTGL"] | {SQL Monitor POSTCOSTGL:mssql.monitoring.POSTCOSTGL.last()}=2 and {SQL Monitor POSTCOSTGL:mssql.monitoring.POSTCOSTGL.last()}<> "" | Enabled | |||
| High | SQL Monitoring In Processing ["POSTCOSTGL"] | {SQL Monitor POSTCOSTGL:mssql.monitoring.POSTCOSTGL.count(#3,,,30m)}=3 | Enabled | |||
| Information | SQL Monitoring Successful ["POSTCOSTGL"] | {SQL Monitor POSTCOSTGL:mssql.monitoring.POSTCOSTGL.last()}=1 and {SQL Monitor POSTCOSTGL:mssql.monitoring.POSTCOSTGL.nodata(1m)}=0 | Enabled | |||
| High | SQL Monitoring Unsuccessful ["POSTCOSTGL"] | {SQL Monitor POSTCOSTGL:mssql.monitoring.POSTCOSTGL.last()}<> 1 and {SQL Monitor POSTCOSTGL:mssql.monitoring.POSTCOSTGL.last()}<> 2 and {SQL Monitor POSTCOSTGL:mssql.monitoring.POSTCOSTGL.last()}<> 3 |
note that the item is text the reason is we collect and email text exceptions on SQL Monitoring Unsuccessful ["POSTCOSTGL"].
we will appreciate your prompt response.