Forum Discussion
Ethan Stern
Mar 04, 2020Iron Contributor
Powershell script to find out Teams policies by users
Hey everyone, do you know if there is a way to run a script to find what Teams policies are assigned to what user? We have a private channel policy in place- I would like to find out a list of users...
SanatKMahapatra
Jul 19, 2021Copper Contributor
JohnLockett Dlewis-79 .. Thank you for the details and confirmation, it's really helpful.
I have only 1 query, It took 2.5+ days and the query was still running which collected over 38000+ User objects, however, I had to cancel as it entered today production hours.
Is there any way to limit or place a condition like CountryCode or ExtensionAttribute or CustomAttribute to pull a more small and specific report.
I have only 1 query, It took 2.5+ days and the query was still running which collected over 38000+ User objects, however, I had to cancel as it entered today production hours.
Is there any way to limit or place a condition like CountryCode or ExtensionAttribute or CustomAttribute to pull a more small and specific report.
JohnLockett
Jul 19, 2021Copper Contributor
Yes, you can update the top of the script to use a filter and select the attributes you want to filter on. I would suggest you query some of your users and verify that the Teams PS Module sees those attributes before trying it. For example:
Get-CsOnlineUser -Filter {CountryAbbreviation -eq "US"}
OR
Get-CsOnlineUser -Filter {City -eq "Phoenix"}
OR
Get-CsOnlineUser -Filter {(City -eq "Dallas") -or (City -eq "Phoenix")}
- SanatKMahapatraJul 20, 2021Copper ContributorThank you so much Dlewis-79 & JohnLockett for the inputs, I will reduce the amount of information needed for the first complete run even though I need all the attributes in the Info section of the script. Will apply the Filters to the Get-CSOnlineUser command.
Cheers!