Ad Widget

Collapse

Alerts duration in zabbix 3.0 mysql

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • obcx
    Junior Member
    • Jan 2022
    • 3

    #1

    Alerts duration in zabbix 3.0 mysql

    Hello everyone, I am struggling to get duration data from column Events->Duration.

    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
    Could anybody advise where this data is in Zabbix 3.0? I couldn't find it in manual.
Working...