[db] List all unsupported items

[ysus]

Dear Zabbix Experts,
Do you know from which table I can extract the list of “unsupported items”? Would like to show them on dashboard by reading results of SQL query.
Solution proposed here does not work.

https://www.zabbix.com/forum/zabbix-help/398822-db-select-all-unsupported-items

For the moment I have 10 items with "unsupported" status but query returns nothing.






Thanks

[sancho]

Hello ysus

This aigars.kadikis module might be helpful.

https://blog.zabbix.com/generating-z...-module/24369/

[ysus]

Hi sancho and thanks for sharing! Somehow I've missed this post even if always trying to follow recent tips & tricks in Zabbix configuration.

Personally I'm not an big fan of 3rd party modules in Production environment. But this one seems to be ok because it is more "analytic" tool rather then visualization/monitoring improvements. Very handy for those who doesn't like "mysql>" command line :-)

Actually I'm closing this topic because found solution by myself. Screenshot from development environment below, just need a bit of polishing.

[alexw-z]

Hi ysus

Would you be able to share the query you used to get the above output? I'm currently trying to obtain the same list of unsupported items on my Zabbix sever.

Many thanks in advance.

[ysus]

Hi alexw-z ,

I don't have access to production Zabbix for the moment, please find attached screenshot with query. Sorry for poor quality.

[alexw-z]

Hi ysus - no worries, image to text converter sorted that out no problem. Thanks for taking the time to reply.

If anybody else stopping at any point in the future by wants the query in a ready cut-and=paste format here it is:

SELECT
    h.name AS HOSTNAME,
    i.name AS ITEMNAME
FROM items i
LEFT JOIN item_rtdata ir ON i.itemid = ir.itemid
LEFT JOIN hosts h ON i.hostid = h.hostid
WHERE i.flags IN (0,4)
  AND i.status = 0
  AND ir.state = 1
ORDER BY h.name, i.name;