Jul 15, 2013 · SCCM report Query for Computer Manufacturer, Model and total number of machines The following query gives details of computer Manufacturer, model and total number of machines in the environment. SELECT Manufacturer0, Model0, Count(Model0) AS 'Count' The #1 SQL Server community and education site, with articles, news, forums, scripts and FAQs. 2007 chevy silverado 1500 fuel pump control module programming