SCCM – SQL Queries for Make, Model and Architectures of Devices

System Center Configuration Manager SCCM

These simple SQL queries can be used to pull data from the Configuration Manager database to provide you with a count of all make, model and architecture devices in your business.


To get this information, open a new query within SQL Server Management Studio and copy and paste the query that you wish to run from the options below:


Count of all models

Count of all makes

Count of architectures

You can then use this data to produce Power BI or SSRS reports.


If you have any questions or feedback on this guide, please feel free to leave us a message in our comments section below.

Leave us a message...