Sql – Extracting Browser from user agent in SQL

sqluseragent

I have a database of user agents that I need extract all of the unique browsers from in SQL. The field is like…

Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.8) Gecko/20100722 Firefox/3.6.8
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)
Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; GTB6; InfoPath.2; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; OfficeLiveConnector.1.3; OfficeLivePatch.0.0; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET CLR 1.1.4322)
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)

I was wondering if anyone had done anything like this before or knew of a good resource online to assist with this.

Best Answer

It's called Browser Fingerprinting; there's a lot of info around the web. I don't have any great source offhand though. You need more than just the user-agent to get a good fingerprint, but it's a good start.

These tactics are great for data-mining trends and such; but don't work very well for actually personally identifying a computer. This site will even tell you how unique you're browser is.

Related Topic