====== 92 利用されているitemを検索(SQL) ======


items.status = 0 : monitored
items.status = 1 : not monitored

<code console>
mysql> SELECT itemid, items.hostid, items.status, items.name, key_, host 
FROM items LEFT JOIN hosts ON items.hostid=hosts.hostid
WHERE key_ LIKE '%vfs.smart.health%'  ;
</code>

{{tag>zabbix}}