Home

Is there any nice way to get a list of all our Teams and their info?

%3CLINGO-SUB%20id%3D%22lingo-sub-388933%22%20slang%3D%22en-US%22%3EIs%20there%20any%20nice%20way%20to%20get%20a%20list%20of%20all%20our%20Teams%20and%20their%20info%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388933%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20go%20to%20the%20Admin%20area%20in%20O365%20I%20can%20go%20to%20the%20Teams%20page%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fadmin.teams.microsoft.com%2Fteams%2Fmanage%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fadmin.teams.microsoft.com%2Fteams%2Fmanage%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20gives%20me%20a%20list%20of%20all%20my%20teams%2C%20how%20many%20people%20are%20on%20them%2C%20etc.%26nbsp%3B%20However%2C%20there's%20no%20way%20to%20Save%20or%20Export%20that%20list.%26nbsp%3B%20The%20list%20only%20loads%20as%20you%20scroll%20down%20the%20page%20so%20it%20takes%20a%20while%20to%20bring%20them%20all%20up.%26nbsp%3B%20Then%20if%20I%20do%20a%20Select%20All%20or%20try%20to%20click%20and%20drag%2C%20it%20doesn't%20select%20all%20the%20teams%20as%20it%20scrolls.%26nbsp%3B%20I'd%20love%20to%20get%20the%20information%20that%20on%20that%20page%20but%20in%20a%20CSV%2Fspreadsheet%20file%20so%20I%20can%20go%20through%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-388933%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-388940%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20any%20nice%20way%20to%20get%20a%20list%20of%20all%20our%20Teams%20and%20their%20info%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388940%22%20slang%3D%22en-US%22%3EThere%E2%80%99s%20no%20way%20doing%20this%20from%20the%20admin%20center%20for%20now!%20I%E2%80%99m%20sure%20this%20feature%20and%20others%20will%20be%20added%20eventually%20!%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20may%20use%20the%20Microsoft%20graph%20for%20now%20to%20list%20teams%20and%20use%20a%20flow%20or%20script%20to%20export%20them!%3CBR%20%2F%3E%3CBR%20%2F%3EGeneral%20info%20about%20the%20teams%20graph%20API%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Fresources%2Fteams-api-overview%3Fview%3Dgraph-rest-1.0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Fresources%2Fteams-api-overview%3Fview%3Dgraph-rest-1.0%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThere%E2%80%99s%20also%20powershell%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fteams%2Fget-team%3Fview%3Dteams-ps%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fteams%2Fget-team%3Fview%3Dteams-ps%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EAdam%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-824873%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20any%20nice%20way%20to%20get%20a%20list%20of%20all%20our%20Teams%20and%20their%20info%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-824873%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F72542%22%20target%3D%22_blank%22%3E%40adam%20deltinger%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20just%20use%20a%20Chrome%20Extension%20like%20Table%20Capture%20for%20it%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fchrome.google.com%2Fwebstore%2Fdetail%2Ftable-capture%2Fiebpjdmgckacbodjpijphcplhebcmeop%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fchrome.google.com%2Fwebstore%2Fdetail%2Ftable-capture%2Fiebpjdmgckacbodjpijphcplhebcmeop%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1118872%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20any%20nice%20way%20to%20get%20a%20list%20of%20all%20our%20Teams%20and%20their%20info%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1118872%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F47110%22%20target%3D%22_blank%22%3E%40Mike%20Boehm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20now%20use%20the%20Microsoft%20powershell%20teams%20cmdlets%20to%20do%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETheyre%20pretty%20good%20and%20although%2C%20they%20dont%20have%20everything%20that%20we%20want%2Fneed...its%20certainly%20closer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Econnect-microsoftteams%3C%2FP%3E%3CP%3Ethen%3C%2FP%3E%3CP%3Eget-team%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eor%20you%20can%20do%20more%20-%20refer%20to%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fnotbad.tech%2Fall-things-it%2Fmicrosoft-teams-list-all-external-team-members-with-team-owners-and-team-name-part-1%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fnotbad.tech%2Fall-things-it%2Fmicrosoft-teams-list-all-external-team-members-with-team-owners-and-team-name-part-1%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Mike Boehm
Regular Contributor

When I go to the Admin area in O365 I can go to the Teams page:

https://admin.teams.microsoft.com/teams/manage

 

This gives me a list of all my teams, how many people are on them, etc.  However, there's no way to Save or Export that list.  The list only loads as you scroll down the page so it takes a while to bring them all up.  Then if I do a Select All or try to click and drag, it doesn't select all the teams as it scrolls.  I'd love to get the information that on that page but in a CSV/spreadsheet file so I can go through it.

 

Thanks.

3 Replies
There’s no way doing this from the admin center for now! I’m sure this feature and others will be added eventually !

You may use the Microsoft graph for now to list teams and use a flow or script to export them!

General info about the teams graph API:

https://docs.microsoft.com/en-us/graph/api/resources/teams-api-overview?view=graph-rest-1.0

There’s also powershell:


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

Adam
Highlighted
Highlighted

@Mike Boehm 

 

You can now use the Microsoft powershell teams cmdlets to do this.

 

Theyre pretty good and although, they dont have everything that we want/need...its certainly closer.

 

connect-microsoftteams

then

get-team

 

or you can do more - refer to https://notbad.tech/all-things-it/microsoft-teams-list-all-external-team-members-with-team-owners-an...

Related Conversations