cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Evgenii_Kazantc
Engaged Sweeper II

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
0 REPLIES 0