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} ({Short Description}). Example:

PSL | DUS | NS125 | FB | 1UG | vServer | PSLSRV15 (Preview Webserver)

Hostgroups

By Kind, e.g. "#Apache2 Webservers"
By Logical Group, e.g. "*Parasol OS", "*ANM"
By Purpose, e.g. "Storage Units", "Rendernodes"
By Availability Level, e.g. "_Mission Critical 24/7"

Monitoring

Install Zabbix Agent and make sure, 10050/tcp is open (Testen mit 'nc -zvw3 35.234.72.203 10050').

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

Apache2

https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/app/apache_agent