I have put a report together which tells me all of my SQL servers. It was working fine until I added tblProcessor to get Cores. Now I have duplicate entries in my report.
Does anyone know a way which I can reduce all this to only show each PC once?
I'm using the following statement:
Select Top 1000000 Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As
icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.NrProcessors As [# Of Processors],
tblProcessor.NumberOfCores,
tblProcessor.NumberOfLogicalProcessors,
tblAssets.Memory,
tblSqlServers.skuName As License,
tblSqlServers.displayVersion As Edition,
tsysOS.OSname As OS,
tblAssets.Username,
tblAssets.Userdomain,
tblSqlServers.serviceName As Service,
tsysIPLocations.IPLocation,
tblAssets.Description,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSqlServers On tblAssets.AssetID = tblSqlServers.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName,
Edition
