Zabbix - Revision history

Peter Norenkemper at 08:54, 16 July 2025

2025-07-16T08:54:45Z

2025-07-16T08:53:19Z

Webseiten

← Older revision		Revision as of 08:53, 16 July 2025
Line 214:		Line 214:
	=== Webseiten ===		=== Webseiten ===

	* Host name: www.irgendwas.de		{\| class="wikitable"
			\|+ Zabbix Host
	* Templates:		\|-
			\| '''Host name''' \|\| www.irgendwas.de
	Website certificate by Zabbix agent 2		\|-
			\| Templates \|\|
			Website certificate by Zabbix agent 2<br>
	Website Check by Parasol		Website Check by Parasol
			\|-
	* Host groups:		\| Host groups \|\|
			Web SSL<br>
	Web SSL		External/ Web<br>

	External/ Web

	Websites		Websites
			\|-
	* Interfaces:		\| Interfaces \|\|

	Agent 10.1.10.52		Agent 10.1.10.52
			\|-
	* Macros:		\| Macros \|\|
			{$CERT.WEBSITE.HOSTNAME} = www.irgendwas.de<br>
	{$CERT.WEBSITE.HOSTNAME} = www.irgendwas.de

	{$WEBSITE.CHECK.HOSTADDRESS} = <nowiki>https://www.irgendwas.de</nowiki>		{$WEBSITE.CHECK.HOSTADDRESS} = <nowiki>https://www.irgendwas.de</nowiki>
			\|-
	Tags:		\| Tags \|\|
			contact: webmaster
	contact: webmaster ~~(moved to Templates)~~		\|}

	==Snippets==		==Snippets==

2025-07-16T08:35:06Z

@@ Line 211: / Line 211: @@
 '''In Zabbix'''
 # Enable Template: "Template App Apache by Zabbix agent"
 ==Snippets==

2023-04-01T19:06:09Z

Maintenance

← Older revision		Revision as of 19:06, 1 April 2023
Line 23:		Line 23:

	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		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


			login to the MySQL.

			Select your database (Which is used for zabbix)

			Run below commands (Please change the interval day as your requirement)

			DELETE FROM history_uint WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 35 DAY));

			DELETE FROM history WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 35 DAY));

			DELETE FROM trends_uint WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 35 DAY));

			DELETE FROM trends WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 35 DAY));

			DELETE FROM events WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 35 DAY));

			DELETE FROM alerts WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 35 DAY));

			In my case I am keeping only last 35 Days data, so change as per your requirement.

	==Configuration==		==Configuration==

2022-11-16T13:15:13Z

← Older revision		Revision as of 13:15, 16 November 2022
Line 10:		Line 10:
	* Download the right Zabbix Agent on/for the Client Machine: https://www.zabbix.com/de/download_agents and install.		* Download the right Zabbix Agent on/for the Client Machine: https://www.zabbix.com/de/download_agents and install.
	* Configure Zabbix Agent (Unix (like): "/etc/zabbix/zabbix_agent2.conf"; Windows (like): \Program Files\zabbix\zabbix_agentd.conf)		* Configure Zabbix Agent (Unix (like): "/etc/zabbix/zabbix_agent2.conf"; Windows (like): \Program Files\zabbix\zabbix_agentd.conf)
	* Set ~~COnfiguration~~ options:		* Set Configuration options:
	** Server=zabbix		** Server=zabbix
	** ServerActive=zabbix		** ServerActive=zabbix

2022-09-16T07:10:07Z

Configuration

2022-06-01T20:46:59Z

← Older revision		Revision as of 20:46, 1 June 2022
Line 269:		Line 269:
	\|<nowiki>TPL \| ZABBIX AGENT\| PASSIVE</nowiki>		\|<nowiki>TPL \| ZABBIX AGENT\| PASSIVE</nowiki>
	\|}		\|}



			https://blog.zabbix.com/support-of-whitelists-and-blacklists-for-metrics-on-agent-side/11878/

2022-05-02T06:29:57Z

2022-04-15T08:09:51Z

@@ Line 22: / Line 22: @@
 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
 ==Configuration==
@@ Line 32: / Line 30: @@
 Example:
   /etc/zabbix/zabbix_agentd.conf (Zabbix Agent)
   HostMetadata=win,vfx,psl,dus
@@ Line 38: / Line 37: @@
   /etc/zabbix/zabbix_agent2.conf (Zabbix Agent 2)
   HostMetadata=linux,websrv,psl,dus,247
 the following tags are predefined:
 {| class="wikitable"
 !Tag
@@ Line 138: / Line 139: @@
 |mariadb
 |MariaDB Service
 |}
-=== Template Groups/Template ===
+{country}.{city}.{location}.{floor}.{...drilldown to the device location}. Example:
-* The Template Group is a group of multiple templates that are linked to the Template Group.
+ de.dus.fs75.gf.kitchen
 ==Monitoring==
@@ Line 265: / Line 231: @@
   PSL | DUS | NS125 | FB | 1UG | vServer | PSLSRV15 (Preview Webserver)

2022-04-15T08:05:31Z

← Older revision		Revision as of 08:05, 15 April 2022
Line 11:		Line 11:
	* Configure Zabbix Agent (Unix (like): "/etc/zabbix/zabbix_agent2.conf"; Windows (like): \Program Files\zabbix\zabbix_agentd.conf)		* Configure Zabbix Agent (Unix (like): "/etc/zabbix/zabbix_agent2.conf"; Windows (like): \Program Files\zabbix\zabbix_agentd.conf)
	* Set COnfiguration options:		* Set COnfiguration options:

	** Server=zabbix		** Server=zabbix
	** ServerActive=zabbix		** ServerActive=zabbix
	** [[#Host_name\|Hostname]]={Hostname configured in Zabbix Server}		**[[#Host_name\|Hostname]]={Hostname configured in Zabbix Server}
	** [[#Tags\|HostMetadata]]		**[[#Tags\|HostMetadata]]

	* Restart Zabbix Service (e.g. service zabbix-agent2 restart) and debug with logfile (like): cat /var/log/zabbix/zabbix_agent2.log or \Program Files\zabbix2\zabbix_agent2.log		* Restart Zabbix Service (e.g. service zabbix-agent2 restart) and debug with logfile (like): cat /var/log/zabbix/zabbix_agent2.log or \Program Files\zabbix2\zabbix_agent2.log
Line 146:		Line 145:
	\|		\|
	\|}		\|}


			Location

			de.dus.fs75.gf.kitchen

	===Hostgroups===		===Hostgroups===