Count of Manufacturers July 8, 2012 Posted by Garth Jones For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/4e4019b0-a28e-4637-ae8c-4ff523d11c1a select top 3 Manufacturer0, Count(*) from dbo.v_GS_COMPUTER_SYSTEM GROUP BY Manufacturer0 Order by 2 desc Updated: November 30, 2018 at 5:37 pm Tags: CM07, CM12, Code, ConfigMGr, SQL, vNext ◀ How to find an application installed in the last 7 days Four reports to answer questions within the reporting forums ▶ Leave a Reply Cancel replyYour email address will not be published. Required fields are marked *Comment Name * Email * Website