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.

Instructions

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:

Queries

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.

Feedback

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


You might also like...

Leave us a message...

This site uses Akismet to reduce spam. Learn how your comment data is processed.