|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.