Zabbix One-Liners

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

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


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'