yay and I figured out how to merge the OS Columns
🙂SELECT TOP (1000000)
dbo.tblAssets.AssetName,
dbo.tblAssetCustom.Model,
dbo.tblAssetCustom.Serialnumber,
coalesce(dbo.tsysOS.OSname,dbo.tblVmwareInfo.Version,'Unknown') AS OSVersion,
dbo.tblAssets.AssetID
FROM dbo.tblAssets INNER JOIN
dbo.tblAssetCustom ON dbo.tblAssets.AssetID = dbo.tblAssetCustom.AssetID LEFT OUTER JOIN
dbo.tblVmwareInfo ON dbo.tblAssets.AssetID = dbo.tblVmwareInfo.AssetID LEFT OUTER JOIN
dbo.tsysOS ON dbo.tblAssets.OScode = dbo.tsysOS.OScode
WHERE (dbo.tblAssetCustom.Model LIKE '%poweredge%')
ORDER BY dbo.tblAssetCustom.Model