log parser webstats query that filters out agents identifying as %bot% and arcgis traffic - Cacher Snippet

10/12/2017 - 11:53 AM

log parser webstats query that filters out agents identifying as %bot% and arcgis traffic

log parser webstats query that filters out agents identifying as %bot% and arcgis traffic

mapserver-log-parser-w3c-log-query.md

Rendered
Source

SELECT date, time, cs(User-Agent), cs(Referer) FROM '[LOGFILEPATH]'
--WHERE cs-uri-stem = '/ima/'
AND cs(Referer) NOT LIKE 'https://www.arcgis.com%'
AND cs(User-Agent) NOT LIKE '%bot%'