cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 7

Getting processor count

I'm looking for a way to get processor count. I've already found a query that'll return CPU count which includes all the cores

SELECT N.Caption, COUNT(DISTINCT CPUIndex)

FROM CPUMultiLoad_Detail CPU WITH(NOLOCK)

JOIN Nodes N ON CPU.NodeID = N.NodeID

GROUP BY

N.Caption

Order By

N.Caption

But instead of cores I need to know the physical processors. I can see the processors in the node details for each server, but I'm not sure where it's stored or how I'd write up the SQL query to get them.

1 Reply
Level 10

Did you ever get any answer from Solar Winds on this?  I am faced with the same dilema in my org.

0 Kudos