SOLVED

Is there a way to see all Office 365 Groups in a tenant? Full admin rights.

%3CLINGO-SUB%20id%3D%22lingo-sub-122742%22%20slang%3D%22en-US%22%3EIs%20there%20a%20way%20to%20see%20all%20Office%20365%20Groups%20in%20a%20tenant%3F%20Full%20admin%20rights.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-122742%22%20slang%3D%22en-US%22%3E%3CP%3EI%20know%20I%20can%20see%20the%20group%20names%20in%20the%20Office%20365%20Admin%20panel%20under%20Groups%2C%20but%20that%20only%20shows%20me%20the%20members.%20I%20need%20the%20URL.%20Right%20now%20the%20only%20way%20I%20know%20to%20see%20what%20is%20going%20on%20in%20a%20group%20is%20to%20add%20me%20to%20the%20group%20through%20that%20panel%2C%20then%20wait%20up%20to%203%20hrs%20for%20the%20group%20to%20show%20up%20in%20OWA.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20am%20looking%20for%20is%20something%20similar%20to%20when%20you%20go%20to%20the%20main%20Sharepoint%20site%20for%20an%20Office%20365%20Tenant%2C%20Site%20Settings%2C%20then%20Site%20Hierarchy%2C%20which%20shows%20all%26nbsp%3B%3CEM%3ESharepoint%3C%2FEM%3E%20sites%2C%20with%20URLs%20and%20management%20links%2C%20regardless%20of%20whether%20or%20not%20I%20am%20a%20member.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-122742%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EGroups%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-124374%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20way%20to%20see%20all%20Office%20365%20Groups%20in%20a%20tenant%3F%20Full%20admin%20rights.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-124374%22%20slang%3D%22en-US%22%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3EThat%20only%20shows%20those%20with%20activity%20up%20to%20180%20days%20ago%2C%20included%20deleted%20groups%2C%20and%20I%20cannot%20tell%20that%20it%20actually%20shows%20anything%20but%20%22groups%22%20in%20the%20root%20site%20column.%20It%20is%20better%20than%20what%20I%20have%20now%2C%20but%20an%20intermediate%20solution%20at%20best.%20Thanks.%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3ENo%20it%20doesn't%2C%20it%20shows%20everything%20in%20your%20tenant%2C%20you'll%20see%20entries%20with%20no%20last%20modified%20date%20etc.%20The%20root%20column%20will%20show%20things%20like%20team%20sites%2C%20communication%20sites%2C%20video%20portals%20etc.%20All%20groups%20have%20groups%20sites%2C%20whether%20created%20from%20Yammer%2C%20Outlook%2C%20Teams%20etc.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-124367%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20way%20to%20see%20all%20Office%20365%20Groups%20in%20a%20tenant%3F%20Full%20admin%20rights.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-124367%22%20slang%3D%22en-US%22%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1292%22%20target%3D%22_blank%22%3E%40Steven%20Collier%3C%2FA%3E%20wrote%3A%3CBR%20%2F%3E%3CP%3EOffice%20365%20Admin%20%26gt%3B%20Usage%20Reports%20%26gt%3B%20SharePoint%20Site%20Usage.%20Add%20the%20column%20for%20Root%20Site%20and%20export%20to%20Excel.%20Filter%20in%20Excel%20by%20Group%20type.%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3EThat%20only%20shows%20those%20with%20activity%20up%20to%20180%20days%20ago%2C%20included%20deleted%20groups%2C%20and%20I%20cannot%20tell%20that%20it%20actually%20shows%20anything%20but%20%22groups%22%20in%20the%20root%20site%20column.%20It%20is%20better%20than%20what%20I%20have%20now%2C%20but%20an%20intermediate%20solution%20at%20best.%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-122877%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20way%20to%20see%20all%20Office%20365%20Groups%20in%20a%20tenant%3F%20Full%20admin%20rights.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-122877%22%20slang%3D%22en-US%22%3E%3CP%3EOffice%20365%20Admin%20%26gt%3B%20Usage%20Reports%20%26gt%3B%20SharePoint%20Site%20Usage.%20Add%20the%20column%20for%20Root%20Site%20and%20export%20to%20Excel.%20Filter%20in%20Excel%20by%20Group%20type.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-122825%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20way%20to%20see%20all%20Office%20365%20Groups%20in%20a%20tenant%3F%20Full%20admin%20rights.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-122825%22%20slang%3D%22en-US%22%3E%3CP%3EThanks.%20Your%20definition%20of%20%22easily%22%20is%20different%20from%20mine.%20Not%20a%20PowerShell%20user.%20Small%20company%20so%20no%20real%20power%20shell%20users%20here.%20Anything%20we%20do%20with%20powershell%20out%20of%20necessity%20is%20after%20lots%20of%20googling.%3CBR%20%2F%3E%3CBR%20%2F%3EBut%20the%20command%20you%20sent%20is%20noted%20and%20I'll%20look%20into%20it.%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-122823%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20way%20to%20see%20all%20Office%20365%20Groups%20in%20a%20tenant%3F%20Full%20admin%20rights.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-122823%22%20slang%3D%22en-US%22%3EYou%20can%20also%20get%20Groups%20URLs%20using%20SPO%20cmdlets...and%20the%20upcoming%20SPO%20Admin%20Center%20will%20allow%20you%20to%20easily%20see%20Groups%20sites%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-122811%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20way%20to%20see%20all%20Office%20365%20Groups%20in%20a%20tenant%3F%20Full%20admin%20rights.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-122811%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20an%20admin%2C%20you%20can%20easily%20get%20the%20URLs%20via%20PowerShell%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3EGet-UnifiedGroup%20%7C%20ft%20Name%2CAlias%2CSharePointSiteUrl%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Regular Contributor

I know I can see the group names in the Office 365 Admin panel under Groups, but that only shows me the members. I need the URL. Right now the only way I know to see what is going on in a group is to add me to the group through that panel, then wait up to 3 hrs for the group to show up in OWA.

 

What I am looking for is something similar to when you go to the main Sharepoint site for an Office 365 Tenant, Site Settings, then Site Hierarchy, which shows all Sharepoint sites, with URLs and management links, regardless of whether or not I am a member.

6 Replies

As an admin, you can easily get the URLs via PowerShell:

 

Get-UnifiedGroup | ft Name,Alias,SharePointSiteUrl
You can also get Groups URLs using SPO cmdlets...and the upcoming SPO Admin Center will allow you to easily see Groups sites

Thanks. Your definition of "easily" is different from mine. Not a PowerShell user. Small company so no real power shell users here. Anything we do with powershell out of necessity is after lots of googling.

But the command you sent is noted and I'll look into it. Thanks!

best response confirmed by Christophe Fiessinger (Microsoft)
Solution

Office 365 Admin > Usage Reports > SharePoint Site Usage. Add the column for Root Site and export to Excel. Filter in Excel by Group type.


@Steven Collier wrote:

Office 365 Admin > Usage Reports > SharePoint Site Usage. Add the column for Root Site and export to Excel. Filter in Excel by Group type.


That only shows those with activity up to 180 days ago, included deleted groups, and I cannot tell that it actually shows anything but "groups" in the root site column. It is better than what I have now, but an intermediate solution at best. Thanks.



That only shows those with activity up to 180 days ago, included deleted groups, and I cannot tell that it actually shows anything but "groups" in the root site column. It is better than what I have now, but an intermediate solution at best. Thanks.


No it doesn't, it shows everything in your tenant, you'll see entries with no last modified date etc. The root column will show things like team sites, communication sites, video portals etc. All groups have groups sites, whether created from Yammer, Outlook, Teams etc.