ESXi Builds report

[Mister_Nobody]

 I have created report for auditing ESXi Builds.

Source of builds for 6.0, 6.5, 7.0, 8.0:

https://knowledge.broadcom.com/external/article/316595/build-numbers-and-versions-of-vmware-esx.html

plus special for 6.7 https://techdocs.broadcom.com/us/en/vmware-cis/vsphere/vsphere/6-7/release-notes/esxi-update-and-pat... 

Alert set on March 2025, but you can edit condition.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblVmwareInfo.Version,
  Case Right(tblVmwareInfo.Version, Len(tblVmwareInfo.Version) - CharIndex('-',
    tblVmwareInfo.Version))
    When '24674464' Then '10.04.2025'
    When '24585383' Then '04.03.2025'
    When '24514018' Then '07.03.2025'
    When '24585300' Then '04.03.2025'
    When '24414501' Then '12.12.2024'
    When '24569005' Then '11.03.2025'
    When '24280767' Then '17.09.2024'
    When '24022510' Then '25.06.2024'
    When '23825572' Then '21.05.2024'
    When '23299997' Then '05.03.2024'
    When '23305546' Then '29.02.2024'
    When '22380479' Then '21.09.2023'
    When '22088125' Then '27.07.2023'
    When '21813344' Then '01.06.2023'
    When '21495797' Then '18.04.2023'
    When '21493926' Then '30.03.2023'
    When '21203435' Then '14.02.2023'
    When '20842819' Then '08.12.2022'
    When '20513097' Then '11.10.2022'
    When '24723872' Then '20.05.2025'
    When '24585291' Then '04.03.2025'
    When '24411414' Then '12.12.2024'
    When '23794027' Then '21.05.2024'
    When '23307199' Then '11.04.2024'
    When '22348816' Then '28.09.2023'
    When '21930508' Then '07.07.2023'
    When '21686933' Then '03.05.2023'
    When '21424296' Then '30.03.2023'
    When '21313628' Then '21.02.2023'
    When '21053776' Then '31.01.2023'
    When '20842708' Then '08.12.2022'
    When '20328353' Then '01.09.2022'
    When '20036589' Then '12.07.2022'
    When '19898904' Then '14.06.2022'
    When '19482537' Then '29.03.2022'
    When '19290878' Then '15.02.2022'
    When '19324898' Then '15.02.2022'
    When '19193900' Then '27.01.2022'
    When '18538813' Then '14.09.2021'
    When '18426014' Then '24.08.2021'
    When '17867351' Then '29.04.2021'
    When '17630552' Then '09.03.2021'
    When '17551050' Then '02.02.2021'
    When '17325551' Then '17.12.2020'
    When '17168206' Then '19.11.2020'
    When '17119627' Then '04.11.2020'
    When '16850804' Then '06.10.2020'
    When '16324942' Then '23.06.2020'
    When '15843807' Then '02.04.2020'
    When '20497097' Then '06.10.2022'
    When '19997733' Then '12.07.2022'
    When '19898906' Then '14.06.2022'
    When '19195723' Then '25.01.2022'
    When '18828794' Then '23.11.2021'
    When '17700523' Then '18.03.2021'
    When '17499825' Then '23.02.2021'
    When '17167734' Then '19.11.2020'
    When '17098360' Then '04.11.2020'
    When '16773714' Then '15.10.2020'
    When '16713306' Then '20.08.2020'
    When '16316930' Then '09.06.2020'
    When '16075168' Then '28.04.2020'
    When '15820472' Then '07.04.2020'
    When '15160138' Then '05.12.2019'
    When '15018017' Then '12.11.2019'
    When '14320388' Then '20.08.2019'
    When '13981272' Then '20.06.2019'
    When '13644319' Then '14.05.2019'
    When '13473784' Then '30.04.2019'
    When '13006603' Then '11.04.2019'
    When '13004448' Then '28.03.2019'
    When '11675023' Then '17.01.2019'
    When '10764712' Then '09.11.2018'
    When '10302608' Then '16.10.2018'
    When '10176752' Then '02.10.2018'
    When '9484548' Then '14.08.2018'
    When '9214924' Then '26.07.2018'
    When '8941472' Then '28.06.2018'
    When '8169922' Then '17.04.2018'
    When '20502893' Then '06.10.2022'
    When '19997716' Then '12.07.2022'
    When '19588618' Then '12.05.2022'
    When '19092475' Then '15.02.2022'
    When '18678235' Then '12.10.2021'
    When '18071574' Then '13.07.2021'
    When '17477841' Then '23.02.2021'
    When '17167537' Then '19.11.2020'
    When '17097218' Then '04.11.2020'
    When '16901156' Then '15.10.2020'
    When '16576891' Then '30.07.2020'
    When '16389870' Then '30.06.2020'
    When '16207673' Then '28.05.2020'
    When '15256549' Then '19.12.2019'
    When '15177306' Then '05.12.2019'
    When '14990892' Then '12.11.2019'
    When '14874964' Then '24.10.2019'
    When '14320405' Then '20.08.2019'
    When '13932383' Then '02.07.2019'
    When '13635690' Then '14.05.2019'
    When '13004031' Then '28.03.2019'
    When '11925212' Then '31.01.2019'
    When '10884925' Then '29.11.2018'
    When '10719125' Then '09.11.2018'
    When '10390116' Then '23.10.2018'
    When '10175896' Then '02.10.2018'
    When '9298722' Then '14.08.2018'
    When '8935087' Then '28.06.2018'
    When '8294253' Then '03.05.2018'
    When '7967591' Then '20.03.2018'
    When '7388607' Then '19.12.2017'
    When '6765664' Then '05.10.2017'
    When '5969303' Then '27.07.2017'
    When '5310538' Then '18.04.2017'
    When '5224529' Then '28.03.2017'
    When '5146846' Then '09.03.2017'
    When '4887370' Then '02.02.2017'
    When '4564106' Then '15.11.2016'
    When '15517548' Then '20.02.2020'
    When '15169789' Then '05.12.2019'
    When '14513180' Then '12.09.2019'
    When '15018929' Then '12.11.2019'
    When '13635687' Then '14.05.2019'
    When '13003896' Then '28.03.2019'
    When '10719132' Then '09.11.2018'
    When '10474991' Then '23.10.2018'
    When '9919195' Then '13.09.2018'
    When '9313334' Then '14.08.2018'
    When '9239799' Then '26.07.2018'
    When '8934903' Then '28.06.2018'
    When '7967664' Then '20.03.2018'
    When '7504637' Then '09.01.2018'
    When '6921384' Then '09.11.2017'
    When '6765062' Then '05.10.2017'
    When '5572656' Then '06.06.2017'
    When '5251623' Then '28.03.2017'
    When '5251621' Then '28.03.2017'
    When '5224934' Then '28.03.2017'
    When '5050593' Then '24.02.2017'
    When '4600944' Then '22.11.2016'
    When '4510822' Then '17.10.2016'
    When '4192238' Then '04.08.2016'
    When '3825889' Then '12.05.2016'
    When '3620759' Then '16.03.2016'
    When '3568940' Then '23.02.2016'
    When '3380124' Then '07.01.2016'
    When '3247720' Then '25.11.2015'
    When '3073146' Then '06.10.2015'
    When '3029758' Then '10.09.2015'
    When '2809209' Then '07.07.2015'
    When '2715440' Then '14.05.2015'
    When '2615704' Then '09.04.2015'
    When '2494585' Then '12.03.2015'
    Else '01.01.1970'
  End As Release_date,
  Case
    When Right(tblVmwareInfo.Version, Len(tblVmwareInfo.Version) -
      CharIndex('-', tblVmwareInfo.Version)) > 24500000 Then
      'OS has newer update than March 2025'
    Else 'You must update ESXi'
  End As Update_Status,
  Case
    When Right(tblVmwareInfo.Version, Len(tblVmwareInfo.Version) -
      CharIndex('-', tblVmwareInfo.Version)) > 24500000 Then '#d4f4be'
    Else '#ffadad'
  End As backgroundcolor
From tblVmwareInfo
  Inner Join tblAssets On tblAssets.AssetID = tblVmwareInfo.AssetID

[Obi_1_Cinobi]

Hello there!

Thanks for sharing another wonderful report!