powershell version

Question

Hi All
i am local admin on all the servers, i have servers in csv file in the below format, i want to get PowerShell version on all the servers using the below PowerShell script but i am getting RPC error
hostnames
server01.contos.com
server02.contoso.com

$hostnames = get-content c:\servers.csv
foreach ($hostname in $hostnames)
{
$os = Get-WmiObject -ComputerName $hostname -Class Win32_OperatingSystem | select-object CSName,Caption,BuildNumber
$psver = Invoke-Command -ComputerName $hostname -Scriptblock {$PSVersionTable.psversion.Build} -ErrorAction SilentlyContinue
Export-CSV C:\output.csv -NoTypeInformation -Append
}

i am getting the below error

Get-WmiObject : The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
At C:\script.ps1:5 char:7

• $os = Get-WmiObject -ComputerName $hostname -Class Win32_OperatingSys ...
• ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
• CategoryInfo : InvalidOperation: (:) [Get-WmiObject], COMException
• FullyQualifiedErrorId : GetWMICOMException,Microsoft.PowerShell.Commands.GetWmiObjectCommand

Answer 1

Is your input file really a CSV? If it is, the first line will be a "header" that contains the column names and not the name of a computer.

Assuming you have a CSV and that there's a column named "Hostname", try this:

Import-CSV c:\servers.csv |
ForEach-Object{
    $os = Get-WmiObject -ComputerName $_.Hostname -Class Win32_OperatingSystem | 
        select-object CSName,Caption,BuildNumber
    Try{
        $psver = Invoke-Command -ComputerName $_.Hostname -Scriptblock {$PSVersionTable.psversion.Build} -ErrorAction STOP
    }
    Catch{
        $psver = "Not Found:  $_"
    }
    Add-Member -InputObject $os -MemberType NoteProperty -Name PSVersion -Value $psver
    $os
} |
    Export-CSV C:\output.csv -NoTypeInformation

Also, your code won't export anything because you aren't feeding the Export-CSV any data.

Answer 2

Hi @Glenn Maxwell ,

The error below is normally the result you get when a machine is either not reachable, it could be for example offline, or when the firewall is blocking you from querying the Windows Management Instrumentation (WMI):

Get-WmiObject : The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)

I'd check that the "Windows Management Instrumentation (WMI-In)" rule is enabled in the firewall for each remote machine.

----------

(If the reply was helpful please don't forget to upvote or accept as answer, thank you)

Best regards,
Leon

Answer 3

Hi，
Are these servers all available？If yes, please use Import-Csv to read CSV files as Get-Content doesn't handle the column headers correctly.

Best Regards,
Ian

Answer 4

Import-Csv : Cannot bind parameter 'Delimiter'. Cannot convert value "C:\servers.csv"
to type "System.Char". Error: "String must be exactly one character long."
At C:\script.ps1:1 char:24

• ... ort-CSV get-content C:\script.ps1 |
• ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
• CategoryInfo : InvalidArgument: (:) [Import-Csv], ParameterBindingException
• FullyQualifiedErrorId : CannotConvertArgumentNoMessage,Microsoft.PowerShell.Commands.ImportCsvCommand