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