PowerShell WhereObjectCommand from C#

Question

I'm trying to call the following PS script from C#:

Get-MailboxDatabase -IncludePreExchange2007 -Status | Where-Object {$_.Server -eq 'myserver'}

I have managed to execute the first part before the pipe using this code:

  public void Test()
  {
     using (Pipeline pipeline = _runspace.CreatePipeline())
     {
        var cmd1 = new Command("Get-MailboxDatabase");
        cmd1.Parameters.Add("IncludePreExchange2007");
        cmd1.Parameters.Add("Status");

        var cmd2 = new Command("Where-Object");
        //how do I script {$_.Server -eq 'myserver'} ???

        pipeline.Commands.Add(cmd1);
        //pipeline.Commands.Add(cmd2);

        Collection<PSObject> result = pipeline.Invoke();
     }
  }

but how do I script the second part for Where-Object???

SLaks · Accepted Answer · 2012-12-31 17:13:13Z

2

You can simply use LINQ:

result.Where(p => (string)p.Properties["Server"].Value == "myserver"));

answered Dec 31, 2012 at 17:13

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ivan G. Over a year ago

you're right, probably I won't get better performance as this filter will be applied after i get all the results from the first command

Community · Accepted Answer · 2017-05-23 12:31:12Z

0

I am updating this thread in case another user visits this question.

To enhance the performance you can perform filtering in the PowerShell itself and can use Where-Object there. I have provided the answer here: Calling PowerShell's where-object from C#

Essentially, you will need to use Add Script instead of adding command like below:

    //Getting all command variables
    string myServer = "ServerName";

    //Create Script command
    String customScriptText = String.Format("Get-MailboxDatabase -IncludePreExchange2007 -Status | Where-Object {{$_.Server -eq \"{0}\"}}", myServer);

    pipeline.Commands.AddScript(customScriptText);

Note to escape { and } using double curly braces i.e. {{ and }}. Also escape quotes as \" using back slash in the String.Format method.

edited May 23, 2017 at 12:31

CommunityBot

11 silver badge

answered Apr 22, 2016 at 16:18

Aman Sharma

2,0001 gold badge19 silver badges32 bronze badges

Collectives™ on Stack Overflow

PowerShell WhereObjectCommand from C#

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related