Count of Installed Software Categories by Normalized publisher name.

SELECT ISC.NormalizedPublisher, Count(ISC.NormalizedPublisher) AS ‘Count’

FROM v_GS_Installed_Software_Categorized ISC

GROUP BY ISC.NormalizedPublisher

ORDER BY ISC.NormalizedPublisher

 

I still like how even though the name is normalized that there are still server Microsoft entries within the “normalized” output. You would have though that they would have fixed that for themselves.
 

Leave a Reply

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