Required solarwinds report containing CPU count and processor count on each node

I think you may need to add a join to AssetInventory_Processor to get the number of cores:

Thanks Much Terry
We are facing challenge to connect the AssetInventory_Processor.NumberOfCores to the SQL existing query.
Also I seeked help from our SQL team.

But we are unable to find solution to this.

If you have any sample query similar, kindly share us the syntax.

Thanks Again !

Try this:

Select N.NodeID, N.Caption, IP_Address,   Status,  COUNT(DISTINCT CPUIndex) As "Number Of CPU", NumberOfCores as "Number of Cores"

FROM CPUMultiLoad_Detail CPU WITH(NOLOCK)

JOIN Nodes N ON CPU.NodeID = N.NodeID

JOIN AssetInventory_Processor A ON CPU.NodeID = A.NodeID

GROUP BY

N.NodeID, N.Caption, IP_Address,  Status, NumberofCores

Order By

N.Caption, IP_Address,  Status

CPUCount was added to the nodes table in a recent release, you shouldn't need to join anything anymore

Dear Terry,

Thanks much for helping me.

It worked !!!!

Thanks again