For each and where-object

Question

I am trying to add a another where-object condition in the below code, but the syntax fails, what would be the simplest way to achieve that?

foreach ($R in ($VIPResults | Where-Object Status -notmatch "Up|Out Of Service"))

like -and{where-object componentname -match virtualserver}

Answer 1

Like this?

$VIPResults = [PSCustomObject]@{Status='Up';ComponentName='VP1'},
[PSCustomObject]@{Status='Out Of Service';ComponentName='VP1'},
[PSCustomObject]@{Status='Down';ComponentName='VP1'},
[PSCustomObject]@{Status='Up';ComponentName='VP2'}

$virtualserver = 'VP1'
foreach ($R in ( $VIPResults | 
                    Where-Object {($_.Status -notmatch "Up|Out Of Service") -AND $_.componentname -eq $virtualserver})){
    $R
}

Answer 2

When "Status" is a property of the VIPResults, then you have to use $_ as object alias =>

foreach ($R in ($VIPResults | Where-Object $_.Status -notmatch "Up|Out Of Service"))

Answer 3

Hi @Sara ,

it is basically easy to combine two or more where conditions with and and or:

# Example 1: Two "-and" conditions in one Where-Object
foreach ($a in 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) { 
    Write-Output $a | Where-Object { $a -gt 2 -and $a -lt 5 }
}

# Example 2: Two "-and" conditions combined with one "-or" and another two "-and" conditions
foreach ($a in  1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) { 
    Write-Output $a | Where-Object { ($a -gt 2 -and $a -lt 8) -or ($a -gt 10 -and $a -lt 20) }
}
# Example 3: Get local computer services with status "Stopped" and Name of service begins with "W"
Get-Service | Where-Object { $_.Status -eq "Stopped" -and $_.Name -like "W*" }

---

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards Andreas Baumgarten