Hi,
I run the following script to export the users' list and their information. Is there a way to filter out only based on the county multiple usage locations (example: IN, US, UK, DE and JP).?
$Users = invoke-command -ScriptBlock {(Get-CsOnlineUser -Filter {(AssignedPlan -eq 'Teams') -and (accountenabled -eq $True)} -ResultSize 50000) | Where-Object {$_.SoftDeletionTimeStamp -eq $null} | Select-Object `
UserPrincipalName, SipAddress, OnPremLineUri, LineUri, City}
thank you,
Regards,
MS
Hello @MS-5605
Thank you for your post.
I hope this is what you are looking for so, see it below:
BR,
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.
Thank you. But I want to add multiple locations in the script for now i am able to export "UsageLocation for US (UsageLocation -eq 'US)", how do add more usage locations in the script?
Get-CsOnlineUser -Filter {(AssignedPlan -eq 'Teams') -and (accountenabled -eq $True) -and (UsageLocation -eq 'US')} -ResultSize 10 | Where-Object {$_.SoftDeletionTimeStamp -eq $null} | Select-Object `
UserPrincipalName, SipAddress, OnPremLineUri, LineUri, City
Thanks,
MS
Hi @MS-5605
Do you mean you want to add another UserLocation such as Japan,UK in your script?
Teams forum is mainly focused on the general issue of Microsoft Teams troubleshooting. According to your description. your question is also related to PowerShell script development, so I will also add teams-app-dev tag to your thread. Thanks for your understanding!
tell me, do you mean adding a location to the script as in this example?
bwin
@geruni-5550 . Yes, Not sure how to add multiple locations to this filter (UsageLocation -eq 'US')..
Thank you so much.
@MS-5605 - Is this related to Teams App development?
For questions related to Powershell Microsoft PowerShell Community forum
@MS-5605
Teams tag is mainly focused on the general issue of Microsoft Teams troubleshooting. Considering your question is also related to PowerShell command, we also recommend you add the tag "windows-server-powershell". Thanks for your understanding and patience!
A bit late, but as this didn't seem to get answered. You just need to add OR statements to your filter.
For example..
Get-CsOnlineUser -Filter {(AssignedPlan -eq 'Teams') -and (accountenabled -eq $True) -and ((UsageLocation -eq 'US') -or (UsageLocation -eq 'JP') -or (UsageLocation -eq 'UK'))} -ResultSize 10
23 people are following this question.
