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.