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

%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%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%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%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%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%3CLINGO-SUB%20id%3D%22lingo-sub-1388251%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-1388251%22%20slang%3D%22en-US%22%3E%3CP%3ECheck%20my%20Script%20-%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%224%22%3E%3CSTRONG%3EExport%20all%20Teams%20Channels%20and%20all%20members%20in%20Office%20365%20%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.azure365pro.com%2Fexport-all-teams-channels-and-all-members-in-office-365%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.azure365pro.com%2Fexport-all-teams-channels-and-all-members-in-office-365%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1423948%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-1423948%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%3EThis%20script%20helps%20you%20to%3CSPAN%3E%26nbsp%3Bto%20get%20Microsoft%20Teams%20related%20details%20like%20all%20teams%2C%20Channels%20in%20the%20team%2C%20Team%20members%2C%20Team%20owner%2C%20total%20member%20count%2C%20etc.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsing%20this%20script%2C%20you%20can%20generate%208%20different%20Teams%20reports.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fo365reports.com%2F2020%2F05%2F28%2Fmicrosoft-teams-reporting-using-powershell%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fo365reports.com%2F2020%2F05%2F28%2Fmicrosoft-teams-reporting-using-powershell%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Microsoft%20Teams%20Reporting.png%22%20style%3D%22width%3A%20834px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195059iF93808A6F0089529%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Microsoft%20Teams%20Reporting.png%22%20alt%3D%22Microsoft%20Teams%20Reporting.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1682149%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-1682149%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3BThis%20worked%20for%20me%20thank%20you%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F295378%22%20target%3D%22_blank%22%3E%40Kathy_Cooper%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%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%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%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-2023914%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-2023914%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%3EYes!%20I%20have%20discovered%20it%20when%20I%20needed%20to%20download%20a%20list%20of%20over%20800%20users.%20From%20the%20Microsoft%20365%20Admin%20Center%2C%20Go%20to%20the%20Azure%20Active%20Directory%20admin%20center%2C%20then%20Select%20the%20Users%20Tab%20and%20Bulk%20Operation%20Feature%20to%20download%20as%20a%20CSV%20file.%20You%20can%20even%20select%20Users%20as%20Groups%20before%20downloading%20them%20as%20well.%20Hope%20it%20helps%20and%20good%20luck!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2177773%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-2177773%22%20slang%3D%22en-US%22%3ELovely%2C%20thank%20you!%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2594513%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-2594513%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F295378%22%20target%3D%22_blank%22%3E%40Kathy_Cooper%3C%2FA%3E%26nbsp%3B%2C%20it%20seems%20as%20if%20there%20is%20a%20timeout%20when%20pulling%20the%20report%20against%20large%20organizations.%20My%20tenant%20has%2020K%20teams.%20Is%20there%20something%20I%20can%20do%20to%20pull%20the%20entire%20report%3F%20I'm%20running%20-Action%202%2C%20below%20is%20the%20error%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGet-Team%20%3A%20Error%20occurred%20while%20executing%3CBR%20%2F%3ECode%3A%20Authentication_ExpiredToken%3CBR%20%2F%3EMessage%3A%20Your%20access%20token%20has%20expired.%20Please%20renew%20it%20before%20submitting%20the%20request.%3CBR%20%2F%3EInnerError%3A%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2612070%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-2612070%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1115072%22%20target%3D%22_blank%22%3E%40randystinson%3C%2FA%3E%26nbsp%3BWe're%20seeing%20the%20same%20timeout%20issues.%26nbsp%3B%20MSFT%20Premier%20cannot%20solve%20this%20and%20suggest%20the%20script%20is%20faulty.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2644474%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-2644474%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F399107%22%20target%3D%22_blank%22%3E%40qwertyboy12345%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Einstructions%20to%20use%20in%20Teams%20please%3F%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2646071%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-2646071%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F601845%22%20target%3D%22_blank%22%3E%40figjamgle%3C%2FA%3E%20--%20Want%20to%20email%20me%20and%20we%20can%20do%20a%20zoom%20where%20I%20show%20you%20how%20it%20works%3F%20I'm%20at%20ms-teams%40georgemike.com%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2648991%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-2648991%22%20slang%3D%22en-US%22%3EThanks%20for%20offer%20to%20Zoom%3CBR%20%2F%3ELocated%20even%20easier%20option%3CBR%20%2F%3ECheers%20for%20replying%20%3Awhite_heavy_check_mark%3A%3C%2FLINGO-BODY%3E
Super 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.

13 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

@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...

@Mike Boehm 

This script helps you to to get Microsoft Teams related details like all teams, Channels in the team, Team members, Team owner, total member count, etc.

 

Using this script, you can generate 8 different Teams reports.

https://o365reports.com/2020/05/28/microsoft-teams-reporting-using-powershell/

 

Microsoft Teams Reporting.png

Thank you This worked for me thank you @Kathy_Cooper 

@Mike Boehm 

 

Yes! I have discovered it when I needed to download a list of over 800 users. From the Microsoft 365 Admin Center, Go to the Azure Active Directory admin center, then Select the Users Tab and Bulk Operation Feature to download as a CSV file. You can even select Users as Groups before downloading them as well. Hope it helps and good luck!

@Kathy_Cooper , it seems as if there is a timeout when pulling the report against large organizations. My tenant has 20K teams. Is there something I can do to pull the entire report? I'm running -Action 2, below is the error:

 

Get-Team : Error occurred while executing
Code: Authentication_ExpiredToken
Message: Your access token has expired. Please renew it before submitting the request.
InnerError:

@randystinson We're seeing the same timeout issues.  MSFT Premier cannot solve this and suggest the script is faulty.

@qwertyboy12345 

instructions to use in Teams please? thanks

@figjamgle -- Want to email me and we can do a zoom where I show you how it works? I'm at ms-teams@georgemike.com
Thanks for offer to Zoom
Located even easier option
Cheers for replying :white_heavy_check_mark:
www.000webhost.com