zabbix Availability report

[tomcheng]

请教下 Availability report 怎么写的sql？

db结构看了半天也看不出一个所以然。

[tomcheng]

已经解决

SELECT COUNT(e.eventid) AS cnt,MIN(e.clock) AS min_clock,MAX(e.clock) AS max_clock FROM events e WHERE e.objectid='13571' AND e.source=0 AND e.object=0 AND e.clock>='1482681600' AND e.clock<='1483286400'