SCCM – SQL Queries for Make, Model and Architectures of Devices
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:
These may also help you...
- How to Mass Unfollow on Instagram Online
- Windows Server 2008 R2 Evaluation Product Keys
- How to Mass Unfollow Everyone on Twitter
Count of all models
SELECT Model0 AS Model, COUNT(*) AS Count FROM v_GS_COMPUTER_SYSTEM GROUP BY Model0
Count of all makes
SELECT manufacturer0 AS Make, COUNT(*) AS Count FROM v_GS_COMPUTER_SYSTEM GROUP BY manufacturer0
Count of architectures
SELECT systemtype0 AS Architecture, COUNT(*) AS Count FROM v_GS_COMPUTER_SYSTEM GROUP BY systemtype0
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.