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.