How to write exception details to csv

0
votes
Import-Module ActiveDirectory
$computers = Get-ADComputer -Filter * -SearchBase "OU=workstations,DC=company,DC=org" |
             Select-Object -Expand Name 
$wmiObjs = Get-WmiObject -Class Win32_ComputerSystem -Property Name, Model -ComputerName $computers |
           select Name, Model |
           Export-Csv c:\temp\workstations-models.csv

I am getting errors like the below which I would like to have placed into the CSV as well and with txt it is down with PC name:

Get-WmiObject : The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
At line:3 char:12
+ $wmiObjs = Get-WmiObject -Class Win32_ComputerSystem -Property Name,  ...
+            ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [Get-WmiObject], COMException
    + FullyQualifiedErrorId : GetWMICOMException,Microsoft.PowerShell.Commands.GetWmiObjectCommand
1
powershellwmiexport-to-csv

1 Answers

4
votes

Sounds like you need a Try/Catch in a ForEach loop. I think something like this should do it for you:

Import-Module ActiveDirectory
$computers = Get-ADComputer -Filter * -SearchBase "OU=workstations,DC=company,DC=org" |
             Select-Object -Expand Name 
$wmiobjects = ForEach($Computer in $Computers){
    Try{
        Get-WmiObject -Class Win32_ComputerSystem -Property Name, Model -ErrorAction Stop -ComputerName $Computer |
            select Name, Model
    }Catch{
        [PSCustomObject]@{'Name'=$Computer;'Model'='Offline'}
    }
}

$wmiobjects | Export-Csv c:\temp\workstations-models.csv -NoTypeInformation