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
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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.