Solved

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

Posted on 2010-11-17
3
1,106 Views
Last Modified: 2013-11-21
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.
0
Comment
Question by:NBquery
  • 2
3 Comments
 
LVL 10

Expert Comment

by:JonLambert
ID: 34185450
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.
0
 

Accepted Solution

by:
NBquery earned 0 total points
ID: 34857270
We just refined the query to look only in the program files folder in XP.
0
 

Author Closing Comment

by:NBquery
ID: 34886442
It worked for us.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Win 2008 :  Allow RDP connection to user 5 67
Microsoft Audit question 13 61
*** Hardware Malfunction Dell T610 7 87
ADMT 3.2 LAB Computer Migration not successful 2 53
This is my 3rd article on SCCM in recent weeks, the 1st (http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Windows_Server_2008/A_4466-A-beginners-guide-to-installing-SCCM2007-on-Windows-2008-R2-Server.html) dealing with installat…
Know what services you can and cannot, should and should not combine on your server.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question