SELECT ISC.NormalizedName, ISC.NormalizedVersion, Count(ISC.NormalizedVersion) AS ‘Count’

FROM v_GS_Installed_Software_Categorized ISC

GROUP BY ISC.NormalizedName, ISC.NormalizedVersion

ORDER BY ISC.NormalizedName, ISC.NormalizedVersion