question

createshare-7115 avatar image
0 Votes"
createshare-7115 asked GarthJones-8673 commented

Find PCs having specific Model

Hi,

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

Thanks.

mem-cm-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

createshare-7115 avatar image
0 Votes"
createshare-7115 answered GarthJones-8673 commented

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Exactly what is the error? Where are you seeing the error?

0 Votes 0 ·
createshare-7115 avatar image
0 Votes"
createshare-7115 answered Garth commented

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

What didn't work? What exactly did you get for an error?

0 Votes 0 ·
HanyunZhu-MSFT avatar image
0 Votes"
HanyunZhu-MSFT answered HanyunZhu-MSFT commented

Hi @createshare-7115,

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.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@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.

0 Votes 0 ·
Garth avatar image
0 Votes"
Garth answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.