Hi,
I need to find all the pcs having core i3 processor through SCCM. Can someone guide me?
Thanks.
Hi,
I need to find all the pcs having core i3 processor through SCCM. Can someone guide me?
Thanks.
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.
@createshare-7115 , Hope things are going well. I am writing to see if there's any update on our issue. If yes, feel free to let us know.
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.
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.
9 people are following this question.