Difference between revisions of "Zabbix sql queries"
Jump to navigation
Jump to search
(Created page with "``` delete from items where hostid=(select hostid from hosts where host='www.example.com'); ```") |
|||
| Line 1: | Line 1: | ||
``` | ``` | ||
delete from items where hostid=(select hostid from hosts where host='www.example.com'); | delete from items where hostid=(select hostid from hosts where host='www.example.com'); | ||
| + | delete from items where hostid=(select hostid from hosts where host='www.example.com') and itemid!=252623 and itemid!=253055; | ||
``` | ``` | ||
Revision as of 17:41, 18 May 2022
delete from items where hostid=(select hostid from hosts where host='www.example.com'); delete from items where hostid=(select hostid from hosts where host='www.example.com') and itemid!=252623 and itemid!=253055;