Jump to content

Zabbix

From Parasol

Revision as of 13:37, 15 September 2019 by Sebastian (talk | contribs) (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...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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

Retrieved from "https://wiki.psl.dev/index.php?title=Zabbix&oldid=25110"