SOLVED

I want to get list of users to Excel who is using MS Teams with Policies (all) applied to them

%3CLINGO-SUB%20id%3D%22lingo-sub-1602352%22%20slang%3D%22en-US%22%3EI%20want%20to%20get%20list%20of%20users%20to%20Excel%20who%20is%20using%20MS%20Teams%20with%20Policies%20(all)%20applied%20to%20them%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1602352%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20Example%20considering%20Global%20policy%2C%20whom%20it%20is%20applied%20and%20whom%20it%20is%20not%20applied%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1602352%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdministrator%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1602414%22%20slang%3D%22en-US%22%3ERe%3A%20I%20want%20to%20get%20list%20of%20users%20to%20Excel%20who%20is%20using%20MS%20Teams%20with%20Policies%20(all)%20applied%20to%20them%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1602414%22%20slang%3D%22en-US%22%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F766199%22%20target%3D%22_blank%22%3E%40Bhushan001%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20would%20need%20to%20write%20a%20Powershell%20script%20around%20Get-CSUserPolicyAssignment%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fteams%2Fget-csuserpolicyassignment%3Fview%3Dteams-ps%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fteams%2Fget-csuserpolicyassignment%3Fview%3Dteams-ps%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EAnd%20as%20a%20part%20of%20the%20script%20export%20the%20results%20to%20CSV%3CBR%20%2F%3E%3CBR%20%2F%3EOnly%20issue%20here%20is%20that%20the%20powershell%20command%2C%20as%20stated%20in%20the%20article%20does%20not%20support%20multiple%20users%20so%20it%20could%20be%20time%20consuming.%20You%20can't%20do%20it%20from%20the%20TAC.%20AFAIK%20you%20can't%20do%20it%20via%20Graph%20currently%3CBR%20%2F%3E%3CBR%20%2F%3EI%20think%20this%20would%20be%20a%20good%20add%20and%20couldn't%20find%20a%20uservoice%20so%20opened%20on%20for%20you%20here%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F41197888-support-multiple-users-for-get-csuserpolicyassignm%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F41197888-support-multiple-users-for-get-csuserpolicyassignm%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20vote%20up%2C%20you'll%20be%20notified%20if%20Microsoft%20pick%20it%20up%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%20Chris%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

For Example considering Global policy, whom it is applied and whom it is not applied

1 Reply
Highlighted
Best Response confirmed by ThereseSolimeno (Microsoft)
Solution
Hi @Bhushan001

You would need to write a Powershell script around Get-CSUserPolicyAssignment

https://docs.microsoft.com/en-us/powershell/module/teams/get-csuserpolicyassignment?view=teams-ps

And as a part of the script export the results to CSV

Only issue here is that the powershell command, as stated in the article does not support multiple users so it could be time consuming. You can't do it from the TAC. AFAIK you can't do it via Graph currently

I think this would be a good add and couldn't find a uservoice so opened on for you here

https://microsoftteams.uservoice.com/forums/555103-public/suggestions/41197888-support-multiple-user...

If you vote up, you'll be notified if Microsoft pick it up

Best, Chris