Hi Guys,
I created report for soalrwinds server inventory for number of cpu's, CPU_Model or number of cores.
i wrote one sql query for number of CPu's but unable to write the CPU_Model. please find the below details and could you please provide the query for CPU_Model.
Select N.NodeID, N.Caption, IP_Address, Status, COUNT(DISTINCT CPUIndex) As "Number Of Cores"
FROM CPUMultiLoad_Detail CPU WITH(NOLOCK)
JOIN Nodes N ON CPU.NodeID = N.NodeID
GROUP BY
N.NodeID, N.Caption, IP_Address, Status
Order By
N.Caption, IP_Address, Status
Please provide the query for Number of CPU's and CPU model and number of cores.
this is sufficient for server inventory ? please provide those query details
we are creating the query from report writer tool.
Thanks and Regards,
Krish.