Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2010-11-17
3
Medium Priority
?
1,118 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Problem Description: Actually I found the below issue with some customers after migration from SMS 2003 to SCCM 2007 and epically if they change site code, some clients may appear in the console with old site code, plus old sites still appearing …
Welcome to my series of short tips on migrations. Whilst based on Microsoft migrations the same principles can be applied to any type of migration. My first tip Migration Tip #1 – Source Server Health can be found here: http://www.experts-exchang…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

715 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