Windows 10 Version 1703 EOL

Find All Windows 10 Version 1703 Devices

Microsoft brings out new feature updates every few months to add additional features and improvements. Every Windows 10 version gets their own specific patches on Patch Tuesday, however, much like Windows 7, Windows 10 builds have a limited life span. Since the lifespan of Windows 10 version 1703 is close to its end, which means no more updates. We created this audit and a blog post about the Windows 10 version 1703 end of life.

The audit below provides you a list of all Windows 10, 1703 machines along with how long you have until the end of life date is hit. Since this date is set for October 9, 2019, you don't have long to update your Windows 10 versions.

Windows 10 Version 1703 EOL

Windows 10 Version 1703 EOL Query

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

Audit and Take Action in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting