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.
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.
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.
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.
9 people are following this question.