In order to export VM info from your vCenter, let’s say automatically and daily you need to automate the following using PowerShell.

Prerequisites

Install-Module -Name VMware.PowerCLI -AllowClobberImport-Module -Name VMware.PowerCLISet-PowerCLIConfiguration -InvalidCertificateAction Ignore -Confirm:$false

Script

$Credentials = IMPORT-CLIXML "C:\exports\SecureCredentials.xml"

Connect-VIServer ServerName -Credential $Credentials -forceGet-VM | Select-Object Name, NumCPU, MemoryMB, ProvisionedSpaceGB, UsedSpaceGB, Notes | Export-Csv c:\exports\Files\VMsinfo.csv

echo "Done"exit