Zabbix

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

Configuration

Host name

{psl}.{ber|dus}.{ns125|rds26}.{vh|hh|fb|hh|...}.{ug|eg|1og|...}.{kind e.g. vserver}.{machine name, e.g. pslsrv32}. Example:

psl.dus.ns125.fb.1ug.vserver.pslsrv15

Visible name

{PSL} | {BER|DUS} | {NS125|RDS26} | {VH|HH|FB|HH|...} | {UG|EG|1OG|...} | {kind e.g. vServer} | {machine name, e.g. PSLSRV15}. Example:

PSL | DUS | NS125 | FB | 1UG | vServer  | PSLSRV15

Monitoring

SQL

https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/mysql

CREATE USER 'zbx_monitor'@'%' IDENTIFIED BY '{PASSWORD}';

GRANT USAGE,REPLICATION CLIENT,PROCESS,SHOW DATABASES,SHOW VIEW ON *.* TO 'zbx_monitor'@'%';

Use Client templates from /etc/zabbix/zabbix_agentd.d