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.