Difference between revisions of "Zabbix One-Liners"
Jump to navigation
Jump to search
| 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; | ||
Revision as of 23:57, 25 June 2021
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;