At tis point, since you probably have many entries, using SQL is probably best. I regularly run one like this to get rid of the 'bad' stuff
delete from Log where 1=1 and ( PageUrl like '%.php%' or PageUrl like '%wp-%' or PageUrl like '%bitcoin%' or PageUrl like '%.asp%' or PageUrl like '%/wp/%' or PageUrl like '%wordpress%' or PageUrl like '%wp-%' or PageUrl like '%joomla%'
or PageUrl like '%apple-touch-icon%' or PageUrl like '%.jsp%' or PageUrl like '%cgi-bin' or PageUrl like '%cgi-sys%' or PageUrl like '%.well-known%' or PageUrl like '%wallet%' )
Thank you guys, we already filtered urls with our CDN so our log is pretty clean but good advice! I'll try to clean up "info type" entry, keeping just errors and...fingers crossed.
BTW, it's weird, we're talking about 8k record... it should work. :(
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.