# 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-ESXi-hosts-$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)
$ListOfVMHosts = Get-VMHost | Sort-Object Name

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

Foreach ($VMHost in $ListOfVMHosts) {
    $1 = $null
    $1 = $VMHost | Get-VMHostHardware -SkipAllSslCertificateChecks -ErrorAction SilentlyContinue
    If ($1) {
        MyLogger -Message "Processing host $VMHost.Name [$Counter/$Count]"
        #Write-Host "Processing host $VMHost.Name [$Counter/$Count]"

        $HostHardware = $VMHost |  Get-VMHostHardware -SkipAllSslCertificateChecks
        $HostNetwork = $VMHost |  Get-VMHostNetwork

        $HostNetworkvMotionAdapter = $VMHost |  Get-VMHostNetworkAdapter -VMKernel |  Where-Object { $_.VMotionEnabled -eq $true }
        $HostNetworkManagementTrafficAdapter = $VMHost |  Get-VMHostNetworkAdapter -VMKernel |  Where-Object { $_.ManagementTrafficEnabled -eq $true }
        $HostNetworkvSANTrafficAdapter = $VMHost |  Get-VMHostNetworkAdapter -VMKernel |  Where-Object { $_.VsanTrafficEnabled -eq $true }

        $MemoryTotalGB = [math]::Round($VMHost.MemoryTotalGB)

        $Object = [PSCustomObject]@{
            SerialNumber     = $HostHardware.SerialNumber # Serialnumber needs to be first for VLOOKUP to work in Excel
            vCenter          = $VMHost.Uid.Substring($VMHost.Uid.IndexOf('@') + 1).Split(":")[0]
            DataCenter       = ($VMHost | Get-Datacenter)
            Cluster          = $VMHost.Parent
            HostName         = $VMHost.Name
            Manufacturer     = $VMHost.Manufacturer
            Model            = $VMHost.Model
            Bios             = $HostHardware.BiosVersion
            Processor        = $VMHost.ProcessorType
            CPU              = $HostHardware.CpuCount
            CPUCores         = $HostHardware.CpuCoreCountTotal
            MemoryGB         = $MemoryTotalGB
            ESXVersion       = $VMHost.ExtensionData.Summary.Config.Product.FullName
            ESXLicenseKey    = $VMHost.LicenseKey
            DNS1             = $HostNetwork.DnsAddress[0]
            DNS2             = $HostNetwork.DnsAddress[1]
            Gateway          = $HostNetwork.VMKernelGateway
            ManagementDevice = $HostNetworkManagementTrafficAdapter.name
            ManagementIP     = $HostNetworkManagementTrafficAdapter.ip
            ManagementMTU    = $HostNetworkManagementTrafficAdapter.mtu
            vMotionDevice    = $HostNetworkvMotionAdapter.name
            vMotionIP        = $HostNetworkvMotionAdapter.ip
            vMotionMTU       = $HostNetworkvMotionAdapter.mtu
            vSANDevice       = $HostNetworkvSANTrafficAdapter.name
            vSANIP           = $HostNetworkvSANTrafficAdapter.ip
            vSANMTU          = $HostNetworkvSANTrafficAdapter.mtu
        }

        $Report.add($Object) | Out-Null
    } Else {
        MyLoggerError -Message  "There was an error processing host $VMHost.Name [$Counter/$Count]"
    }
    $Counter++
}

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

$DefaultVIServers | Disconnect-VIServer -Confirm:$false