主页 / coding / 问题 / 79227113
Accepted
NeoGenesis521
Asked: 2024-11-26 22:27:59 +0800 CST

如何在 c# 中的 PSCommand 中使用 Where-Object？

  • 772

我正在创建多个条件语句来查看不同的 PowerShell 命令。我遇到的一个问题是get-hotfix我想使用，where-object但当我调用 PSCommand 时，我得到了这个错误

System.Management.Automation.RemoteException: '无法绑定参数 'FilterScript'。无法将类型为“System.String”的“$_.InstalledOn -gt $StartTimeGenerated”值转换为类型为“System.Management.Automation.ScriptBlock”。'

这是我的代码：

if(command == "get-hotfix")
{
    _HotFixViewAll = ReadInfo("ViewAllHotFix");
    _hotfixInterval = Convert.ToDecimal(ReadInfo("HotFixInterval"));

    if (_HotFixViewAll != "Y")
    {
        DateTime DateNow = DateTime.Now;
        TimeSpan datetimeInterval = TimeSpan.FromDays((double)_hotfixInterval);
        DateTime StartTimeGenerated = DateNow.Subtract(datetimeInterval);

        var filterScript = ScriptBlock.Create("$_.InstalledOn -gt $StartTimeGenerated");
        var whereCommand = new Command("Where-Object");
        whereCommand.Parameters.Add("FilterScript", filterScript);
        whereCommand.Parameters.Add("ArgumentList", StartTimeGenerated);
        pipeline.Commands.Add(whereCommand);
    }

    var sortCommand = new Command("Sort-Object");
    sortCommand.Parameters.Add("Property", "InstalledOn"); 
    sortCommand.Parameters.Add("Descending");
    pipeline.Commands.Add(sortCommand);
}

我该如何解决这个问题？

全面方法

                using (var runspace = RunspaceFactory.CreateRunspace(connectioninfo))
                {
                    runspace.Open();
                    using (var pipeline = runspace.CreatePipeline())
                    {
                        // Command to execute remotely
                        var psCommand = new Command(command);
                        pipeline.Commands.Add(psCommand);

                        if(command == "get-hotfix")
                        {
                            _HotFixViewAll = ReadInfo("ViewAllHotFix");
                            _hotfixInterval = Convert.ToDecimal(ReadInfo("HotFixInterval"));

                            if (_HotFixViewAll != "Y")
                            {
                                DateTime DateNow = DateTime.Now;
                                TimeSpan datetimeInterval = TimeSpan.FromDays((double)_hotfixInterval);
                                DateTime StartTimeGenerated = DateNow.Subtract(datetimeInterval);

                                var filterScript = ScriptBlock.Create("$_.InstalledOn -gt $StartTimeGenerated");
                                var whereCommand = new Command("Where-Object");
                                whereCommand.Parameters.Add("FilterScript", filterScript);
                                whereCommand.Parameters.Add("ArgumentList", StartTimeGenerated);
                                pipeline.Commands.Add(whereCommand);
                            }

                            var sortCommand = new Command("Sort-Object");
                            sortCommand.Parameters.Add("Property", "InstalledOn"); // Sort by InstalledOn column
                            sortCommand.Parameters.Add("Descending"); // Sort in descending order
                            pipeline.Commands.Add(sortCommand);
                        }
                        else if (command == "Get-ADDomainController")
                        {
                            psCommand.Parameters.Add("Server", machinename); // Add the target parameter
                        }
                        else if(command == "Get-ADReplicationPartnerMetadata")
                        {
                            psCommand.Parameters.Add("Server", machinename); // Add the target parameter
                        }

                        // Execute the command
                        var results = pipeline.Invoke();
c#

1 个回答

  1. Best Answer

    您当前的方法存在 2 个问题，首先，ArgumentList 不存在作为 的参数Where-Object。第二个问题更复杂，因为您使用的是connectionInfo: RunspaceFactory.CreateRunspace(connectioninfo)，所有内容都经过序列化，因此尝试将脚本块传递到远程会话：ScriptBlock.Create("$_.InstalledOn -gt $StartTimeGenerated");将失败。

    在 PowerShell 端，以下代码可以证明这一点：

    $proc = Start-Process powershell -PassThru
$connection = [System.Management.Automation.Runspaces.NamedPipeConnectionInfo]::new($proc.Id)
$rs = [runspacefactory]::CreateRunspace($connection)
$rs.Open()
$pipeline = $rs.CreatePipeline()
$pipeline.Commands.Add('Get-HotFix')
$where = [System.Management.Automation.Runspaces.Command]::new('Where-Object')
$where.Parameters.Add(
    'FilterScript',
    [scriptblock]::Create('$_.InstalledOn -gt [datetime]::Now.AddMonths(-1)'))
$sort = [System.Management.Automation.Runspaces.Command]::new('Sort-Object')
$sort.Parameters.Add('Property', 'InstalledOn')
$sort.Parameters.Add('Descending')
$null = $pipeline.Commands.Add($where)
$null = $pipeline.Commands.Add($sort)
$pipeline.Invoke()
$proc.Kill()

    上述操作失败，问题与您遇到的问题相同：

    无法将“$_.InstalledOn -gt [datetime]::Now.AddMonths(-1)”值从“System.String”类型转换为“System.Management.Automation.ScriptBlock”类型。

    在这种情况下我能想到的最简单的解决方案是使用Where-Object 比较语句而不是脚本块，使用这种方法你根本不需要创建脚本块：

    $proc = Start-Process powershell -PassThru
$connection = [System.Management.Automation.Runspaces.NamedPipeConnectionInfo]::new($proc.Id)
$rs = [runspacefactory]::CreateRunspace($connection)
$rs.Open()
$pipeline = $rs.CreatePipeline()
$pipeline.Commands.Add('Get-HotFix')
$where = [System.Management.Automation.Runspaces.Command]::new('Where-Object')
$where.Parameters.Add("Property", "InstalledOn")
$where.Parameters.Add('GT')
$where.Parameters.Add('Value', [datetime]::Now.AddMonths(-1))
$sort = [System.Management.Automation.Runspaces.Command]::new('Sort-Object')
$sort.Parameters.Add('Property', 'InstalledOn')
$sort.Parameters.Add('Descending')
$null = $pipeline.Commands.Add($where)
$null = $pipeline.Commands.Add($sort)
$pipeline.Invoke()
$proc.Kill()

    值得一提的是，虽然不相关，但是CreatePipeline()一种旧 API。您应该更喜欢PowerShell流畅的 API。

    总结一下，修复这个问题的方法如下：

    using System;
using System.Management.Automation;
using System.Management.Automation.Runspaces;

using Runspace runspace = RunspaceFactory.CreateRunspace(connectioninfo);
runspace.Open();

using PowerShell powerShell = PowerShell.Create();
powerShell.Runspace = runspace;
// Command to execute remotely
// (don't need to create `Command` instance, a string can work)
powerShell.AddCommand(command);

if (command == "Get-Hotfix")
{
    _HotFixViewAll = ReadInfo("ViewAllHotFix");
    _hotfixInterval = Convert.ToDecimal(ReadInfo("HotFixInterval"));

    if (_HotFixViewAll != "Y")
    {
        DateTime DateNow = DateTime.Now;
        TimeSpan datetimeInterval = TimeSpan.FromDays((double)_hotfixInterval);
        DateTime StartTimeGenerated = DateNow.Subtract(datetimeInterval);

        // here you can use the approach shown in the PowerShell code
        // with the fluent API, this can be:
        powerShell
            .AddCommand("Where-Object")
            .AddParameter("Property", "InstalledOn")
            .AddParameter("GT")
            .AddParameter("Value", StartTimeGenerated);
    }

    powerShell
        .AddCommand("Sort-Object")
        .AddParameter("Property", "InstalledOn") // Sort by InstalledOn column
        .AddParameter("Descending"); // Sort in descending order
}

// then
powerShell.Invoke();
    • 1

相关问题