Advertisement
kazoda

Zabbix trends max value

Aug 3rd, 2014
218
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.28 KB | None | 0 0
  1. SELECT trends.itemid, items.name, items.hostid, hosts.name, trends.value_max,trends.clock FROM items INNER JOIN trends ON items.itemid = trends.itemid INNER JOIN hosts ON items.hostid = hosts.hostid WHERE trends.itemid = 23347 AND trends.clock >= 1406214000 AND trends.clock <= 1406473200;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement