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
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
User contributions licensed under CC BY-SA 3.0