Count of Installed Software Categories by Normalized Application name.

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

 
 

Leave a Reply

Your email address will not be published. Required fields are marked *