ProgrammingWindows

Using Log Parser Studio To Find User Agents

Posted Steve Fenton

If you want to find out which user agents are used to visit your site, you can use the below query. You can use this to find out about browsers, and honest-ish robots (i.e. ones that identify themselves via the user agent).

SELECT
    cs(User-Agent),
    count(cs(User-Agent)) as requestcount
FROM '[LOGFILEPATH]'
WHERE date = '2016-08-02' 
GROUP BY cs(User-Agent) order by count(cs(User-Agent)) DESC

Remember to change the date when you run it.