Find PCs having specific Model

Question

Hi,

I need to find all the pcs having core i3 processor through SCCM. Can someone guide me?

Thanks.

Answer 1

What do you have for a query now and what isn't working for you?

Answer 2

Hi @create share ,

Please try the following in SQL Server Management Studio to see if it is help,

1. Right-click the server instance in Object Explorer, and then select New Query
2. Enter the following query language into the query window SELECT
   DISTINCT(CPU.SystemName0) AS [System Name],
   CPU.Manufacturer0 AS Manufacturer,
   CPU.Name0 AS Name,
   COUNT(CPU.ResourceID) AS [Number of CPUs],
   CPU.NumberOfCores0 AS [Number of Cores per CPU],
   CPU.NumberOfLogicalProcessors0 AS [Logical CPU Count]
   FROM [dbo].[v_GS_PROCESSOR] CPU
   GROUP BY
   CPU.SystemName0,
   CPU.Manufacturer0,
   CPU.Name0,
   CPU.NumberOfCores0,
   CPU.NumberOfLogicalProcessors0
   having CPU.Name0 like 'Intel(R) Core(TM) i%'
   and convert(INT,SUBSTRING(CPU.Name0,len('Intel(R) Core(TM) i')+3,1))=3

3) Click "Execute" and check the result

---

If the response is helpful, please click "Accept Answer"and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

It did not work. I need to use Microsoft Endpoint Configuration Manager to get the list. I will ty the built-in hardware report in it after fixing the password problem of SQL.

Answer 4

I found a report in SCCM but it is not working due to some authentication problem because the password for sccm server was changed.

Thanks.