Following on from the zabbix status script, I have put togethor another script to list any unsupported items on agents.
For an item to go unsupported, it usually means something is wrong with the agent, so I add this script to /etc/cron.hourly.
The SQL query to get the list of unsupported items is,
|
1 2 3 4 5 6 7 8 9 10 |
SELECT hosts.host AS hostname, items.description AS item, items.key_ AS "key" FROM items RIGHT JOIN hosts ON items.hostid=hosts.hostid WHERE items.status = 3; |
Download
zabbix-unsupported-status.sh (1.3 KiB, 2,435 hits)
Hi, for me it only works with this modification:
SELECT hosts.host AS hostname, items.description AS item, items.key_ AS “key” FROM items RIGHT JOIN hosts ON items.hostid=hosts.hostid WHERE items.state = 1;
bye