SQL Report

[skruser]

I'm needing to create a SQL report that displays the following.

Assetname
Domain
OSname
Edition
License
Number of Processors
Number of Cores
Last Tried
Last Changed

Before when I tried creating and running a custom report and included the license, it would error out and tell me no results were found.

Thanks!

skruser

[Hemoco · Accepted solution]

Please use the following report:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysOS.OSname,
tblSqlServers.displayVersion,
tblAssets.Lasttried,
tblAssetCustom.Lastchanged,
tblAssets.NrProcessors,
Sum(tblProcessor.NumberOfCores) As [nr of cores],
tblSqlLicenses.Name As license
From tblAssets
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblSqlServers On tblAssets.AssetID = tblSqlServers.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Left Join tblSqlSubServers On tblAssets.AssetName = tblSqlSubServers.AssetName
Left Join tblSqlLicenses On tblSqlLicenses.LicenseID =
tblSqlSubServers.LicenseID
Group By tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysOS.OSname,
tblSqlServers.displayVersion,
tblAssets.Lasttried,
tblAssetCustom.Lastchanged,
tblAssets.NrProcessors,
tblSqlLicenses.Name