Solved

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

Posted on 2010-11-17
3
1,097 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

Are your corporate email signatures appalling?

Is it scary how unprofessional your email signatures look? Do users create their own terrible designs and give themselves stupid job titles? You can make this a lot easier for yourself by choosing an email signature management solution from Exclaimer today.

Join & Write a Comment

Suggested Solutions

Case Summary: In this Article we introduce the new method to configure the default user profile using Automated profile copy with sysprep rather than the old ways such as the manual copy of a configured profile to default user profile Old meth…
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…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now