Hi,
I am unable to get the output in CSV
$VMS = Import-Csv "D:\serverlist.csv"
$array = @()
foreach ($VM in $VMS){
$info = get-vm -name $VM.Name -ErrorAction SilentlyContinue
If($info){
Write-Host "$VM is present"
$array += $VM.Name
}
Else {
Write-Host "$VM does not exist"
$array1 += $VM.Name
}
}
$array | Export-Csv "D:\VM_Exists.csv" -NoTypeInformation -UseCulture
$array1 | Export-Csv "D:\VM_Not_Exists.csv" -NoTypeInformation -UseCulture
On the Screen, the VM Name is showing with brackets
Try like this
$VMS = Import-Csv "D:\serverlist.csv"
$array = @()
foreach ($VM in $VMS) {
$info = Get-VM -Name $VM.Name -ErrorAction SilentlyContinue
If ($info) {
Write-Host "$($VM.Name) is present"
$array += $VM | Select Name
} Else {
Write-Host "$($VM.Name) does not exist"
$array1 += $VM | Select Name
}
}
$array | Export-Csv "D:\VM_Exists.csv" -NoTypeInformation -UseCulture
$array1 | Export-Csv "D:\VM_Not_Exists.csv" -NoTypeInformation -UseCulture
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference
Try like this
$VMS = Import-Csv "D:\serverlist.csv"
$array = @()
foreach ($VM in $VMS) {
$info = Get-VM -Name $VM.Name -ErrorAction SilentlyContinue
If ($info) {
Write-Host "$($VM.Name) is present"
$array += $VM | Select Name
} Else {
Write-Host "$($VM.Name) does not exist"
$array1 += $VM | Select Name
}
}
$array | Export-Csv "D:\VM_Exists.csv" -NoTypeInformation -UseCulture
$array1 | Export-Csv "D:\VM_Not_Exists.csv" -NoTypeInformation -UseCulture
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference
That worked perfectly...Thank you very much 🙂