Audit: Windows Server with MS SQL - Include Windows OS Version, All SQL Edition, Model, CPU (Cores)

[Evgenii_Kazantc]

Select Top (1000000) tblAssets.AssetName [Name],
  tblAssets.AssetID,
  tsysOS.Image As icon,
  RTrim(LTrim(Coalesce(tblOperatingsystem.Caption, '') + ' ' +
  Coalesce(tblOperatingsystem.OtherTypeDescription, ''))) As [OS Version],
  tblSqlServers.displayVersion As [SQL Edition],
  tblSqlServers.skuName As [SQL License],
  tblSqlServers.spLevel As [SQL SP],
  tblAssetCustom.Model As [Model/Platform],
  tblAssets.Processor,
  tblAssets.NrProcessors,
  Sum(tblProcessor.NumberOfCores) As NumberOfCores
From tblComputersystem
  Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
  Inner Join tblOperatingsystem
    On tblAssets.AssetID = tblOperatingsystem.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tblSqlServers On tblAssets.AssetID = tblSqlServers.AssetID
  Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Group By tblAssets.AssetName,
  tblAssets.AssetID,
  tsysOS.Image,
  RTrim(LTrim(Coalesce(tblOperatingsystem.Caption, '') + ' ' +
  Coalesce(tblOperatingsystem.OtherTypeDescription, ''))),
  tblSqlServers.displayVersion,
  tblSqlServers.skuName,
  tblSqlServers.spLevel,
  tblAssetCustom.Model,
  tblAssets.Processor,
  tblAssets.NrProcessors,
  tblAssets.AssetUnique
Order By tblAssets.AssetName