msonline module - where statements not working

[Shadoxity]

Hey Team,
I am trying to get a script working but any time I pipe a "where" or "Where-object" into it, I get zero results.

i.e.
$UserNames = Get-MsolUser -TenantId $tenantid -ALL | Where {($_.licenses).AccountSkuId -ilike "*$($licenseName)"} | Sort-Object DisplayName

If i run the same script locally it works perfectly fine, but just does not work in functions.
If i remove the Where statement it runs fine.

Please help

[Francisco-Gamino]

Hello @Shadoxity -- Thank you for reporting this issue. Are you importing the module using the -UseWindowsPowerShell ?

[Shadoxity]

Yes, definitely.
The module doesnt work unless you do that.

I am wondering if its something to do with "deserialized" objects. as it says this when importing the module.
Module msonline is loaded in Windows PowerShell using WinPSCompatSession remoting session; please note that all input and output of commands from this module will be deserialized objects.

and some more digging I have found the licenses property returns.
"Licenses": [

"Microsoft.Online.Administration.UserLicense"

],

Instead of the actual license names :S
.
So I am not sure where to go from here. I cannot use the azuread module cause it does not work with the partner center delegated admin like it should.
But I need a solution to get this into azure functions asap.

[Francisco-Gamino]

Thanks for the reply @Shadoxity.

There is another potential workaround you can try which uses the Windows PowerShell version in the worker (this is the VM where your function code is executed).

The workaround is described here: #232 (comment).

Here is a full example: https://github.com/eamonoreilly/ManageAzureActiveDirectoryWithPowerShellFunction/blob/master/ManageAzureAD/run.ps1

[Shadoxity]

Great idea, and it seems to work! Just need to work out getting the right output from it!
Genius! Thanks so much for sharing that, that will get me out of trouble for now.

[Francisco-Gamino]

Great to hear the workaround is working. I will follow-up with the PowerShell Team on the serialization issue. Thanks.