Need help placing the Where-Object filter in the correct place

[AGFlora]

HI,

I'm trying to filter out the local datastores but I'm not getting the desired results.

Code:

Get-Datastore | Select @{N="LUN";E={$_.Name}},

                       @{N="Total VMs";E={@($_ | Get-VM).Count}} |

                       Where-Object {$_Name -Notlike "Datastore1*"}

Thanks

[TScalzott · Accepted solution]

As a general rule, you want to filter first where possible for increased efficiency down the pipeline.  That's no exception here:

Try:

Get-Datastore | Where-Object {$_Name -Notlike "Datastore1*"} |

    Select @{N="LUN";E={$_.Name}}, @{N="Total VMs";E={@($_ | Get-VM).Count}}

[AGFlora]

This worked thanks!

Get-Datastore | Where-Object {$_.Name -Notlike "Datastore*"} |

    Select @{N="LUN";E={$_.Name}},

           @{N="Total VMs";E={@($_ | Get-VM).Count}}

and thanks for the tip!