Zabbix: Difference between revisions
Created page with " ==Maintenance== Query most triggered items SELECT DISTINCT `history_uint`.`itemid`, count(`history_uint`.`itemid`) AS CountOf, `items`.`itemid`, `items`.`name` FROM `history..." |
No edit summary |
||
| Line 2: | Line 2: | ||
==Maintenance== | ==Maintenance== | ||
Query most triggered items | Query most triggered items | ||
<nowiki> | |||
SELECT DISTINCT `history_uint`.`itemid`, count(`history_uint`.`itemid`) AS CountOf, `items`.`itemid`, `items`.`name` FROM `history_uint` LEFT JOIN `items` ON `history_uint`.`itemid` = `items`.`itemid` GROUP BY `history_uint`.`itemid` ORDER BY CountOf DESC | |||
</nowiki> | |||
Revision as of 13:37, 15 September 2019
Maintenance
Query most triggered items SELECT DISTINCT `history_uint`.`itemid`, count(`history_uint`.`itemid`) AS CountOf, `items`.`itemid`, `items`.`name` FROM `history_uint` LEFT JOIN `items` ON `history_uint`.`itemid` = `items`.`itemid` GROUP BY `history_uint`.`itemid` ORDER BY CountOf DESC