-- Delete records created by the Code Red and Nimba viruses
--
-- Review these queries before running them, it assumes a
-- more UNIX like web layout and that you have no files
-- that start with an underscore '_'

DELETE FROM log_entries where request like 'GET /default.ida%';
DELETE FROM log_entries where request like 'GET /MSADC/%';
DELETE FROM log_entries where request like 'GET /msadc/%';
DELETE FROM log_entries where request like 'GET /c/%';
DELETE FROM log_entries where request like 'GET /d/%';
DELETE FROM log_entries where request like 'GET /scripts/%';
DELETE FROM log_entries where request like 'GET /\\_%';
