SCCm Query Firefox Browser version

This Query can be use also in a SCCM report to show machine names and Firefox version installed:

*****************************************

SELECT     TOP (100) PERCENT dbo.v_R_System.Netbios_Name0, dbo.v_GS_SoftwareFile.FileName, dbo.v_GS_SoftwareFile.FileVersion,
                      dbo.v_GS_SoftwareFile.FilePath
FROM         dbo.v_GS_SYSTEM INNER JOIN
                      dbo.v_R_System ON dbo.v_GS_SYSTEM.ResourceID = dbo.v_R_System.ResourceID INNER JOIN
                      dbo.v_GS_SoftwareFile ON dbo.v_GS_SYSTEM.ResourceID = dbo.v_GS_SoftwareFile.ResourceID
WHERE     (dbo.v_GS_SoftwareFile.FilePath LIKE '%Program Files%' or
                      dbo.v_GS_SoftwareFile.FilePath LIKE '%Program Files (x86)%') and (dbo.v_GS_SoftwareFile.FileName like '%firefox.exe%')
ORDER BY dbo.v_R_System.Netbios_Name0

******************************************