asked on

Best way to find IE version in SMS??? Help

I need to find out what versions of IE are running on my users systems. I'll run a report, but the problem is results returned will include incremental patched versions of IE. So for computer 'BobPC,' there will be 8 different results for one install of IE 6. It will be:

BobPC Internet Explorer Version 6.0.1309
BobPC Internet Explorer Version 6.0.1354
BobPC Internet Explorer Version 6.0.1366
BobPC Internet Explorer Version 6.0.1367
BobPC Internet Explorer Version 6.0.1372
BobPC Internet Explorer Version 6.0.1309

Its reporting six different versions of the same product-IE6. How can I set a query to show one result per system, just the major release version of IE and not multiple patched versions thereof?

I'm running the report by selecting 'Software.Products' by file name and version.

JonLambert

OK, I did this with the report "Comptuers with a specific prodcut name and version"

First off, clone the report giving the clone a new name, I called mine "Computers with a specific product name and version - LIKE" .. you'll see why in a sec.

In the properties of the report, change the SQL statement to read 'AND SP.ProductVersion LIKE @variable1' instead of 'AND SP.ProductVersion = @variable1'

Run the report, and instead of entering a specific version number, enter the major version number followed by a %, e.g.

Product Name: Windows Internet Explorer
Producti Version: 8%

This will return a report with all installations of IE 8, regardless of patch level.

ASKER CERTIFIED SOLUTION

NBquery

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

NBquery

ASKER

It worked for us.