CPU Report with Hyper-thread --

[TRC_System_Admi]

Hello,

Is it possible to have a column to show if the CPU is hyper threaded?

Also I can not find where I can add a column to show how many Physical CPU sockets are in the server.

Name----Sockets--CPS---HT----Total Threads
SRV1-------2----------2-----Y-----------8

Also when I add tblProcessor My servers now list on separate lines any way to get the above to just list on one line?

[TRC_System_Admi · Accepted solution]

Support@lansweeper.com sent me the below SQL.

Though it's a bit off when you have multiple sockets when displaying the total threads.

I'm just going to use custom fields and manually type the data in.

Hope the below helps someone out.

Select Distinct Top (1000000) tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblOperatingsystem.Caption,
tblAssets.IPAddress,
tblAssets.Mac,
tblAssets.Processor,
tblAssets.NrProcessors,
Case
When tblProcessor.NumberOfLogicalProcessors > tblProcessor.NumberOfCores
Then 'yes' Else 'no' End As hyperthreading,
tblProcessor.NumberOfLogicalProcessors As ['total threads'],
tblProcessor.NumberOfCores,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID