VMware Tools End of Life Audit
Security SoftwareFind End of Life VMware Tools Installations
VMware Tools is an application designed to help manage virtual machines and is used to pass messages from host to guest, customize the guest OS, run scripts, and sync system time. To help you keep an eye on the end-of-life dates for the various VMware Tools versions we’ve created a special color-coded report that lists your VMware Tools installations along with the EOL date and how many days are remaining.
Read all about the VMware Tools lifecycle in our VMware Tools blog post.
VMware Tools End of Life Query
Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.Version as OSVersion,
tblAssets.SP,
subquery1.Software,
subquery1.Version,
subquery1.Publisher,
subquery1.EOLDate,
Case
When GetDate() < subquery1.EOLDate Then Cast(DateDiff(DAY, GetDate(),
subquery1.EOLDate) As NVARCHAR) + ' days remaining'
End As [Days Remaining],
tblAssets.Lastseen,
tblAssets.Lasttried,
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 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
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join (Select tblSoftwareUni.softwareName As Software,
tblsoftware.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
Case
When Cast(Left(tblsoftware.softwareVersion, PatIndex('%[^0-9]%',
tblsoftware.softwareVersion + 't') - 1) As bigint) <= 9 Then
'2020-03-12'
When tblsoftware.softwareVersion Like '10.0%' Then '2020-03-12'
When tblsoftware.softwareVersion Like '10.1%' Then '2021-11-15'
When tblsoftware.softwareVersion Like '10.2%' Then '2022-12-14'
When tblsoftware.softwareVersion Like '10.3%' Then '2024-06-30'
When tblsoftware.softwareVersion Like '11.0%' Then '2024-09-19'
When tblsoftware.softwareVersion Like '11.1%' Then '2025-05-07'
When tblsoftware.softwareVersion Like '11.2%' Then '2025-10-15'
When tblsoftware.softwareVersion Like '11.3%' Then '2026-06-17'
End As EOLDate,
tblsoftware.AssetID
From tblsoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblsoftware.softID
Where tblSoftwareUni.softwareName Like '%VMware Tools%') As subquery1 On
subquery1.AssetID = tblAssets.AssetID
Where subquery1.Software Like '%VMware Tools%' And tblState.Statename = 'Active'