Problem with triggering sql value duplicate - Zabbix 5.0.1

[lgasiewski]

Hello, (I made mistake on topic, version on Zabbix is 4.2.8

I've got problem with setup trigger for SQL Always On Replication

SQL Server provide from query to Zabbix value in text of date and time of last replication when was done, its updating every minute like this:

s

What i want to achive is when the updated value will be this same for 5 updates interval it will start Trigger, like here:



I've created a Trigger with this settings:



But eventiualy is sending problem all the time, can someone help me with this situation ?

[Hamardaban]

First: the diff function does not have parameters.
Due to the fact that the value you have in the form of text, you can not apply many trigger functions...
Try the expression "last()=last(#1) and last (#1)=last(#2) and last(#2)=last(#3) " and so on....

[lgasiewski]

I'm sorry can you write this for expression for 2 last, rest i will add, cause i don't accually know right now how to triggering,

[Hamardaban]

{item.last()}={item.last(#1)} and {item.last(#1)}={item.last(#2)} and {item.last(#2)}={item.last(#3)} .........
the last value is equal to the previous value And the previous value is equal to the value 2 times back And the value 2 times back is equal to the value 3 times back and so on

https://www.zabbix.com/documentation/current/manual/config/triggers

https://www.zabbix.com/documentation/current/manual/appendix/triggers/functions

[lgasiewski]

Something went wrong

[Hamardaban]

The last equality (=1) is not necessary - remove it!

[lgasiewski]

Still nothing, even when i remove =1

[Hamardaban]

Wait for the data item to update and get at least five new values. If the problem persists, publish an error message.

[lgasiewski]

Still nothing

[Hamardaban]

Are you sure that the item Type of information = text or character? Not a log type?
The problem is that the system doesn't like the space in the value when comparing.
And for some reason the values are in brackets and not in quotes.

[Hamardaban]

Yes-indeed! Let's see what type of data the data element receives and whether it is possible to change the system that returns the data?