MS Teams users export issue with "ResultSize" parameter

Question

MS Teams users export issue with "ResultSize" parameter

MS 426

Hi Team,

I am running a script to export a large number of users for data collection, The script runs with out any issues in Teams module 2.3.1, but its not working in 4.0.0 version

Here is the part of the script used to pull out the Teams user data..

Connect-MicrosoftTeams -Credential $credential
Get-CsTenant -Identity xxxxxxxxxxxxx

$session = Get-PSSession - Removing -Session $session from just after invoke-command below

$data = invoke-command -ScriptBlock {get-csonlineuser -Filter 'AssignedPlan -like "TEAMS" -and SoftDeletionTimestamp -eq $Null -and UserAccountControl -ne "AccountDisabled, PasswordNotRequired, NormalAccount"' -ResultSize Unlimited | Select-Object UserPrincipalName, SipAddress, OnPremLineUri, LineUri, AssignedPlan, TeamsMeetingPolicy, TeamsMessagingPolicy, TeamsCallingPolicy, TeamsMeetingBroadcastPolicy,
TeamsAppPermissionPolicy, TeamsCallParkPolicy, OnlineDialOutPolicy, TeamsCortanaPolicy, TeamsUpgradePolicy, OnlineVoicemailPolicy, EnterpriseVoiceEnabled, OnlineVoiceRoutingPolicy, TenantDialPlan, `
HostingProvider, InterpretedUserType, MCOValidationError, City}

$userCount = $data.Count
while($usercount -lt 340000){
write-host "Number of returned users ($userCount) is too low, trying again...please wait.".
#Get-PSSession | Remove-PSSession
Connect-MicrosoftTeams -Credential $credential
Get-CsTenant -Identity 5b973f99-77df-4beb-b27d-aa0c70b8482c
#$session = Get-PSSession - Removing -Session $session from just after invoke-command below
$data = invoke-command -ScriptBlock {get-csonlineuser -Filter 'AssignedPlan -like "TEAMS" -and SoftDeletionTimestamp -eq $Null -and UserAccountControl -ne "AccountDisabled, PasswordNotRequired, NormalAccount"' -ResultSize 'Unlimited'| Select-Object UserPrincipalName, SipAddress, OnPremLineUri, LineUri, AssignedPlan, TeamsMeetingPolicy, TeamsMessagingPolicy, TeamsCallingPolicy, TeamsMeetingBroadcastPolicy,
TeamsAppPermissionPolicy, TeamsCallParkPolicy, OnlineDialOutPolicy, TeamsCortanaPolicy, TeamsUpgradePolicy, OnlineVoicemailPolicy, EnterpriseVoiceEnabled, OnlineVoiceRoutingPolicy, TenantDialPlan, `
HostingProvider, InterpretedUserType, MCOValidationError, City}
$userCount = $data.Count
}

I'm getting the following error "Cannot process argument transformation on parameter 'ResultSize'. Cannot convert value "Unlimited" to type "System.UInt32". Error: "

Any fix for this?
Thanks In Advance...!!

Regards,
MS

Accepted answer

0 additional answers

Your answer

Answer 1

Rich Matheisen 47,901

Try something like this:

Get-CsOnlineUser -Filter 'AssignedPlan -like "*TEAMS*"' -ResultSize 40000 |
    Where-Object {$_.SoftDeletionTimeStamp -eq $null} |
        ForEach-Object{
            $csuser = $_
            Get-ADUser -Identity $_.samaccountname |
                Where-Object {$_.PasswordNotRequired -eq $false -and $_.Enabled -eq $true} |
                    ForEach-Object{
                        [PSCustomObject]@{
                            UserPrincipalName = $_.UserPrincipalName
                            SipAddress = $csuser.SipAddress
                            OnlinePremLineUri = $csuser.OnlinePremLineUri
                            LineUri = $csuser.LineUri
                            AssignedPlan = $csuser.AssignedPlan
                            TeamsMeetingPolicy = $csuser.TeamsMeetingPolicy
                            TeamsMessagingPolicy = $csuser.TeamsMessagingPolicy
                            TeamsCallingPolicy = $csuser.TeamsCallingPolicy
                            TeamsMeetingBroadcastPolicy = $csuser.TeamsMeetingBroadcastPolicy
                            TeamsAppPermissionPolicy = $csuser.TeamsAppPermissionPolicy
                            TeamsCallParkPolicy = $csuser.TeamsCallParkPolicy
                            OnlineDialOutPolicy = $csuser.OnlineDialOutPolicy
                            TeamsCortanaPolicy = $csuser.TeamsCortanaPolicy
                            TeamsUpgradePolicy = $csuser.TeamsUpgradePolicy
                            OnlineVoicemailPolicy = $csuser.OnlineVoicemailPolicy
                            EnterpriseVoiceEnabled = $csuser.EnterpriseVoiceEnabled
                            OnlineVoiceRoutingPolicy = $csuser.OnlineVoiceRoutingPolicy
                            TenantDialPlan = $csuser.TenantDialPlan
                            HostingProvider = $csuser.HostingProvider
                            InterpretedUserType = $csuser.InterpretedUserType
                            MCOValidationError = $csuser.MCOValidationError
                            City = $csuser.City
                        }
                    }
        }

I don't use Skype so I have no way to test this!

Rich Matheisen 47,901 Reputation points

2022-04-03T20:01:25.207+00:00

Seems pretty clear if you read the "help" for that cmdlet!

-ResultSize
Note: Starting with Teams PowerShell Modules version 4.0 and later, "-ResultSize" type has been changed to uint32.

Enables you to limit the number of records returned by the cmdlet. For example, to return seven users (regardless of the number of users that are in your forest) include the ResultSize parameter and set the parameter value to 7. Note that there is no way to guarantee which seven users will be returned.

The result size can be set to any whole number between 0 and 2147483647, inclusive. The value 0 returns no data. If you set the ResultSize to 7 but you have only three users in your forest, the command will return those three users, and then complete without error.
MS 426 Reputation points

2022-04-03T20:43:45.027+00:00

Thanks for the update, I updated the Resultsize 300000, looks like now the issue is bypassed, but now I am seeing the bellow error, what could be the reason and any fix for this?

Thank you so much.

MS
Rich Matheisen 47,901 Reputation points

2022-04-03T21:36:48.073+00:00
If you're using the "-like" operator I'd expect there to be one, or more, wildcard characters in the value on the right side.

AssignedPlan -like "*TEAMS*"

The other part of the filter that looks suspect is UserAccountControl -ne "AccountDisabled, PasswordNotRequired, NormalAccount".

In the Output section of the cmdlet's "help" there is a list of New user attributes and Dropped attributes

In the "Dropped attributes" list you'll find the property UserAccountControl.

Once again, reading the help for the cmdlet is important, and it's imperative when what you're doing doesn't work!
MS 426 Reputation points

2022-04-04T13:33:48.557+00:00

Hi @Rich Matheisen ,

Thank you so much for the Information, I'm not sure what to change for the below script to work, but I'm not finding the correct cmdlet to replace with a working cmdlet, it would be much appreciated if you can help me to get this working following script.

get-csonlineuser -Filter 'AssignedPlan -like "TEAMS" -and SoftDeletionTimestamp -eq $Null -and UserAccountControl -ne "AccountDisabled, PasswordNotRequired, NormalAccount"' -ResultSize 40000 | Select-Object UserPrincipalName, SipAddress, OnPremLineUri, LineUri, AssignedPlan, TeamsMeetingPolicy, TeamsMessagingPolicy, TeamsCallingPolicy, TeamsMeetingBroadcastPolicy,
TeamsAppPermissionPolicy, TeamsCallParkPolicy, OnlineDialOutPolicy, TeamsCortanaPolicy, TeamsUpgradePolicy, OnlineVoicemailPolicy, EnterpriseVoiceEnabled, OnlineVoiceRoutingPolicy, TenantDialPlan, `
HostingProvider, InterpretedUserType, MCOValidationError, City

Thank you so much.

Regards,
MS
MS 426 Reputation points

2022-04-04T18:13:04.047+00:00

Hi @Rich Matheisen

We are not using skype in our environment, it's only Teams.!
I am still seeing the issue "assignedPlans is not supported. it would be great if you can test from your end and share the script please.

Kind Regards,
MS
Rich Matheisen 47,901 Reputation points

2022-04-04T18:45:28.37+00:00

Will you PLEASE read the help for the cmdlet Get-CSOnlineUser?

The property you want to use in the filter is AssignedPlan (without the "s"). You used the correct property name in all the previous code you posted, as did I in the code I submitted.
MS 426 Reputation points

2022-05-03T05:31:49.983+00:00

Thank you so much. After updating unsupported cmdlets in the script (like Resize and SoftDeletionTimeStamp, it's working as expected.

Thank you for the support.

Share via

MS Teams users export issue with "ResultSize" parameter

$session = Get-PSSession - Removing -Session $session from just after invoke-command below

0 additional answers

Your answer