powershell - 将信息写入现有 csv

Question

我现有的 csv 如下所示:

"Name","Surename","Workstation"
"Doe","John","PC1"
"Fonzarelli","Arthur","PC4"
"Tribbiani","Joey","PC77"

现在，我想检查主机是否在线，并将结果写入一个名为“Status”的新列到我的 csv 中。

$file = Import-Csv "C:\Scripts\WS-Status.csv"

Foreach ($ws in $file) {

    If (Test-Connection $ws.Workstation -Count 1 -Quiet) {

        Write-Host $ws.Workstation "is online"
    }

    Else {Write-Host $ws.Workstation "is offline"}

}

它在控制台中工作正常，但我到底如何将结果导出到我的 csv 中？

Answer 1

您可以使用 Add-Member cmdlet 将成员(状态)添加到当前实体:

$file = Import-Csv "C:\Scripts\WS-Status.csv"
Foreach ($ws in $file) 
{
    if (Test-Connection $ws.Workstation -Count 1 -Quiet) 
    {
        Add-Member -InputObject $ws -NotePropertyName "Status" -NotePropertyValue "online"
    }
    else 
    {
        Add-Member -InputObject $ws -NotePropertyName "Status" -NotePropertyValue "offline"
    }
}

$file | Export-Csv "C:\Scripts\WS-Status.csv" -NoTypeInformation