PowerShell Select-Object Sub-Object with Where Clause

Question

Sorry for the bad naming, I really can't wrap my head around exactly what I am asking for.

If I run this:

Get-MsolUser -UserPrincipalName [email protected] |
    select UserPrincipalName, {$_.StrongAuthenticationMethods.MethodType},
           {$_.StrongAuthenticationMethods.IsDefault}

I get back this:

[email protected]
{PhoneAppOTP, PhoneAppNotification, OneWaySMS, TwoWayVoiceMobile}
{False, True, False, False}

Is there any way for it to return me just the True MethodType from StrongAuthenticationMethods sub-object?

So a return like this:

[email protected]
PhoneAppNotification

I trying to avoid running a lengthy runtime script to loop through each user if I can return the data I need in a single pass.

Ansgar Wiechers · Accepted Answer · 2018-10-18 19:50:33Z

2

Use a calculated property:

Get-MsolUser -UserPrincipalName '[email protected]' |
    Select-Object UserPrincipalName, @{n='AuthenticationMethod';e={
        $_.StrongAuthenticationMethods |
            Where-Object { $_.IsDefault } |
            Select-Object -Expand MethodType
    }}

answered Oct 18, 2018 at 19:50

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

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

Collectives™ on Stack Overflow

PowerShell Select-Object Sub-Object with Where Clause

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related