mysql query etc to find which items are disabled/not supported

[alubel]

With over 200 hosts, I have trouble finding "not supported" or "disabled" items - is there an easier way (sql query or a custom page) to find this out without clicking on each host?

[simonuk1]

http://www.zabbix.com/forum/showthread.php?t=17186&highlight=unsupported

[alubel]

Yep I have seen that, so if I add:
zabbix internal
zabbix[items_unsupported]

Would the type of information be log/text/character? because I'm not looking for a number, I am looking for which things are disabled on each host.

#zabbix_agentd -t zabbix[items_unsupported]

returns notsupported so i have no idea what to expect.

[andresvia]

With over 200 hosts, I have trouble finding "not supported" or "disabled" items - is there an easier way (sql query or a custom page) to find this out without clicking on each host?

Try this query:

SELECT * FROM items i, hosts h WHERE i.hostid=h.hostid AND h.status=0 AND i.status=3;

See the get_status() function from the ./include/config.inc.php file.