Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Discovery the HostID
- SELECT hostid FROM hosts WHERE host = 'servername';
- +--------+------------+
- | hostid | host |
- +--------+------------+
- | 10094 | servername |
- +--------+------------+
- 1 ROW IN SET (0.00 sec)
- # Remove Triggers FROM HostID 10094
- DELETE triggers
- FROM triggers
- LEFT JOIN functions ON triggers.triggerid=functions.triggerid
- LEFT JOIN items ON functions.itemid=items.itemid
- WHERE items.hostid=10094;
- # Remove Functions FROM HostID 10094
- DELETE functions
- FROM functions
- LEFT JOIN items ON functions.itemid=items.itemid
- WHERE items.hostid=10094;
- # Remove Itens FROM HostID 10094
- DELETE FROM items WHERE hostid=10094;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement