Caution: These scripts will take some time to run on large logs. Reference: User-Agent – Browser User-Agent – Device
Log Parser Studio is a great free tool from Microsoft TechNet Gallery that allows you to run SQL statements against Log files. This tool is available as a Zip file, once extracted open “LPS.exe”. Two examples are below but there is also a category (Code – SQL – Log Parser Studio) for more detailed queries.