Case tblOperatingsystem.Version
    When '10.0.10240' Then '1507'
    When '10.0.10586' Then '1511'
    When '10.0.14393' Then '1607'
    When '10.0.15063' Then '1703'
    When '10.0.16299' Then '1709'
    When '10.0.17134' Then '1803'
    Else '?'
  End As Version

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tsysOS.OSname,
  tblOperatingsystem.Lastchanged,
  tsysOS.Image As icon,
  tblOperatingsystem.Version As Build,
  Version = Case tblOperatingsystem.Version
    When '10.0.10240' Then '1507'
    When '10.0.10586' Then '1511'
    When '10.0.14393' Then '1607'
    When '10.0.15063' Then '1703'
    When '10.0.16299' Then '1709'
    When '10.0.17134' Then '1803'
    When '10.0.17763' Then '1809'
    When '10.0.18362' Then '1903'
    Else '?'
  End,
  backgroundcolor = Case tblOperatingsystem.Version
    When '10.0.10240' Then '#f7f0ca'
    When '10.0.10586' Then '#f7f0ca'
    When '10.0.14393' Then '#f7f0ca'
    When '10.0.15063' Then '#f7f0ca'
    When '10.0.16299' Then '#f7f0ca'
    When '10.0.17134' Then '#f7f0ca'
    When '10.0.17763' Then '#d4f4be'
    When '10.0.18362' Then '#d4f4be'
    Else Case tsysOS.OSname
        When 'NT 3.51' Then '#e29c9c'
        When 'NT 4' Then '#e29c9c'
        When 'Win XP' Then '#e29c9c'
        Else '#f7caca'
      End
  End
From tblAssets
  Inner Join tblOperatingsystem On
    tblAssets.AssetID = tblOperatingsystem.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tsysOS.OSname Not Like 'Win 20%' And tblAssetCustom.State = 1
Order By Build,
  tblAssets.AssetUnique