CODEWITHSUNDEEP
azureazure-powershellazure-active-directory
Sameer
Sameer

Reputation: 3183

Example of Get-AzureADUser [-Filter <String>] command

Command: Get-AzureADUser [-Filter ] command

msdn says Parameters -Filter Specifies an oData v3.0 filter statement. This parameter controls which objects are returned.

how to set filter to get the same result as Azure module v1 commands

Get-MsolUser -All| Where-Object {$_.isLicensed -eq "True"}| Select-Object UserPrincipalName -ExpandProperty Licenses|Select-Object UserPrincipalName -ExpandProperty ServiceStatus|Where-Object {$_.ProvisioningStatus -eq "Success" -and $_.ServicePlan.ServiceName -like "MCO*"}|select UserPrincipalName -Unique

I have searched all over the place to find a proper example of setting filter but could not and i ended up here. I am basically trying to convert my Azure module v1 commands to Azure module v2 commands.

Upvotes: 10

Views: 79653

Answers (4)

js2010
js2010

Reputation: 27428

Here's a createddatetime one. The double quotes have to be on the outside, and the date has to be in that format.

Get-AzureADUser -Filter "createddatetime ge datetime'2023-04-13'"

These fields are unrecognized:

get-azureaduser -filter "CapabilityStatus eq 'Enabled' and service eq 'MicrosoftCommunicationsOnline'"

get-azureaduser : Error occurred while executing GetUsers
Code: Request_UnsupportedQuery
Message: Property 'CapabilityStatus' does not exist as a declared property or extension property.

Can I access something like "signInActivity/lastSignInDateTime"?

Upvotes: 0

AShah
AShah

Reputation: 942

get-azureaduser -all $true -Filter "startswith(UserPrincipalName,'JohnAdam')"

or use variable

get-azureaduser -all $true -Filter "UserPrincipalName eq '$userPrincipalName'"

Upvotes: 2

Sameer
Sameer

Reputation: 3183

This seems to do it

Get-AzureADUser -All $true|select UserPrincipalName -ExpandProperty AssignedPlans|Where-Object {$_.CapabilityStatus -eq "Enabled" -and $_.Service -eq "MicrosoftCommunicationsOnline"} |select UserPrincipalName -Unique

Upvotes: 1

juvchan
juvchan

Reputation: 6245

A few examples of Get-AzureADUser [Filter] command are as below:

Get-AzureADUser -Filter "DisplayName eq 'Juv Chan'"
Get-AzureADUser -Filter "DisplayName eq 'Juv Chan' and UserType eq 'Member'"

This is following the oData 3.0 Filter semantics as specified here.

Note that the Get-AzureADUser cmdlet is only returning 4 fields:

Object Id, Display Name, UserPrincipalName, UserType

Hence, it is not possible to create an equivalent v2 command using the cmdlet above for your v1 command above.

The version of AzureAD PowerShell v2 module tested for the above is 2.0.0.33. https://www.powershellgallery.com/packages/AzureAD/2.0.0.33

Upvotes: 11

Related Questions