Report tweek for OS?

[dawnlowery]

I have a report and was hoping to be able to add the OS version so that I could sort filter on Server OS. I tried adding the OS tables and that didn't work. Any ideas?

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tblSoftwareUni.OSType
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID,
tsysOS
Where tblAssetCustom.State = 1 And tblComputersystem.Domainrole > 1
Order By tblAssets.AssetName,
software,
version

[RCorbeil · Accepted solution]

You've included a references to tSysOS, but you haven't linked it to anything. If you join tblAssets.OSCode to tSysOS.OSCode, you can then refer to tSysOS.OSName (Win NT 4, Win 2003, Win 2012, etc.)