Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblOperatingsystem.Caption As OS,
  tblAssets.Version,
  Case
    When tblAssets.Version < '1703' Then 'EOL'
    When tblAssets.Version = '1703' And (tblOperatingsystem.Caption Like
      '%Home%' Or tblOperatingsystem.Caption Like '%Pro%') Then 'EOL'
    When tblAssets.Version = '1703' And (tblOperatingsystem.Caption Like
      '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') Then 'EOL in ' + EOL.Days +
      ' days'
    When EOL.Days Is Null Then 'Rescan asset'
  End As Status,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  Case
    When EOL.Days > 0 And EOL.Days <= 90 Then '#ffd152'
    When EOL.Days <= 0 Then '#ffadad'
    Else '#ffadad'
  End As backgroundcolor
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets.LocationID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tblOperatingsystem On tblOperatingsystem.AssetID =
    tblAssets.AssetID
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Left Join (Select Top 1000000 tblAssets.AssetID,
        Case
          When tblAssets.Version < '1703' Then '-1'
          When tblAssets.Version = '1703' And (tblOperatingsystem.Caption Like
            '%Enterprise%' Or
            tblOperatingsystem.Caption Like '%Education%') Then
            Cast(DateDiff(DAY, GetDate(), '2019-10-08') As nvarchar)
          When tblAssets.Version = '1703' And (tblOperatingsystem.Caption Like
            '%Home%' Or
            tblOperatingsystem.Caption Like '%Pro%') Then Cast(DateDiff(DAY,
            GetDate(), '2018-10-09') As nvarchar)
        End As Days
      From tblAssets
        Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
        Inner Join tsysAssetTypes On tsysAssetTypes.AssetType =
          tblAssets.Assettype
        Inner Join tblState On tblState.State = tblAssetCustom.State
        Inner Join tblOperatingsystem On tblOperatingsystem.AssetID =
          tblAssets.AssetID
        Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
      Where tblState.Statename = 'Active' And tsysOS.OSname = 'Win 10'
        And tblAssets.Version <= '1703') As EOL On
    EOL.AssetID = tblAssets.AssetID
Where tblAssets.Version <= '1703' And tblState.Statename = 'Active' And
  tsysOS.OSname = 'Win 10'
Order By tblAssets.Domain,
  tblAssets.AssetName