SCCM Report That Counts Internet Explorer Versions

I wanted a report in SCCM that shows the ammunt of of internet explorer versions I have, and see that for each operation system.

This report includes the following fields:

  • Filename (iexplore.exe)
  • OS
  • IE Major Versoin
  • Count

Here is the SQL query needed.

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

You need software inventory enabled for this report to work.

Anders Rødland

Anders Rødland started his IT career in 2006. My main focus is MS Configuration Manager and client management, and I currently hold active 15 Microsoft certifications. Certified on Windows Server, Windows Client, SQL, Exchange and System Center Configuration Manager. Anders Rødland also holds an ITIL Foundation certification.This is my private blog and do not represent my employer. I use this to share information that I find useful. Sharing is caring.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.