ESXi is a type 1 hypervisor and part of VMware’s vSphere, which helps IT teams to more efficiently manage their available hardware resources. In vSphere, all virtual machines are installed on ESXi servers. VMware’s lifecycle policy for all vSphere products, including ESXi, offers 7 years of support, divided into 5 years of general support and 2 years of technical guidance. For the purpose of this report, we will consider a product as end-of-life when the 5 years of general support end, as the services offered during the 2 years of technical guidance are not sufficient for all users. ESXi 6.5 and 6.7 will be going end of life on October 15, 2022.
You can read more about the VMware ESXi lifecycle in our VMware ESXi end-of-life blog post.
VMware ESXi EOL Query
Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Version,
tblassets.BuildNumber,
subquery1.EOLDate As 'End of General Support',
subquery1.EOTGDate As 'End of Techinical Guidance',
Case
When GetDate() < subquery1.EOLDate Then Cast(DateDiff(DAY, GetDate(),
subquery1.EOLDate) As NVARCHAR) + ' days remaining'
When GetDate() > subquery1.EOLDate Then 'EOL'
End As [EOL Days Remaining],
tblAssets.Lastseen,
tblAssets.Lasttried,
Case
When GetDate() > subquery1.EOLDate Then '#ffadad'
When GetDate() >= DateAdd(month, -1, subquery1.EOLDate) Then '#ffd152'
When GetDate() < subquery1.EOLDate Then '#d4f4be'
Else ''
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
Case
When tblassets.Version Like '7.0%' Then '2025-04-02'
When tblassets.Version Like '6.7%' Then '2022-10-15'
When tblassets.Version Like '6.5%' Then '2022-10-15'
When tblassets.Version Like '6.0%' Then '2020-03-12'
When tblassets.Version Like '5.5%' Then '2018-09-19'
When tblassets.Version Like '5.%' Then '2016-08-24'
When tblassets.Version Like '4.%' Then '2014-05-21'
End As EOLDate,
Case
When tblassets.Version Like '7.0%' Then '2027-04-02'
When tblassets.Version Like '6.7%' Then '2023-11-15'
When tblassets.Version Like '6.5%' Then '2023-11-15'
When tblassets.Version Like '6.0%' Then '2022-03-12'
When tblassets.Version Like '5.5%' Then '2020-09-19'
When tblassets.Version Like '5.%' Then '2018-08-24'
When tblassets.Version Like '4.%' Then '2016-05-21'
End As EOTGDate,
tblassets.AssetID
From tblassets) As subquery1 On
subquery1.AssetID = tblAssets.AssetID
Where tsysAssetTypes.Assettypename = 'ESXi server'
Order by version
