Hello everyone, I am struggling to get duration data from column Events->Duration.
Several tables combined, no success :-( :
Could anybody advise where this data is in Zabbix 3.0? I couldn't find it in manual.
Several tables combined, no success :-( :
Code:
select e.*, FROM_UNIXTIME(e.clock) from events e, hosts h, triggers t, functions f, items i where h.hostid = i.hostid and i.itemid = f.itemid and t.triggerid=f.triggerid and t.triggerid=e.objectid