远程使用Get-ODBCDSN

Question

我正在尝试编写一个PowerShell脚本，该脚本调用多台远程计算机并收集ODBC DSN用户/系统设置。我有下面的脚本，但是Get-ODBCDSN cmdlet似乎没有远程检索数据的属性。有没有人遇到这个问题，可以提供一些帮助？

$servers = @("SERVER1","SERVER2")
$DSNs  = @("DSN1","DSN2")

foreach ($server in $servers)
{
    write-host `r`n "Getting DSN settings from "$server `r`n
    foreach ($DSN in $DSNs)
    {
        Get-ODBCDSN -name $DSN | Select Name, DsnType, platform, @{n='Description';e={$_.Attribute.server}}
        }
    Write-Output $results | sort name, dsntype
}

Answer 1

我知道这很古老，答案就在评论中，但为了让未来的观众更容易剪切和粘贴……

$servers = @("SERVER1","SERVER2")
$dsns = @("DSN1","DSN2")
foreach ($server in $servers) {
  foreach ($dsn in $dsns) {
    Invoke-Command -computername $server -command {
      Get-ODBCDSN -name $dsn | 
        Select Name, DsnType, @{n='Description';e={$_.Attribute.server}}
    }
    Write-Output $results | sort name, dsntype
  }
}