Date and time change detection

[Piotrekzielony]

Hi All

Zabbix v5.4

I've got a timestamp from SQL database that i need to monitor.
This is the format returned from SQL - this is single cell value that i need to work with:

2022-06-23 10:57:54.030

Checks are done every 1 minute via SQL query and pulling intervals can be adjusted. This field in database is updated by 3rd party program every 5 min and I need to detect if this field in database hasn't been updated in 5 min so if the value is 2022-06-23 10:57:54.030 for more than 10 min I need to fire trigger

But i don't know how to approach this in the best possible way


I new to zabbix - i have it for a year now but actually never had a chance to learn about its all functionality.


Can someone help me with this or point me to right direction, please?

[Hamardaban]

The right direction is to convert the string you received to unixtime and make a normal time comparison.
All this can be done in preprocessing using JS.

[Piotrekzielony]

The right direction is to convert the string you received to unixtime and make a normal time comparison.
All this can be done in preprocessing using JS.

Thanks

I did it like this (i cannot get my head around unixtime to be honest):

var date1 = new Date(value);
var date2 = new Date();

var diff = date2.getTime() - date1.getTime();

var msec = diff;
var hh = Math.floor(msec / 1000 / 60 / 60);
msec -= hh * 1000 * 60 * 60;
var mm = Math.floor(msec / 1000 / 60);
msec -= mm * 1000 * 60;
//var ss = Math.floor(msec / 1000);
//msec -= ss * 1000;

return mm;

Returns difference in minutes

[Hamardaban]

You don't have to translate in minutes, but use the difference in seconds and set Units as uptime. Zabbix will recalculate itself and show the readable value.
Or if you are only interested in the divergence of time by a constant, then you can simply output 1\0 depending on whether there is a divergence or not.

[Piotrekzielony]

Thank you @Hamardaban for tips

I'll play with this later on this week but just a small question - does JS can use host's macro values?

[Hamardaban]

The answer is here:

https://www.zabbix.com/documentation/current/en/manual/config/items/preprocessing/javascript

https://www.zabbix.com/documentation/current/en/manual/appendix/macros/supported_by_location

in short - no. Only user macros.