none
Report to show major Internet Explorer version

    Question

  • There's many posts relating to an accurate way of reporting on which version of Internet Explorer is being used by a PC. It is not made easy by the fact that some versions are recorded in Add/Remove programs, while other versions aren't, and there seems to be some dependency on whether it was installed with the O/S or later upgraded via WSUS etc etc.

    Here's the report I've creating (using file versions of iexplore.exe) - which works OK, but what I'd really like is if I could 'roll up' the results into a count of major versions. So instead of having seperate lines for 7.00.6000.16386 and 7.00.6000.17055 (for instance), it just gives me one line for v7, one for v8 etc.

    Any ideas how this could be achieved?

    #####################################################

    select
        FileName,
        FileVersion,
        @CollID as CollectionID,
        Count (Distinct SF.ResourceID)

    From
        dbo.v_GS_SoftwareFile SF

    JOIN v_FullCollectionMembership fcm on SF.ResourceID=fcm.ResourceID

    Where
        FileName = 'iexplore.exe'
    and
        FilePath like '%Internet Explorer%'
    and fcm.CollectionID=@CollID

    Group by
        FileName, FileVersion
    Order by
        FileVersion

     ##############################################################

    Friday, March 23, 2012 9:18 AM

Answers

  • Ops there is a typo in the query.

    select 
    	SF.FileName,
    	left(SF.FileVersion,1), 
    	@CollID as CollectionID, 
        Count (Distinct SF.ResourceID)
    From 
        dbo.v_GS_SoftwareFile SF 
    	JOIN v_FullCollectionMembership fcm on SF.ResourceID=fcm.ResourceID
    Where 
    	SF.FileName = 'iexplore.exe' 
    	and SF.FilePath like '%Internet Explorer%'
    	and fcm.CollectionID = @CollID
    Group by 
        SF.FileName, 
    	left(SF.FileVersion,1)
    Order by 
        2


    http://www.enhansoft.com/

    • Marked as answer by Hackmuss Friday, March 23, 2012 1:13 PM
    Friday, March 23, 2012 1:03 PM
    Moderator

All replies

  • Try this:

    select 
    	SF.FileName,
    	left(SF.FileVersion,1), 
    	@CollID as CollectionID, 
        Count (Distinct SF.ResourceID)
    From 
        dbo.v_GS_SoftwareFile SF 
    	JOIN v_FullCollectionMembership fcm on SF.ResourceID=fcm.ResourceID
    Where 
    	SF.FileName = 'iexplore.exe' 
    	and SF.FilePath like '%Internet Explorer%'
    	and fcm.CollectionID = @CollID
    Group by 
        SF.FileName, 
    	SF.FileVersion
    Order by 
        2


    http://www.enhansoft.com/

    Friday, March 23, 2012 12:18 PM
    Moderator
  • Thanks for the reply. That's not quite what I want. That just lists the first character of the file version - a useful tip though, thanks :-)

    What I want to do is effectively subtotal those - so all minor versions of each major version are counted together on one line of the report.

    So it would simply look like this (for example):

    File Name       Version     Count

    iexplore.exe     6             270

    iexplore.exe     7             46

    iexplore.exe     8              1046

    Friday, March 23, 2012 12:30 PM
  • Ops there is a typo in the query.

    select 
    	SF.FileName,
    	left(SF.FileVersion,1), 
    	@CollID as CollectionID, 
        Count (Distinct SF.ResourceID)
    From 
        dbo.v_GS_SoftwareFile SF 
    	JOIN v_FullCollectionMembership fcm on SF.ResourceID=fcm.ResourceID
    Where 
    	SF.FileName = 'iexplore.exe' 
    	and SF.FilePath like '%Internet Explorer%'
    	and fcm.CollectionID = @CollID
    Group by 
        SF.FileName, 
    	left(SF.FileVersion,1)
    Order by 
        2


    http://www.enhansoft.com/

    • Marked as answer by Hackmuss Friday, March 23, 2012 1:13 PM
    Friday, March 23, 2012 1:03 PM
    Moderator
  • Brilliant!!! I could kiss you, you gorgeous man!

    Friday, March 23, 2012 1:13 PM
  • Brilliant!!! I could kiss you, you gorgeous man!

    lol, I'm not sure that my wife would approve but I do accept beer.    :-)



    http://www.enhansoft.com/

    Friday, March 23, 2012 1:17 PM
    Moderator
  • Garth, I was wondering why there was an IE version of 1...then figured it out and changed the LEFT character to a 2, which works for IE 10 & 11, but of course now all the lower versions have a decimal point in the second character...is there a way to not show that?

    Thanks!

    Friday, January 03, 2014 8:29 PM
  • Plagiarized a bit--showing OS (trying to limit to only major version of that--could have used a CASE statement, I guess) as we have a requirement to only have certain version of IE on certain OS...

    select 
    	SF.FileName AS 'FILENAME',
    	LEFT (OSYS.Caption0, 20) AS 'OS',
    	left(SF.FileVersion,2) AS 'IE MAJOR VERSION', 
    	Count(Distinct SF.ResourceID) AS 'COUNT'
    	
    From 
        dbo.v_GS_SoftwareFile SF 
        JOIN dbo.v_R_System SYS ON SF.ResourceID = SYS.ResourceID
        JOIN dbo.v_GS_OPERATING_SYSTEM OSYS ON SF.ResourceID = OSYS.ResourceID
    	
    Where 
    	SF.FileName = 'iexplore.exe' 
    	and SF.FilePath like '%Internet Explorer%'
    	AND SYS.Client0 = '1'
    	AND SYS.Obsolete0 = '0'
    	AND SYS.Operating_System_Name_and0 LIKE '%workstation%'
    	AND OSYS.Caption0 IS NOT NULL
    	AND OSYS.Caption0 NOT LIKE '%(R)%'
    	AND OSYS.Caption0 NOT LIKE '%embedded%'
    	
    Group by 
        SF.FileName,
        LEFT (OSYS.Caption0, 20), 
    	left(SF.FileVersion,2)
    	
    Order by 
        CASE left(SF.FileVersion,2) WHEN '6.' THEN 0
    								WHEN '7.' THEN 1
    								WHEN '8.' THEN 2
    								WHEN '9.' THEN 3
    								WHEN '10' THEN 4
    								WHEN '11' THEN 5
    	END

    Friday, January 03, 2014 10:14 PM
  • Try this.

    http://tinyurl.com/lllhfe7


    http://www.enhansoft.com/

    Saturday, January 04, 2014 12:43 AM
    Moderator
  • Try this.

    http://tinyurl.com/lllhfe7


    http://www.enhansoft.com/

    Hey, thanks for this. However, I'm not getting anything when using it in a report, it's just blank. When trying it as a query, there's an indication that there is a syntax error. Any ideas?
    Tuesday, February 25, 2014 5:33 PM
  • Have you enabled SW Inventory? Without it this query will not work.

    http://www.enhansoft.com/

    Tuesday, February 25, 2014 6:38 PM
    Moderator
  • Have you enabled SW Inventory? Without it this query will not work.

    http://www.enhansoft.com/

    Thanks for getting back to me. We had SW inventory enabled, but I didn't realize IE needed to have the exe inventoried. After getting it inventoried the report ran correctly. Funny how an MS application can't even be inventoried correctly using another MS application, though. 
    Thursday, March 06, 2014 4:32 PM
  • Your report is extremely handy, but i was wondering if its possible to have it also pull the machine names. I have searched in multiple places but i am not able to find a query that will provide the system names and the version of IE the system is running. Your help is greatly appreciated
    • Edited by A Estrada Thursday, November 13, 2014 10:54 PM
    Thursday, November 13, 2014 10:54 PM
  • Your report is extremely handy, but i was wondering if its possible to have it also pull the machine names. I have searched in multiple places but i am not able to find a query that will provide the system names and the version of IE the system is running. Your help is greatly appreciated

    There is a better way to collect IE versions.

    http://www.mnscug.org/blogs/sherry-kissinger/330-internet-explorer-version-information-via-hardware-inventory


    Garth Jones | My blogs: Enhansoft and Old Blog site | Twitter: @GarthMJ

    Thursday, November 13, 2014 11:01 PM
    Moderator
  • Thanks Garth but this seems to be a overkill. Here is what i was hoping for, a report to list computers showing name and the version of IE they are running. I am sure we could use the provided script once i get more familiar with SSCM but right now I am to new at SSCM to adapt this script for our environment.
    Thursday, November 13, 2014 11:31 PM
  • Thanks Garth but this seems to be a overkill. Here is what i was hoping for, a report to list computers showing name and the version of IE they are running. I am sure we could use the provided script once i get more familiar with SSCM but right now I am to new at SSCM to adapt this script for our environment.

    Your clients will thank you when you implement the MOF edit.

    http://be.enhansoft.com/post/2013/10/03/Slow-Software-Inventory-Cycle-in-SCCM-2012.aspx


    Garth Jones | My blogs: Enhansoft and Old Blog site | Twitter: @GarthMJ

    Friday, November 14, 2014 4:03 PM
    Moderator