Zabbix sql queries - Revision history

Busk at 02:07, 25 July 2023

2023-07-25T02:07:06Z

2023-07-24T23:45:53Z

2022-10-01T16:35:11Z

2022-10-01T16:34:39Z

2022-05-18T17:41:28Z

2022-05-18T15:58:22Z

Created page with "``` delete from items where hostid=(select hostid from hosts where host='www.example.com'); ```"

New page

```
delete from items where hostid=(select hostid from hosts where host='www.example.com');
```

@@ Line 44: / Line 44: @@
 ```
 select items.itemid, items.hostid, items.name, hosts.name, hosts.hostid from items inner join hosts on items.hostid = hosts.hostid join hosts_groups on items.hostid = hosts_groups.hostid where items.name='Physical disks discovery' and hosts_groups.groupid=293;
 ```

@@ Line 38: / Line 38: @@
 LIMIT 1;
 -- ORDER BY priority DESC;
 ```

@@ Line 37: / Line 37: @@
+)
 LIMIT 1;
 ```

@@ Line 2: / Line 2: @@
 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;
 ```