Trigger on Last Check

[dminstrel]

Hello,

I'd like to be able to define a Trigger to fire if the Last Check time for an Item goes over a certain threshold. E.g., raise an alert if the last check is more than 5 hours. Is this possible?

Thanks,

[nelsonab]

Short answer, no.

Long answer, yes. You'd need to write an external script to query the DB.

Here's a simple shellscript I wrote which will query the DB for the item you give on the command line and return the number of seconds since the item was checked. Please note if the Zabbix server and the MySQL server are on different hosts you may run into a time synchronization issue. You can use this shellscript as an external check against the DB.

#!/bin/sh

OPTS=" --skip-column-names"  #options to connect to MySQL such as -h <host>
DB="zabbix"   #The name of the Zabbix DB

MYSQLSTR="$OPTS $DB"
QUERYSTR="select unix_timestamp()-lastclock from items where itemid=$1"

echo $QUERYSTR | mysql $MYSQLSTR

Sample output:

:~/svn/zabbix/misc> ./get_item_time.sh 22126
44

[vinny]

Why not using "nodata(<period in second>)" ?

vinny