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