LOGPARSER #19: Browser types with most hits/used

  • Article

My #2 post gave you just browser types and hits, this script will give you you almost the same data but with percentage. Great for security checks etc.

SELECT
TO_INT(MUL(100.0,PROPCOUNT(*))) AS Percent,
COUNT(*) AS Hits,
cs(User-Agent) as Browser
INTO
UseragentsHits.txt
FROM
logs\iis\ex*.log
GROUP BY
Browser
ORDER BY
HITS
DESC

//Anders