I have a simple access log as a table in SQL Server, Access 2000 front end, Jet engine.
I am trying to filter out the entries that are just bot hits.
My SQL looks like this:
SELECT LOG.ACCESS_DATE, LOG.CLIENT_IP, LOG.QUERY_STRING, LOG.CLIENT_BROWSER
FROM ZZ_ACCESS_LOG as LOG
WHERE (LOG.CLIENT_BROWSER) NOT Like "%bot%";
I have also tried this with *. It doesn't make a difference. Either way, this only filters out some of the entries with "bot" in them. I think it gest tripped up by semicolons in the text. Here is an example of a string it failed to filter:
Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html
Can anyone explain what is happening to me, and how to fix it?