SCCM report for Computer make, model and count

This report provides computer manufacture name, model and number of machines in the environment.

**************************************************************

SELECT     Manufacturer0, Model0, Count(Model0) AS 'Count'

FROM         dbo.v_GS_COMPUTER_SYSTEM

GROUP BY Manufacturer0,Model0

ORDER BY Model0

***************************************************************

More SCCM custom reports can be found here