Since the original script was also doing that, I assumed you wanted it that way.
But we can easily place everything in 1 CSV file.
Connect-VIServer -Server vcenter.local
-User username
-Password Password
$report = @()
Foreach ($vm in Get-VM)
{
$tab = @{}
$date=Get-Date -format "ddMMyy_HHmm"
Get-AdvancedSetting -Entity $vm | ForEach-Object -Process {
$tab.Add($_.Name,$_.Value)
}
New-AdvancedSetting -Entity $vm -Name vmci0.unrestricted -Value FALSE -Confirm:$False -Force:$True
# repeat for other settings
$report += Get-AdvancedSetting -Entity $vm |
Select @{N='VM';E={$vm.Name}},Name,@{N='OldValue';E={$tab[$_.Name]}},@{N='NewValue';E={$_.Value}}
}
$report | Export-Csv -Path "Settings_$($date).csv" -NoTypeInformation -UseCulture
