Recuerda, no borrar los comandos que se usan en lase definiciones de host, o para enviar notificaciones
DELETE FROM service WHERE id NOT IN (SELECT service_id FROM service_to_host)
DELETE FROM host_service_param WHERE service_id NOT IN (SELECT service_id FROM service_to_host)
DELETE FROM command WHERE id NOT IN (SELECT command_id FROM service) AND id NOT IN (15,5,287,253,103,4,104,3,43,22)
No hay comentarios:
Publicar un comentario