VMware Tools 10.3.x EOL

[Esben_D]

VMware Tools 10.3.x support will end on June 30. Find out what VMware Tools versions you have in your environment, what version they are and when they will no longer be supported in the blog post.

[Mister_Nobody]

Redesign version for Windows and Linux.

+Fix for Debian-package

Select Distinct Top 1000000 tblAssets.AssetID,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tsysAssetTypes.AssetTypename As AssetType,
  tblAssets.IPAddress,
  tblAssets.Domain,
  tblAssets.AssetName,
  IsNull(tsysOS.OSname, tblLinuxSystem.OSRelease) As OS,
  tblSoftwareUni.softwareName As Software,
  subquery1.Version,
  IsNull(tblLinuxSoftware.InstallDate, tblSoftware.InstallDate) As Installdate,
  IsNull(tblSoftwareUni.SoftwarePublisher, tblLinuxSoftware.description) As
  [Publisher/Description],
  subquery1.EOLDate,
  Case
    When GetDate() < subquery1.EOLDate Then Cast(DateDiff(DAY, GetDate(),
      subquery1.EOLDate) As NVARCHAR) + ' days remaining'
    Else 'EOL'
  End As [Days Remaining],
  tblAssets.Lastseen,
  Case
    When GetDate() > subquery1.EOLDate Then '#ffadad'
    When GetDate() >= DateAdd(month, -1, subquery1.EOLDate) Then '#ffd152'
    Else '#d4f4be'
  End As backgroundcolor
From tblAssets
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Left Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
  Left Join (Select t.softwareVersion As Version,
      t.softID,
      Case
        When Cast(Left(t.softwareVersion, PatIndex('%[^0-9]%', t.softwareVersion
          + 't') - 1) As bigint) <= 9 Then '2020-03-12'
        When t.softwareVersion Like '10.0%' Then '2020-03-12'
        When t.softwareVersion Like '10.1%' Then '2021-11-15'
        When t.softwareVersion Like '10.2%' Then '2022-12-14'
        When t.softwareVersion Like '10.3%' Then '2024-06-30'
        When t.softwareVersion Like '11.0%' Then '2024-09-19'
        When t.softwareVersion Like '11.1%' Then '2025-05-07'
        When t.softwareVersion Like '11.2%' Then '2025-10-15'
        When t.softwareVersion Like '11.3%' Then '2026-06-17'
        When t.softwareVersion Like '12.0%' Then '2027-03-01'
        When t.softwareVersion Like '12.1%' Then '2027-08-23'
        When t.softwareVersion Like '12.2%' Then '2028-03-07'
        When t.softwareVersion Like '12.3%' Then '2028-08-31'
        When t.softwareVersion Like '12.4%' Then '2029-03-21'
      End As EOLDate,
      t.AssetID
    From (Select it1.AssetId,
          it1.softId,
          it1.softwareVersion
        From tblsoftware it1
        Union All
        Select it2.AssetId,
          it2.SoftwareUniId,
          Replace(it2.Version, '2:', '') As Version
        From tblLinuxSoftware it2) t) As subquery1 On subquery1.AssetID =
      tblAssets.AssetID
  Left Join tblSoftwareUni On tblSoftwareUni.SoftID = subquery1.softID
  Left Join tblLinuxSoftware On tblLinuxSoftware.SoftwareUniId =
      subquery1.softID And tblLinuxSoftware.assetid = tblAssets.assetid
  Left Join tblSoftware On tblSoftware.SoftId = subquery1.softID And
      tblSoftware.assetid = tblAssets.assetid
Where (tblSoftwareUni.softwareName = 'vmware tools' Or
    tblSoftwareUni.softwareName = 'open-vm-tools')
Order By tblAssets.assetname