# vCenter Login
$vCUser="User"
$vCPass="password"
# LIST OF vCenter
$vCenterIP = "vcenter1","vcenter22","vcenter3","vcenter4"
# Connection to vCenter
foreach ($IPAddress in $vCenterIP){
Connect-VIServer $IPAddress -User $vCUser -Password $vCPass -port 443
}
#Requires -Modules ImportExcel
$fileName = 'C:\.\ALL_vCenter_Firmware_Report.xlsx'
$reportVIB = @()
$reportPatch = @()
$reportNic = @()
$global:DefaultVIServers |
ForEach-Object -Process {
Get-VMHost -Server $_ -PipelineVariable esx |
ForEach-Object -Process {
$esxcli = Get-EsxCli -VMHost $esx -V2
$reportVIB += $esxcli.software.vib.list.Invoke() |
Select @{N='vCenter';E={([uri]$esx.ExtensionData.Client.ServiceUrl).Host}},
@{N='vCenter Version';E={$esx.ExtensionData.Client.ServiceContent.About.Version}},
@{N='vCenter Build';E={$esx.ExtensionData.Client.ServiceContent.About.Build}},
@{N='VMHost';E={$esx.Name}},
@{N='VMHost Version';E={$esx.Version}},
@{N='VMHost Build';E={$esx.Build}},
Name,ID,CreationDate,InstallDate,Version,Vendor,AcceptanceLevel
Get-Compliance -Entity $esx -Detailed -PipelineVariable baseline |
where{$_ -is [VMware.VumAutomation.Types.PatchBaselineCompliance]} |
ForEach-Object -Process {
$reportPatch += $baseline.CompliantPatches |
Select @{N='vCenter';E={([uri]$esx.ExtensionData.Client.ServiceUrl).Host}},
@{N='vCenter Version';E={$esx.ExtensionData.Client.ServiceContent.About.Version}},
@{N='vCenter Build';E={$esx.ExtensionData.Client.ServiceContent.About.Build}},
@{N='VMHost';E={$esx.Name}},
@{N='VMHost Version';E={$esx.Version}},
@{N='VMHost Build';E={$esx.Build}},
@{N='Baseline';E={$baseline.Baseline.Name}},
@{N='Compliant';E={$true}},
Name,Vendor,IdByVendor,ReleaseDate,LastUpdateTime,Severity,@{N='Product';E={$_.Product.Name}}
$reportPatch += $baseline.NotCompliantPatches |
Select @{N='vCenter';E={([uri]$esx.ExtensionData.Client.ServiceUrl).Host}},
@{N='vCenter Version';E={$esx.ExtensionData.Client.ServiceContent.About.Version}},
@{N='vCenter Build';E={$esx.ExtensionData.Client.ServiceContent.About.Build}},
@{N='VMHost';E={$esx.Name}},
@{N='VMHost Version';E={$esx.Version}},
@{N='VMHost Build';E={$esx.Build}},
@{N='Baseline';E={$baseline.Baseline.Name}},
@{N='Compliant';E={$false}},
Name,Vendor,IdByVendor,ReleaseDate,LastUpdateTime,Severity,@{N='Product';E={$_.Product.Name}}
}
$reportNic += $esxcli.network.nic.list.Invoke() |
ForEach-Object -Process {
$pMAC = $_.MACAddress
$esxcli.network.nic.get.Invoke(@{nicname=$_.Name}) |
Select-Object @{N = 'vCenter'; E = { ([uri]$esx.ExtensionData.Client.ServiceUrl).Host } },
@{N = 'vCenter Product'; E = { $esx.ExtensionData.Client.ServiceContent.About.Name } },
@{N = 'vCenter Version'; E = { $esx.ExtensionData.Client.ServiceContent.About.Version } },
@{N = 'vCenter Build'; E = { $esx.ExtensionData.Client.ServiceContent.About.Build } },
@{N = 'VMHost'; E = { $esx.Name } },
@{N = 'VMHost Product'; E = { $esx.ExtensionData.Config.Product.Name } },
@{N = 'VMHost Version'; E = { $esx.Version } },
@{N = 'VMHost Build'; E = { $esx.Build } },
@{N='NIC';E={$_.Name}},
@{N='pMAC';E={$pMAC}},
@{N='vMAC';E={$_.VirtualAddress}},
@{N='LinkStatus';E={$_.LinkStatus}},
@{N='Driver';E={$_.DriverInfo.Driver}},
@{N='Version';E={$_.DriverInfo.Version}},
@{N='FirmwareVersion';E={$_.DriverInfo.FirmwareVersion}},
@{N="Type";E={$esx.ExtensionData.Hardware.SystemInfo.Vendor+""+$esx.ExtensionData.Hardware.SystemInfo.Model}},
@{N="BIOS version";E={$esx.ExtensionData.Hardware.BiosInfo.BiosVersion}},
@{N="BIOS date";E={$esx.ExtensionData.Hardware.BiosInfo.releaseDate}},
@{N = "CPU"; E = { $esx.ExtensionData.Hardware.CpuPkg[0].Description } }
}
}
}
$reportVIB | Export-Excel -Path $fileName -WorksheetName 'VIB'
$reportPatch | Export-Excel -Path $fileName -WorksheetName 'Patch'
$reportNic | Export-Excel -Path $fileName -WorksheetName 'NIC'
