Discover ESXi Vulnerabilities
List all your VMware ESXi servers and their version with our custom audit report. Use this audit to get an overview of your vulnerable ESXi servers and their versions to quickly identify outdated ESXi versions so that you can start the update process as soon as possible. Prevent possible security issues by ensuring your ESXi server is always updated. The report is based on the official VMware build numbers. The report can be easily modified to check for the latest VMware build versions.
ESXi Vulnerability Report Query
Select Top 1000000 tblAssets.AssetID, Case When tblVmwareInfo.Version Like '%5.5%9919047%' Then '#00FF00' When tblVmwareInfo.Version Like '%6.0%15517548%' Then '#00FF00' When tblVmwareInfo.Version Like '%6.5%17167537%' Then '#00FF00' When tblVmwareInfo.Version Like '%6.7%17167734%' Then '#00FF00' When tblVmwareInfo.Version Like '%7.0%17168206%' Then '#00FF00' Else '#F0E68C' End As backgroundcolor, tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.AssetName, tblVmwareInfo.Version As ESXiVersion, tblAssetCustom.Manufacturer, tblAssetCustom.Model, tblAssetCustom.Serialnumber, tblVmwareInfo.BiosVersion, tblVmwareInfo.BiosDate, tblAssets.Processor, tblAssetCustom.PurchaseDate, tblAssets.IPAddress, tsysIPLocations.IPLocation, tblAssets.Lastseen, tblAssets.Lasttried, tblState.Statename As State From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblVmwareInfo On tblAssets.AssetID = tblVmwareInfo.AssetID Inner Join tblState On tblState.State = tblAssetCustom.State Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP Order By tblAssets.AssetName