This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Community FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

End of Life Asset Report

djbradley
Engaged Sweeper II

‎05-10-2021 08:26 PM

Hello - the Lansweeper article at https://www.lansweeper.com/eol/are-you-prepared-for-windows-10-end-of-life/?utm_source=rss&utm_medium=rss&utm_campaign=are-you-prepared-for-windows-10-end-of-life states that Feature Update 1909 for Enterprise version goes EOL on May 11, 2021 (tomorrow).

However, if I read this article correctly - https://docs.microsoft.com/en-us/windows/release-health/release-information
It says that Feature Update 1909 Enterprise and Education versions goes EOL on May 10, 2022 which is one year from now.

Which one is correct? I would tend to think the article for Microsoft is correct.
Labels:
5 REPLIES 5
djbradley
Engaged Sweeper II

‎05-11-2021 05:09 PM

Thank you and I will definitely use this report.
0 Kudos
Hendrik_VE
Champion Sweeper III

‎05-11-2021 03:18 PM

Btw, this report should give you a quite accurate overview of the Windows Lifecycle (for most common versions).
Should you find any mistakes in this report, please let me know 🙂

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblOperatingsystem.Caption As OS,
  tblOperatingsystem.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'
    When '10.0.18363' Then '1909'
    When '10.0.19041' Then '2004'
    When '10.0.19042' Then '20H2'
    Else ''
  End As 'Win 10 Release',
  Case
    When tblOperatingsystem.Caption Like '%2000%' Then 'EOL'
    When tblOperatingsystem.Version = '10.0.10240' And
      tblOperatingsystem.Caption Not Like '%LTS%' Then 'EOL'
    When tblOperatingsystem.Version = '10.0.10586' Then 'EOL'
    When tblOperatingsystem.Version = '10.0.14393' And
      tblOperatingsystem.Caption Not Like '%LTS%' And
      tblOperatingsystem.Caption Not Like '%2016%' Then 'EOL'
    When tblOperatingsystem.Version = '10.0.15063' Then 'EOL'
    When GetDate() >= '2019-04-09' And tblOperatingsystem.Version = '10.0.16299'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then 'EOL'
    When GetDate() >= '2020-10-13' And tblOperatingsystem.Version = '10.0.16299'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then 'EOL'
    When GetDate() >= '2019-11-12' And tblOperatingsystem.Version = '10.0.17134'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then 'EOL'
    When GetDate() >= '2021-05-11' And tblOperatingsystem.Version = '10.0.17134'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then 'EOL'
    When GetDate() >= '2020-11-10' And tblOperatingsystem.Version = '10.0.17763'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then 'EOL'
    When GetDate() >= '2021-05-11' And tblOperatingsystem.Version = '10.0.17763'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then 'EOL'
    When GetDate() >= '2020-12-08' And tblOperatingsystem.Version = '10.0.18362'
    Then 'EOL'
    When GetDate() >= '2021-05-11' And tblOperatingsystem.Version = '10.0.18363'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then 'EOL'
    When GetDate() >= '2022-05-10' And tblOperatingsystem.Version = '10.0.18363'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then 'EOL'
    When GetDate() >= '2021-12-14' And tblOperatingsystem.Version = '10.0.19041'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%' Or
      tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then 'EOL'
    When GetDate() >= '2022-05-10' And tblOperatingsystem.Version = '10.0.19042'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then 'EOL'
    When GetDate() >= '2023-05-09' And tblOperatingsystem.Version = '10.0.19042'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then 'EOL'
    When GetDate() >= '2020-01-14' And (tblOperatingsystem.Caption Like '%2008%'
      Or tblOperatingsystem.Caption Like '%Windows 7%') Then 'EOL'
    When GetDate() >= '2029-01-09' And tblOperatingsystem.Caption Like
      '%Server 2019%' Then 'EOL'
    When GetDate() >= '2027-01-12' And tblOperatingsystem.Caption Like
      '%Server 2016%' Then 'EOL'
    When GetDate() >= '2023-10-10' And tblOperatingsystem.Caption Like
      '%Server 2012%' Then 'EOL'
    When GetDate() >= '2023-01-10' And tblOperatingsystem.Caption Like
      '%Windows 8%' Then 'EOL'
    When GetDate() >= '2025-10-14' And tblOperatingsystem.Version = '10.0.10240'
      And tblOperatingsystem.Caption Like '%LTS%' Then 'EOL'
    When GetDate() >= '2026-10-13' And tblOperatingsystem.Version = '10.0.14393'
      And tblOperatingsystem.Caption Like '%LTS%' Then 'EOL'
    When GetDate() >= '2029-01-09' And tblOperatingsystem.Version = '10.0.17763'
      And tblOperatingsystem.Caption Like '%LTS%' Then 'EOL'
    When GetDate() >= '2020-10-13' And tblOperatingsystem.Version = '6.1.7601'
      And tblOperatingsystem.Caption Like '%Embedded%' Then 'EOL'
    When tblOperatingsystem.Caption Is Null Then 'Rescan Asset'
    Else 'Supported'
  End As Status,
  Case
    When GetDate() > '2019-01-01' And GetDate() < '2025-10-14' And
      tblOperatingsystem.Version = '10.0.10240' And
      tblOperatingsystem.Caption Like '%LTS%' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2025-10-14') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2026-10-13' And
      tblOperatingsystem.Version = '10.0.14393' And
      tblOperatingsystem.Caption Like '%LTS%' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2026-10-13') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2029-01-09' And
      tblOperatingsystem.Version = '10.0.17763' And
      tblOperatingsystem.Caption Like '%LTS%' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2029-01-09') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2019-10-08' And
      tblOperatingsystem.Version = '10.0.15063' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2019-10-08') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2020-10-13' And
      tblOperatingsystem.Version = '10.0.16299' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2020-10-13') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2019-11-12' And
      tblOperatingsystem.Version = '10.0.17134' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2019-11-12') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2021-05-11' And
      tblOperatingsystem.Version = '10.0.17134' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2021-05-11') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2020-11-10' And
      tblOperatingsystem.Version = '10.0.17763' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2020-11-10') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2021-05-11' And
      tblOperatingsystem.Version = '10.0.17763' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2021-05-11') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2020-12-08' And
      tblOperatingsystem.Version = '10.0.18362' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2020-12-08') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2021-05-11' And
      tblOperatingsystem.Version = '10.0.18363' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2021-05-11') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2022-05-10' And
      tblOperatingsystem.Version = '10.0.18363' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2022-05-10') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2021-12-14' And
      tblOperatingsystem.Version = '10.0.19041' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%' Or
      tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2021-12-14') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2022-05-10' And
      tblOperatingsystem.Version = '10.0.19042' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2022-05-10') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2023-05-09' And
      tblOperatingsystem.Version = '10.0.19042' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2023-05-09') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2020-01-14' And
      (tblOperatingsystem.Caption Like '%2008%' Or
      tblOperatingsystem.Caption Like '%Windows 7%') Then 'EOL in ' +
      Cast(DateDiff(DAY, GetDate(), '2020-01-14') As nvarchar) + ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2027-01-12' And
      tblOperatingsystem.Caption Like '%Server 2016%' Then 'EOL in ' +
      Cast(DateDiff(DAY, GetDate(), '2027-01-12') As nvarchar) + ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2029-01-09' And
      tblOperatingsystem.Caption Like '%Server 2019%' Then 'EOL in ' +
      Cast(DateDiff(DAY, GetDate(), '2029-01-09') As nvarchar) + ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2023-10-10' And
      tblOperatingsystem.Caption Like '%Server 2012%' Then 'EOL in ' +
      Cast(DateDiff(DAY, GetDate(), '2023-10-10') As nvarchar) + ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2023-01-10' And
      tblOperatingsystem.Caption Like '%Windows 8%' Then 'EOL in ' +
      Cast(DateDiff(DAY, GetDate(), '2023-01-10') As nvarchar) + ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2020-10-13' And
      tblOperatingsystem.Caption Like '%Embedded%' And
      tblOperatingsystem.Version = '6.1.7601' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2020-10-13') As nvarchar) +
      ' days'
  End As 'Days until EOL',
  Case
    When tblOperatingsystem.Caption Like '%2000%' Then '2010-07-13'
    When tblOperatingsystem.Version = '10.0.10240' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '2017-05-09'
    When tblOperatingsystem.Version = '10.0.10586' Then '2017-10-10'
    When tblOperatingsystem.Version = '10.0.14393' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '2018-04-10'
    When tblOperatingsystem.Version = '10.0.14393' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '2019-04-09'
    When tblOperatingsystem.Version = '10.0.15063' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '2018-10-09'
    When tblOperatingsystem.Version = '10.0.15063' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') Then '2019-10-08'
    When tblOperatingsystem.Version = '10.0.16299' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '2019-04-09'
    When tblOperatingsystem.Version = '10.0.16299' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') Then '2020-10-13'
    When tblOperatingsystem.Version = '10.0.17134' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '2019-11-12'
    When tblOperatingsystem.Version = '10.0.17134' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') Then '2021-05-11'
    When tblOperatingsystem.Version = '10.0.17763' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '2020-11-10'
    When tblOperatingsystem.Version = '10.0.17763' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '2021-05-11'
    When tblOperatingsystem.Version = '10.0.18362' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '2020-12-08'
    When tblOperatingsystem.Version = '10.0.18362' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') Then '2020-12-08'
    When tblOperatingsystem.Version = '10.0.18363' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '2021-05-11'
    When tblOperatingsystem.Version = '10.0.18363' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') Then '2022-05-10'
    When tblOperatingsystem.Version = '10.0.19041' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%' Or
      tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '2021-12-14'
    When tblOperatingsystem.Version = '10.0.19042' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '2022-05-10'
    When tblOperatingsystem.Version = '10.0.19042' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '2023-05-09'
    When tblOperatingsystem.Version = '10.0.10240' And
      (tblOperatingsystem.Caption Like '%LTS%') Then '2025-10-14'
    When tblOperatingsystem.Version = '10.0.14393' And
      (tblOperatingsystem.Caption Like '%LTS%') Then '2026-10-13'
    When tblOperatingsystem.Version = '10.0.17763' And
      (tblOperatingsystem.Caption Like '%LTS%') Then '2029-01-09'
    When tblOperatingsystem.Caption Like '%2008%' Or
      tblOperatingsystem.Caption Like '%Windows 7%' Then '2020-01-14'
    When tblOperatingsystem.Caption Like '%Server 2019%' Then '2029-01-09'
    When tblOperatingsystem.Caption Like '%Server 2016%' Then '2027-01-12'
    When tblOperatingsystem.Caption Like '%Server 2012%' Then '2023-10-10'
    When tblOperatingsystem.Caption Like '%Windows 8%' Then '2023-01-10'
    When tblOperatingsystem.Caption Like '%Embedded%' And
      tblOperatingsystem.Version = '6.1.7601' Then '2020-10-13'
  End As [EOL Date],
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  Case
    When tblOperatingsystem.Caption Like '%2000%' Then '#ffadad'
    When tblOperatingsystem.Version Like '%10240%' And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '#ffadad'
    When tblOperatingsystem.Version Like '%10240%' And
      tblOperatingsystem.Caption Like '%LTS%' Then '#d4f4be'
    When tblOperatingsystem.Version Like '%10586%' Then '#ffadad'
    When tblOperatingsystem.Version = '10.0.14393' And
      tblOperatingsystem.Caption Not Like '%LTS%' And
      tblOperatingsystem.Caption Not Like '%2016%' Then '#ffadad'
    When tblOperatingsystem.Version Like '%14393%' And
      tblOperatingsystem.Caption Like '%LTS%' Then '#d4f4be'
    When tblOperatingsystem.Version Like '%17763%' And
      tblOperatingsystem.Caption Like '%LTS%' Then '#d4f4be'
    When GetDate() >= '2018-10-09' And tblOperatingsystem.Version = '10.0.15063'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '#ffadad'
    When GetDate() >= '2019-10-08' And tblOperatingsystem.Version = '10.0.15063'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '#ffadad'
    When GetDate() >= '2019-04-09' And tblOperatingsystem.Version = '10.0.16299'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '#ffadad'
    When GetDate() >= '2020-10-13' And tblOperatingsystem.Version = '10.0.16299'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '#ffadad'
    When GetDate() >= '2019-11-12' And tblOperatingsystem.Version = '10.0.17134'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '#ffadad'
    When GetDate() >= '2021-05-11' And tblOperatingsystem.Version = '10.0.17134'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '#ffadad'
    When GetDate() >= '2020-11-10' And tblOperatingsystem.Version = '10.0.17763'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '#ffadad'
    When GetDate() >= '2021-05-11' And tblOperatingsystem.Version = '10.0.17763'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '#ffadad'
    When GetDate() >= '2021-11-10' And tblOperatingsystem.Version = '10.0.18362'
    Then '#ffadad'
    When GetDate() >= '2021-05-11' And tblOperatingsystem.Version = '10.0.18363'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '#ffadad'
    When GetDate() >= '2022-05-10' And tblOperatingsystem.Version = '10.0.18363'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '#ffadad'
    When GetDate() >= '2021-12-14' And tblOperatingsystem.Version = '10.0.19041'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%' Or
      tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '#ffadad'
    When GetDate() >= '2022-05-10' And tblOperatingsystem.Version = '10.0.19042'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '#ffadad'
    When GetDate() >= '2023-05-09' And tblOperatingsystem.Version = '10.0.19042'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '#ffadad'
    When GetDate() >= '2020-01-14' And (tblOperatingsystem.Caption Like '%2008%'
      Or tblOperatingsystem.Caption Like '%Windows 7%') Then '#ffadad'
    When GetDate() >= '2027-01-12' And tblOperatingsystem.Caption Like
      '%Server 2016%' Then '#ffadad'
    When GetDate() >= '2029-01-09' And tblOperatingsystem.Caption Like
      '%Server 2019%' Then '#ffadad'
    When GetDate() >= '2023-10-10' And tblOperatingsystem.Caption Like
      '%Server 2012%' Then '#ffadad'
    When GetDate() >= '2025-10-14' And tblOperatingsystem.Version = '10.0.10240'
      And tblOperatingsystem.Caption Like '%LTS%' Then '#ffadad'
    When GetDate() >= '2026-10-13' And tblOperatingsystem.Version = '10.0.14393'
      And tblOperatingsystem.Caption Like '%LTS%' Then '#ffadad'
    When GetDate() >= '2029-01-09' And tblOperatingsystem.Version = '10.0.17763'
      And tblOperatingsystem.Caption Like '%LTS%' Then '#ffadad'
    When GetDate() >= '2023-01-10' And tblOperatingsystem.Caption Like
      '%Windows 8%' Then '#ffadad'
    When GetDate() >= '2020-10-13' And tblOperatingsystem.Version = '6.1.7601'
      And tblOperatingsystem.Caption Like '%Embedded%' Then '#ffadad'
    When tblOperatingsystem.Caption Is Null Then '#ffadad'
    Else '#d4f4be'
  End As backgroundcolor,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model
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
Where tblAssets.Assettype Like '-1' And tblState.Statename = 'Active'
Order By tblAssets.Domain,
  tblAssets.AssetName
0 Kudos
Esben_D
Lansweeper Employee
Lansweeper Employee
In response to Hendrik_VE

‎05-11-2021 05:06 PM

The Home & Pro edition of 1909 are the ones going EOL. That's why it is listed in the article. I have updated it since it was indeed not clear from the text in regards to the specific editions.


Hendrik.VE wrote:
Btw, this report should give you a quite accurate overview of the Windows Lifecycle (for most common versions).
Should you find any mistakes in this report, please let me know 🙂


I actually added these type of reports to the library too.

Windows workstation: https://www.lansweeper.com/report/windows-10-end-of-life-audit/
Windows server: https://www.lansweeper.com/report/windows-server-end-of-life-audit/


0 Kudos
djbradley
Engaged Sweeper II

‎05-11-2021 02:46 PM

Thank you
0 Kudos
Hendrik_VE
Champion Sweeper III

‎05-11-2021 02:38 PM

Correct. 1909 Enterprise is supported until May 10th, 2022.
So the Lansweeper article is wrong.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now