SELECT ISC.FamilyName, ISC.CategoryName, Count(ISC.CategoryName) AS ‘Count’ FROM v_GS_Installed_Software_Categorized ISC GROUP BY ISC.FamilyName, ISC.CategoryName ORDER BY ISC.FamilyName Posted Jun 18 2007, 07:49 AM by Garth with no comments Filed under: SQL, SMS, Code, System Center