FM
вот тебе пример для графаны
SELECT DISTINCT h.host,h.name,hi.model,t.value,h.status,hi.asset_tag
FROM hosts h,hosts_groups hg,host_inventory hi,triggers t,functions f,items i
WHERE hg.groupid=$group_id
AND hg.hostid=h.hostid
AND hi.hostid=h.hostid
AND i.hostid=h.hostid
AND f.triggerid=t.triggerid
AND f.itemid=i.itemid
AND t.flags IN ('0','4')
AND t.description LIKE '%Unavailable by ICMP ping'
LIMIT 1001
h. что означает?
