Zabbix One-Liners - Revision history

Busk at 23:30, 1 July 2021

2021-07-01T23:30:18Z

2021-06-26T00:58:07Z

2021-06-26T00:08:35Z

2021-06-25T23:57:51Z

2021-06-25T23:25:51Z

2021-06-25T22:37:54Z

Created page with "sudo -u postgres pg_dump -d zabbix --table public.interface | gzip -9 > zabbix.interface.sql.gz"

New page

sudo -u postgres pg_dump -d zabbix --table public.interface | gzip -9 > zabbix.interface.sql.gz

← Older revision		Revision as of 23:30, 1 July 2021
Line 19:		Line 19:

	zabbix_get -s host.example.com -p 10050 -k vm.memory.size[available] --tls-connect psk --tls-psk-identity foo1 --tls-psk-file ./foo1.psk		zabbix_get -s host.example.com -p 10050 -k vm.memory.size[available] --tls-connect psk --tls-psk-identity foo1 --tls-psk-file ./foo1.psk
		+
		+
		+	zabbix_get -s localhost -p 10050 -k vm.memory.size[available] --tls-connect psk --tls-psk-identity host.example.com --tls-psk-file 'C:\Program Files\Zabbix Agent\psk.key'
	```		```

@@ Line 1: / Line 1: @@
 sudo -u postgres pg_dump -d zabbix --table public.interface | gzip -9 > zabbix.interface.sql.gz
@@ Line 15: / Line 16: @@
 zabbix_agent -t vm.memory.size[free]
 zabbix_agentd -p

← Older revision		Revision as of 00:08, 26 June 2021
Line 8:		Line 8:

	UPDATE interface SET ip = '192.168.1.1', dns = 'example.com' WHERE hostid = 11111 AND main = 1;		UPDATE interface SET ip = '192.168.1.1', dns = 'example.com' WHERE hostid = 11111 AND main = 1;
		+
		+
		+	zabbix_get -s host.example.com -p 10050 -k vm.memory.size[free]
		+
		+
		+	zabbix_agent -t vm.memory.size[free]
		+	zabbix_agentd -p

← Older revision		Revision as of 23:57, 25 June 2021
Line 6:		Line 6:

	select * FROM interface INNER JOIN hosts ON interface.hostid = hosts.hostid AND interface.main <> 0 AND hosts.name = 'test';		select * FROM interface INNER JOIN hosts ON interface.hostid = hosts.hostid AND interface.main <> 0 AND hosts.name = 'test';
		+
		+	UPDATE interface SET ip = '192.168.1.1', dns = 'example.com' WHERE hostid = 11111 AND main = 1;

← Older revision		Revision as of 23:25, 25 June 2021
Line 1:		Line 1:
	sudo -u postgres pg_dump -d zabbix --table public.interface \| gzip -9 > zabbix.interface.sql.gz		sudo -u postgres pg_dump -d zabbix --table public.interface \| gzip -9 > zabbix.interface.sql.gz
		+
		+	DELETE FROM interface WHERE interface.main <> 1
		+
		+	select * FROM interface WHERE interface.hostid = (SELECT hostid from hosts WHERE hosts.name = 'test');
		+
		+	select * FROM interface INNER JOIN hosts ON interface.hostid = hosts.hostid AND interface.main <> 0 AND hosts.name = 'test';