Adobe Flash Player Version SCCM Report

SELECT
SYS.Netbios_Name0 AS Computer_Name,
SYS.AD_Site_Name0 AS AD_Site,
SP.CompanyName AS Publisher,
SP.ProductName, SF.FileName,
SF.FileSize,
SF.FileVersion,
SF.FilePath
FROM v_GS_SoftwareProduct SP INNER JOIN
v_GS_SoftwareFile SF ON SP.ResourceID = SF.ResourceID AND SP.ProductID = SF.ProductId INNER JOIN
v_R_System SYS ON SP.ResourceID = SYS.ResourceID
WHERE (SF.FileName = 'FlashPlayerApp.exe' ) AND (SP.CompanyName LIKE '%Adobe%' OR
SP.CompanyName LIKE '%Adobe%')
GROUP BY SP.CompanyName,
SP.ProductName,
SF.FileName,
SF.FileSize,
SF.FileVersion,
SF.FilePath,
SP.ProductVersion,
SYS.Netbios_Name0,
SYS.AD_Site_Name0
ORDER BY SYS.Netbios_Name0