Pulling data from vCSA using PowerCLI

[virtman36]

Good Day All,

We are moving from Windows vCenter to the VCSA. We use to pull data about the environment directly from the SQL database using an SQL query. Now that SQL is gone we are trying to get the same data from the vcsa but the script we are suing takes forever. Can anyone help me figure out how to get the data in the script faster?

[LucD]

Did you already try passing to Get-View and doing the Get-Stat only once, instead of one call for each VM?

[virtman36]

No  I did not. Can you give an example, please?