Server OS version report

[chads]

Trying to get a Server OS version report as it doesn't show up on the all Microsoft Report.

i found this old code but it doesn't work anymore.

Select Top 1000000 dbo.tblComputers.Computername,
  dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain, Web40OSName.OSname,
  tblOperatingsystem.Description, dbo.tblComputersystem.Lastchanged,
  Web40OSName.Compimage As icon, tblOperatingsystem.Caption,
  tblOperatingsystem.OtherTypeDescription
From dbo.tblComputersystem Inner Join
  dbo.tblComputers On dbo.tblComputersystem.Computername =
    dbo.tblComputers.Computername Inner Join
  dbo.web40ActiveComputers On dbo.tblComputers.Computername =
    dbo.web40ActiveComputers.Computername Inner Join
  Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername
  Inner Join
  tblOperatingsystem On dbo.tblComputers.Computername =
    tblOperatingsystem.Computername
Where dbo.tblComputersystem.Domainrole > 1
Order By dbo.tblComputers.Computer

Any help for updated code?

[chads]

Yes thank you

[LanSweepUser · Accepted solution]

is this what you need ?

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Description,
tblOperatingsystem.Caption,
tblOperatingsystem.Version
From tblComputersystem
Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Where tblComputersystem.Domainrole > 1 And tblAssetCustom.State = 1
Order By tblAssets.AssetName