One of the ways to determine what version of IE is installed on a PC is to use software inventory. Although I’m not a big fan of software inventory, it does have its place, for example, if you need to ensure that everyone is running IE 10 or greater within your environment.
It can be very challenging to try and determine the actual version installed on a PC. You may be asking, what is the issue? Why can’t the T-SQL command (MAX) be used to determine the highest version of IE? The problem is that IE has a version number of 10.00.9200.16521 (win8_gdr_soc_ie.130216-2100). This version number is a string, not a number. Even if you trim the IE version number text to 10.00.9200.16521 to look like a number, it is still a string.
How do you filter the IE versions on a PC to determine the current IE version?
Using one of my PCs as an example, there are 30 versions of IE listed. Below is a small sample of some of the IE versions listed on this PC.
Back in 2008, John Nelson published a blog post on using a function to determine the version number. You can read his full post here. I have borrowed from John to show you how you can use this function to filter the IE versions on a PC.
In this webcast, I will show you how challenging it can be to determine the actual IE version installed on a PC, but by simply adjusting your query you will get the correct answers.
A copy of the two T-SQL queries that I use within the video can be downloaded:
If you have any questions, please feel free to contact me by sending a tweet to @Enhansoft.