Querying VMware HCL via PowerShell

[AndrasJ]

Hi Guys,

Is there a way to get the VMware HCL database from PowerShell?

I would like to automate a little the firmware-driver comparison and their upgrade and it would help a lot.

I do know that there's a method for vSAN JSON and for the servers only but I would like to check all components in the servers.

Thank you for your help!

Best regards,

Andras

[LucD]

Both examples you mention use their proprietary JSON file with HCL information.

You would need to know how these JSON file are created to expand beyond the server brand and type.

Now if only the HCL had a REST API :smileygrin:

[AndrasJ]

Do you know about VMware is planning to make these tasks easier for us?

As the HCL is a database, querying it may not be too complex from a script - doing it manually is taking hours in case of many kind of vendors.

[LucD]

I wouldn't know, I don't work for VMware.

Perhaps raise the question via your TAM? Or via a SR?

[AndrasJ]

Sorry, I replied to you, but it was an open question for everyone. I'm hoping it's not disturbing only me and AFAIK there are VMware employees around here too.

Anyway, based on your answer, I will, thank you!