Blank Output for unreachable VMs

[ganapa2000]

Hi,

I am unable to validate and get the output for unreachable or connection issue VMs to csv file.

Please help

$reportlocation1 = ".\POC_WIN_VM_OS_Info.csv"
$reportlocation2 = ".\POC_WIN_VM_OS_Info88.csv"

$report1 = @()
$reportNotFound = @()
Import-Csv -Path $reportlocation1 -UseCulture -PipelineVariable row |
ForEach-Object -Process {
$found = $false
try {
$os = Get-WmiObject -computername $object.("Name") -class win32_operatingsystem
$sys = Get-WmiObject -computername $object.("Name") -class Win32_ComputerSystem
$net = Get-WmiObject -computername $object.("Name") -class Win32_NetworkAdapterConfiguration | where{$_.IPaddress} | select -expandproperty IPaddress | Select -First 1 | where{$_ -notmatch ':'}

$DeviceInfo= @{}
$DeviceInfo.add("Hostname", $sys.DNSHostName)
$DeviceInfo.add("Operating System", $os.name.split("|")[0])
$DeviceInfo.add("IP Address", ($net.IPAddress -join (", ")))
$report1 += New-Object PSObject -Property $DeviceInfo | Select-Object "Hostname", "IP Address", "Operating System"
$found = $true
}
catch {
}
$result
if(-not $found){
$reportNotFound += $row
}
}

Write-Verbose ($report1 | Out-String) -Verbose
$report1 | Export-CSV $reportlocation2 -NoTypeInformation
$reportNotFound | ft -auto
$reportNotFound | Export-Csv -Path ".\Error_VMs_Info.csv" -NoTypeInformation -UseCulture

[LucD]

Do you mean that Error_VMs_Info.csv is empty?

[ganapa2000]

yes, both output file and error output file are empty

[LucD]

You are again using a variable that is not initialised for ComputerName.
And you have to specify an ErrorAction to get into the Catch block.

Something like this

$reportlocation1 = ".\POC_WIN_VM_OS_Info.csv"
$reportlocation2 = ".\POC_WIN_VM_OS_Info88.csv"

$report1 = @()
$reportNotFound = @()

Import-Csv -Path $reportlocation1 -UseCulture -PipelineVariable row |
ForEach-Object -Process {
  $found = $false
  try {
    $os = Get-WmiObject -ComputerName $row.Name -Class win32_operatingsystem -erroraction stop
    $sys = Get-WmiObject -ComputerName $row.Name -Class Win32_ComputerSystem
    $net = Get-WmiObject -ComputerName $row.Name -Class Win32_NetworkAdapterConfiguration | Where-Object { $_.IPaddress } | Select-Object -ExpandProperty IPaddress | Select-Object -First 1 | Where-Object { $_ -notmatch ':' }

    $DeviceInfo = @{}
    $DeviceInfo.add("Hostname", $sys.DNSHostName)
    $DeviceInfo.add("Operating System", $os.name.split("|")[0])
    $DeviceInfo.add("IP Address", ($net.IPAddress -join (", ")))
    $report1 += New-Object PSObject -Property $DeviceInfo | Select-Object "Hostname", "IP Address", "Operating System"
    $found = $true
  } catch {
  }
  if (-not $found) {
    $reportNotFound += $row
  }
}

write-host "=== Report"
$report1
write-host "==== Not found"
$reportNotFound

[ganapa2000]

Hi Lucd,

that worked, but how I add a row for Operating System in the existing csv, its now working 😞

$reportlocation1 = ".\POC_WIN_VM_OS_Info.csv"

$report1 = @()
$reportNotFound = @()

Import-Csv -Path $reportlocation1 -UseCulture -PipelineVariable row |
ForEach-Object -Process {
$found = $false
try {
$os = Get-WmiObject -ComputerName $row.Name -Class win32_operatingsystem -erroraction stop
$sys = Get-WmiObject -ComputerName $row.Name -Class Win32_ComputerSystem
$net = Get-WmiObject -ComputerName $row.Name -Class Win32_NetworkAdapterConfiguration | Where-Object { $_.IPaddress } | Select-Object -ExpandProperty IPaddress | Select-Object -First 1 | Where-Object { $_ -notmatch ':' }

$DeviceInfo = @{}
$DeviceInfo.add("Hostname", $sys.DNSHostName)
$DeviceInfo.add("OperatingSystem", $os.name.split("|")[0])
#$DeviceInfo.add("IP Address", ($net.IPAddress -join (", ")))
$DeviceInfo.add("IP Address", $net)
$report += New-Object PSObject -Property $DeviceInfo | Select-Object "Hostname", "IP Address", "Operating System"
$report1 += $row | Add-Member -MemberType NoteProperty -Name 'OS Edition' -Value $($os.name.split("|")[0]) -PassThru
$found = $true
} catch {
}
if (-not $found) {
$reportNotFound += $row
}
}

#Write-Verbose ($report1 | Out-String) -Verbose
$report
$report1
$report1 | Export-CSV $reportlocation1 -NoTypeInformation
$reportNotFound | ft -auto
$reportNotFound | Export-Csv -Path ".\Error_VMs_Info.csv" -NoTypeInformation -UseCulture

[LucD]

I'm not sure I'm following.
How do you want that CSV to look?
Perhaps show a mockup of what you want to see in there

[ganapa2000]

import CSV has following

Folder, Name, "IP Address"

I would like to add the Operating System appended to the same CSV in the output

Folder, Name, "IP Address", "Operating System"

[LucD · Accepted solution]

Can you try like this?

$reportlocation1 = ".\POC_WIN_VM_OS_Info.csv"

$report1 = @()
$reportNotFound = @()

Import-Csv -Path $reportlocation1 -UseCulture -PipelineVariable row |
  ForEach-Object -Process {
    $found = $false
    try {
      $os = Get-WmiObject -ComputerName $row.Name -Class win32_operatingsystem -ErrorAction stop
      $sys = Get-WmiObject -ComputerName $row.Name -Class Win32_ComputerSystem
      $net = Get-WmiObject -ComputerName $row.Name -Class Win32_NetworkAdapterConfiguration | Where-Object { $_.IPaddress } | Select-Object -ExpandProperty IPaddress | Select-Object -First 1 | Where-Object { $_ -notmatch ':' }

      $report1 += $row | 
        Add-Member -MemberType NoteProperty -Name 'OS Edition' -Value $($os.name.split("|")[0]) -PassThru |
        Add-Member -MemberType NoteProperty 'IP Address' -Value $net -PassThru
        $found = $true
      } catch {
      }
      if (-not $found) {
        $reportNotFound += $row
      }
    }

#Write-Verbose ($report1 | Out-String) -Verbose
$report
$report1
$report1 | Export-Csv $reportlocation1 -NoTypeInformation
$reportNotFound | ft -auto

[ganapa2000]

Thank you very much. that worked perfectly 🙂