SCCM Report That Counts Internet Explorer Versions 1

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 have passed 17 Microsoft certifications since then. My main expertise is on client management with Microsoft Endpoint Manager: Intune and Configuration Manager. I also do a lot of work on the security side with Microsoft Defender for Endpoint. In addition to my Microsoft certification, I also have an ITIL v3 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.