Count of Manufacturers

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

Leave a Reply

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