Get List of items with no info for more than x minutes

[simonquentel]

Is there a means inside Zabbix to get the list of items that didn't retrieve any data for more than x minutes?

I know there is a trigger to inform wether some items don't send data but I would need to know precisely which ones are having problems.

[heaje]

You'd have to get into the database and look at the "items" table. There is a column in there that I believe is called "lastclock". That is a Unix timestamp of the last time data was received for that item. You could write a quick query using that column to find what you want.

[eskytthe]

The queue? (chose detail)

https://www.zabbix.com/documentation/2.0/manual/web_interface/frontend_sections/administration/queue

BR
Erik

[heaje]

The queue doesn't say which items haven't received data. For instance, lets say an item runs every 2 minutes, but we only want to know if no data has come in for 10 minutes. Looking at the queue would have that item show up 8 minutes earlier than intended.

[heaje]

Here's the query I would use (from MySQL):

SELECT * FROM items WHERE DATE_ADD(`lastclock`, INTERVAL 10 MINUTE)<UNIX_TIMESTAMP() AND (`lastclock`+`delay`)<UNIX_TIMESTAMP();

That would retrieve all items that have not received data in the last 10 minutes and based on the interval, data should have come in within the last 10 minutes.

[simonquentel]

Thanks a lot Heaje.

Simon