Need a Report Displaying # of Processor Cores on Servers

[pwalach]

I am trying to determine how many processor cores are in the CPU of each of our servers in our school district, here is what I have, but it's not displaying any results, any help would be great:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tsysOS.Image As icon,
tblAssets.Processor,
tblProcessorHist.NumberOfCores
From tblComputersystem
Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblProcessorHist On tblAssets.AssetID = tblProcessorHist.AssetID
Where tblAssetCustom.State = 1 And tblComputersystem.Domainrole > 1
Order By tblAssets.AssetName

[Daniel_B · Accepted solution]

You used tblProcessorHist, which will only have entries if there were any changes in the processor configuration of your servers. Replace it with tblProcessor and you should be fine.

Note: The number of processors can also be found in tblAssets.NrProcessors

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tsysOS.OSname,
  tsysOS.Image As icon,
  tblAssets.Processor,
  tblProcessor.NumberOfCores As NumberOfCores1,
  tblAssets.NrProcessors
From tblComputersystem
  Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Where tblAssetCustom.State = 1 And tblComputersystem.Domainrole > 1
Order By tblAssets.AssetName