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

Node Details database table

Hi all,

does anyone know where the node details resource pulls its data from

specifically hardware and No Of Cpu's

I cant find these fields anywhere in the database

Labels (1)
0 Kudos
1 Reply
Level 13

Hi,

hardware information is stored in Nodes table. Number of CPUs is fetched directly from historical table, because it can change over time. It's not easy to get this information, but you can use this SQL command.

SELECT data.NodeID as NodeID, data.Caption, COUNT(data.CPUIndex) As NumberOfCPU from

(SELECT cpu.NodeID, cpu.CPUIndex, n.Caption, cpu.TimeStampUTC,

DENSE_RANK() OVER (PARTITION BY cpu.NodeID ORDER BY cpu.TimeStampUTC desc) AS [Rank]

FROM CPUMultiLoad cpu

INNER JOIN Nodes n ON cpu.NodeID = n.NodeID

) as data

where data.Rank = 1

GROUP BY data.NodeID, data.Caption