VMware Cloud Community
ganapa2000
Hot Shot
Hot Shot
Jump to solution

Unable to get the output in CSV

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

ganapa2000_0-1666268483043.png

 

0 Kudos
1 Solution

Accepted Solutions
LucD
Leadership
Leadership
Jump to solution

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

View solution in original post

0 Kudos
2 Replies
LucD
Leadership
Leadership
Jump to solution

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

0 Kudos
ganapa2000
Hot Shot
Hot Shot
Jump to solution

That worked perfectly...Thank you very much 🙂

0 Kudos