Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2010-11-17
3
Medium Priority
?
1,126 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

After having deployed hundreds of thousands of Terminal Services seats worldwide, I still see all the time people asking me that same old question: "If TS/RDS is that reliable why are you telling me I should reboot it that often? My DC/SQL/Exchange/…
Some time ago I faced the need to use a uniform folder structure that spanned across numerous sites of an enterprise to be used as a common repository for the Software packages of the Configuration Manager 2007 infrastructure. Because the procedu…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Loops Section Overview
Suggested Courses

564 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