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
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
Highlighted
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
SharePoint 2013 LIst Filters (by latest date)
dmphil in SharePoint on
0 Replies
Status Unknown
AlexT88 in Microsoft Teams on
1 Replies
Kaizala Custom Action Photo storage
Lisa_sach in Microsoft Kaizala on
2 Replies
Teams message encryption
Thomas_Steibl in Microsoft Teams on
3 Replies