Comments on: Use PowerShell to Create a Report About the Teams Policies Assigned to User Accounts

By: Tony Redmond

Tony Redmond — Mon, 11 Sep 2023 09:01:44 +0000

In reply to Vish. Try: Get-CsOnlineuser | where-Object {$Null -eq $_.TeamsAppPermissionPolicy} | Format-Table DisplayName

By: Vish

Vish — Mon, 11 Sep 2023 07:16:43 +0000

Hi Tony,

I would like to only extract list of users who has been assigned to the “Global’ app permission policy
Get-CsOnlineUser -Filter {TeamsAppPermissionPolicy -eq ”} | Export-CSV

Not sure how to mentioned to extract “Global”, I have tried with $null, blank and global.. no success

Any help plz

By: Tony Redmond

Tony Redmond — Sun, 12 Mar 2023 17:36:57 +0000

In reply to Gilbert.

Of course you’ll need to retrieve the policy information for each user with Get-CsOnlineUser. I meant that you wouldn’t use the cmdlet to fetch the set of users for processing.

Because your CSV file only contains three properties with different names to those returned by Get-CsOnlineUser, the command to fetch details for each user will be something like Get-CsOnlineUser -Identity $User.UPN instead of what’s in the script now.

By: Gilbert

Gilbert — Sun, 12 Mar 2023 16:18:28 +0000

Thanks Tony for the prompt response, I only have 3 user fields in the csv that I’m using SIP, UPN and Email, so I still need to get their policy values with get-csonline user. If I run as is I cant retrieve the users policies

[array]$Users = import-csv ./masterlist_summary1.csv
$Report = [System.Collections.Generic.List[Object]]::new()
# Process each user to fetch their policy assignments
ForEach ($user in $Users) {
$TenantDefaultString = “Tenant Default”
$TenantDialPlan = $TenantDefaultString

By: Tony Redmond

Tony Redmond — Sun, 12 Mar 2023 14:47:19 +0000

In reply to Gilbert.

There are two lines in the script that fetch users and prepare them for processing:

[array]$Users = Get-CsOnlineUser -ResultSize 5000
# Filter the set to get Teams users – this will filter out all but cloud-only Teams users. If you don’t want to use the filter, comment it out.
$Users = $Users | Where-Object {$_.InterpretedUserType -eq “PureOnlineTeamsOnlyUser” -or $_.InterpretedUserType -eq “PureOnlineTeamsOnlyUserFailedPublishingToAAD”} | Sort-Object DisplayName
If (!($Users)) {Write-Host “No users found – exiting”; break }

Replace these lines with:
[array]$Users = Import-CSV filename…

You don’t need to run Get-CsOnlineUser if you’re providing user details another way.

By: Gilbert

Gilbert — Sun, 12 Mar 2023 14:30:57 +0000

Thanks for the reply. Unfortunately I’m not very good at powershell but I can understand how your script is creating the array from up to 5000 users in the tenant.
What I’m confused by is your script has 1 array that is used to get-csonlineuser, retrieves the results for up to 5000 users and then can optionally filter on the array. If I change that $users array to be “[array]$Users = Import-CSV ./Users.csv” then it removes the get-csonlineuser. My question is how do I create an array with my csv AND run get-csonlineuser at the same line of code? I’m not sure how that looks. Really appreciate your help.

By: Tony Redmond

Tony Redmond — Sun, 05 Mar 2023 14:50:45 +0000

In reply to Gilbert.

The script uses these lines of code to find the set of users to process:

Instead, to build the set of users to process from a CSV, you’d use a command like:

[array]$Users = Import-CSV Users.csv

By: Gilbert

Gilbert — Sun, 05 Mar 2023 06:30:55 +0000

Sorry meant to say how can I run the script against users in A CSV. We are migrating users in batches so I only want to report on that rather than running the script against the whole organisation and doing matches in Excel against the migration group.

By: Gilbert

Gilbert — Sun, 05 Mar 2023 06:28:28 +0000

Great script. Can I ask how can I run the script only against users in the CSV (a group of users not the whole organisation)