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
select top 3
Manufacturer0,
Count(*)
from
dbo.v_GS_COMPUTER_SYSTEM
GROUP BY
Manufacturer0
Order by 2 desc