Configuration Manager SQL Query: Reporting Machine Count by Manufacturer

If you want to report on the number of machines per manufacturer in your Configuration Manager environment, you can run this query directly against your SQL database or use it as the basis for an SSRS report.

The Query

SELECT CS.Manufacturer0 AS Manufacturer, COUNT(CS.ResourceID) AS DeviceCount FROM v_GS_COMPUTER_SYSTEM CS GROUP BY CS.Manufacturer0 ORDER BY DeviceCount DESC

This groups every device reporting hardware inventory by its Manufacturer0 field and counts them, giving you a quick breakdown of your estate by hardware vendor.

Using It

Run it directly in SQL Server Management Studio against your ConfigMgr site database (CM_<sitecode>), or drop it into a new SSRS report as the dataset query if you want it as a recurring, refreshable report in the console. Results only include machines that have reported hardware inventory recently, and manufacturer strings can sometimes be inconsistent (different capitalisation or trailing whitespace from different BIOS vendors), so you may want to add a TRIM()/normalisation step if you see the same manufacturer split across multiple rows.

Still Current on Configuration Manager 2603 (Updated for 2026)

v_GS_COMPUTER_SYSTEM and its Manufacturer0 field are unchanged on current Configuration Manager (2603, the same current-branch version already confirmed in earlier posts), so this query runs as-is against a current site database. If you’re building a fuller hardware-inventory dashboard, the same view also carries a Model0 field alongside Manufacturer0 — pairing the two in the GROUP BY gets you a manufacturer-and-model breakdown in one query rather than manufacturer alone.

Resources

• query
• How to create a Configuration Manager Report using SSRS
• WQL
• our SQL & WQL query library