SCCM Report Query for Machine Make and Model Count

Reporting on Machine Make and Model Counts With a Configuration Manager Query

If you need a quick inventory breakdown of exactly what hardware makes and models exist across your estate — useful for hardware refresh planning or compatibility checks — Configuration Manager’s hardware inventory data makes this a simple SQL query against the site database.

SELECT Manufacturer0, Model0, COUNT(*) AS DeviceCount
FROM v_GS_COMPUTER_SYSTEM
GROUP BY Manufacturer0, Model0
ORDER BY DeviceCount DESC

This relies on the Computer System hardware inventory class being enabled (it is by default) and on clients having reported inventory recently — a machine that hasn’t checked in for a while, or has hardware inventory disabled at the client settings level, won’t show up or may show stale data. You can turn this straight into an SSRS report by creating a new report under Monitoring > Reporting > Reports in the console and using the query above as the dataset, which is handy if you want it refreshed and reviewable on a recurring basis rather than run ad hoc.

Still Current on Configuration Manager 2603 (Updated for 2026)

This query is unchanged on the current release of Configuration Manager (build 2603, current as of August 2026) — the v_GS_COMPUTER_SYSTEM hardware inventory view and the Computer System inventory class it relies on haven’t been restructured, so the query runs as-is against a current site database. One thing worth double-checking if your counts look low: hardware inventory classes can be individually enabled/disabled per client settings policy, and Configuration Manager’s default inventory schedule is still every 7 days, so a recent bulk hardware refresh may not be fully reflected until the next scheduled inventory cycle completes.

Resources

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