lunes, 23 de mayo de 2011

Borrar los comandos, servicios de Nagios que no se usan

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