Where Command not Working?

Asked Jul 20 '16 at 17:47

Active Jul 20 '16 at 18:03

Viewed 50 times

So I've used the where command a lot with Powershell, but for some reason it doesn't want to work with me in this instance.

$blockdata | select userprincipalname, blockcredential | where blockcredential -eq False

I simply want to return the items in blockdata that are not blocked (False). blockdata has the userprincipalname and blockcredential for multiple people. I tried to only grab users with a 'False' blockcredential when I made the blockdata varaiable, but even therer it wouldn't work"

$block = $upns | % {
   Get-MsolUser -UserPrincipalName $_.userprincipalname | select userprincipalname, blockcredential | where blockcredential -eq False
   }

I've tried putting quotes around false, but it doesn't help. Still just returns nothing. Can anyone help me out? This is what $block looks like when I out it through the where statement...

asked Jul 20 '16 at 17:47

Luke K

4

`False` -> `$False` – user4003407 Jul 20 '16 at 17:49
1

Or `Where {-not $_.BlockCredential}` – Mathias R. Jessen Jul 20 '16 at 17:54
Thank you so much! – Luke K Jul 20 '16 at 18:01
@PetSerAl post an answer – Mathias R. Jessen Jul 20 '16 at 18:04
@MathiasR.Jessen Is not we have good duplicate target for this? This look like already asked before. – user4003407 Jul 20 '16 at 18:07
@PetSerAl probably, let me see what I can dig out – Mathias R. Jessen Jul 20 '16 at 18:07
@PetSerAl Can't decide between [this (exact answer but shameless plugging + not accepted)](http://stackoverflow.com/questions/33757188/powershell-loop-only-if-condition-is-true) or [this (accepted but incomplete)](http://stackoverflow.com/questions/26015072/why-is-false-eq-true) – Mathias R. Jessen Jul 20 '16 at 18:10
@MathiasR.Jessen Yes, it is hard decision. How about coin flip? – user4003407 Jul 20 '16 at 18:17
@PetSerAl alright, [google says I get to plug my own answer](http://i.imgur.com/RThcNJN.png) :-D – Mathias R. Jessen Jul 20 '16 at 18:19

Where Command not Working?

0 Answers0