Count of Installed Software Categories by Family and Category Names

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

Leave a Reply

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