Install-Module -Name VMware.PowerCLI -Scope CurrentUser

# Import VMware PowerCLI module
If (-not (Get-Module -Name 'VMware.PowerCLI')) {
    Import-Module VMware.PowerCLI
}

# Variable declaration
$Report = New-Object System.Collections.ArrayList
$DateTime = $((Get-Date).ToString('yyyy-MM-dd_hh-mm-ss'))

# Set report output path
$OutputPath = "$env:USERPROFILE\Documents\Reports"
If ( -Not (Test-Path -Path $OutputPath)) {
    New-Item -ItemType directory -Path $OutputPath
}
$Outputfile = "All-VMs-$DateTime"

# Get credentials to use to connect to the vCenter(s)
Clear-Host
$Credentials = Get-Credential -Message "Please enter the username and password to use to connect to the vCenter(s)"

# Connect to vCenter(s)
$ListOfvCenters = (
    "<FQDN/IP address of vCenter #1",
    "vcenter01.yourdomain.local",
    "10.10.10.50"
)
Connect-VIServer $ListOfvCenters -Credential $Credentials -ErrorAction Continue

# Get a list of all ESXi hosts running in the vCenter(s)
$ListOfVMs = $ListOfVMs | Sort-Object -Property Name              # Sort the VM list on alphabetical order
#$ListOfVMs = Get-VM | Where-Object {$_.Name -like "*text*"}   # User this line to get info on specified VM's

# Get required information for each host
$Count = $ListOfVMs.Count
$Counter = 1

ForEach ($VM in $ListOfVMs) {
    Write-Host "Processing VM $VM [$Counter/$Count]"

    $VMView = $VM | Get-View
    $VMNICs = (Get-NetworkAdapter -VM $VM)
    $VMDisks = Get-HardDisk -VM $VM

    $Object = [PSCustomObject]@{
        Name                = $VM.Name
        PowerState          = $VM.PowerState
        HardwareVersion     = $VM.HardwareVersion
        vCenter             = $VM.Uid.Substring($VM.Uid.IndexOf('@') + 1).Split(":")[0]
        Host                = $VM.VMHost.Name
        Cluster             = $VM.VMHost.Parent.name
        ToolsStatus         = $VMView.Guest.ToolsStatus
        GuestOS             = (Get-VMGuest -VM $VM).OSFullName
        NumCPU              = $VM.NumCpu
        CpuHotAddEnabled    = ($VM | Select-Object ExtensionData).ExtensionData.config.CpuHotAddEnabled
        MemGB               = $VM.MemoryGB
        MemoryHotAddEnabled = ($VM | Select-Object ExtensionData).ExtensionData.config.MemoryHotAddEnabled
        NumDisks            = $VMDisks.Count
        Disk1SizeGb         = $VMDisks.CapacityGb[0]
        Disk2SizeGb         = $VMDisks.CapacityGb[1]
        Disk3SizeGb         = $VMDisks.CapacityGb[2]
        Disk4SizeGb         = $VMDisks.CapacityGb[3]
        NumNICs             = $VMNICs.Count
        Nic0_Type           = $VMNICs.Type[0]
        NIC0_IP             = $VM.Guest.IPAddress[0]
        NIC0_Mac            = $VMNICs.MacAddress[0]
        Nic1_Type           = $VMNICs.Type[1]
        NIC1_IP             = $VM.Guest.IPAddress[1]
        NIC1_Mac            = $VMNICs.MacAddress[1]
        Nic2_Type           = $VMNICs.Type[2]
        NIC2_IP             = $VM.Guest.IPAddress[2]
        NIC2_Mac            = $VMNICs.MacAddress[2]
        Folder              = $VM.Folder.Name
    }

    $Report.add($Object) | Out-Null
    $Counter++
}

$Report | Export-Csv "$Outputfile.csv" -NoTypeInformation -UseCulture

$DefaultVIServers | Disconnect-VIServer -Confirm:$False