SOLVED
Home

Site collection listing in SharePoint admin portal

%3CLINGO-SUB%20id%3D%22lingo-sub-28813%22%20slang%3D%22en-US%22%3ESite%20collection%20listing%20in%20SharePoint%20admin%20portal%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-28813%22%20slang%3D%22en-US%22%3E%3CP%3EI%20know%20there%20is%20a%20deep%20link%20between%20the%20SP%20site%20created%20by%20MS%20Teams%20and%20Office%20365%20which%20can%20be%20jeopardized%26nbsp%3Bif%20an%20admin%20deletes%20the%20site%20collection%20%E2%80%93%20but%20is%20there%20a%20way%20to%20see%20a%20listing%20of%20these%20sites%20somewhere%20in%20SP%20admin%20portal%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20very%20much%20like%20to%20know%20how%20many%20team%20sites%20are%20out%20there%20and%20how%20much%20data%20they%20are%20consuming.%20Right%20now%20this%20information%20is%20not%20available%20via%20SP%20Admin%20portal%20in%20my%20tenant.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-28813%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-133095%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Site%20collection%20listing%20in%20SharePoint%20admin%20portal%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-133095%22%20slang%3D%22en-US%22%3EHi%20Mark%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20thought%20I%20had%20read%20this%20elsewhere%20but%20I%20am%20struggling%20to%20find%20any%20mention%20of%20it.%3CBR%20%2F%3E%3CBR%20%2F%3EDo%20you%20know%20how%20close%20Microsoft%20are%20to%20allowing%20modern%20team%20sites%20connected%20to%20Office%20365%20groups%20to%20be%20visible%20in%20SharePoint%20Admin%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%2C%3CBR%20%2F%3E%3CBR%20%2F%3EAndy.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-30492%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Site%20collection%20listing%20in%20SharePoint%20admin%20portal%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-30492%22%20slang%3D%22en-US%22%3E%3CP%3EAndrew%20-%20I%20did%20test%20this%20before%20and%20cannot%20recall%20on%20top%20of%20my%20head%20if%20it%20was%20working%20before%20or%20not%20but%20you%20are%20correct%20I%20dont%20see%20those%20sites%20in%20powershell%20either.%20If%20i%20explicitly%20call%20the%20specific%20site%20with%20Get-SPOSite%20then%20it%20works.%20The%20listing%20does%20not%20work%20in%20powershell%20either.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F8711%22%20target%3D%22_blank%22%3E%40Vlad%20Catrinescu%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F96%22%20target%3D%22_blank%22%3E%40Mark%20Kashman%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F4163%22%20target%3D%22_blank%22%3E%40Andrew%20Warland%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-30392%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Site%20collection%20listing%20in%20SharePoint%20admin%20portal%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-30392%22%20slang%3D%22en-US%22%3E%3CP%3EVlad%2C%20our%20SharePoint%20Administrator%20(with%20O365%20Admin)%20ran%20this%20script%20and%20it%20returned%20only%20the%20list%20of%20sites%20we%20can%20already%20see.%20Still%20cannot%20see%20the%20sites%20creates%20via%20teams%20and%20groups.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20we%20missing%20something%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-29195%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Site%20collection%20listing%20in%20SharePoint%20admin%20portal%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-29195%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20aware%20of%20the%20powershell%20option%20-%20looking%20forward%20to%20the%20UI%20enhancement%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-29015%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Site%20collection%20listing%20in%20SharePoint%20admin%20portal%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-29015%22%20slang%3D%22en-US%22%3E%3CP%3ETo%20add%20to%20what%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F96%22%20target%3D%22_blank%22%3E%40Mark%20Kashman%3C%2FA%3E%26nbsp%3Bsaid%2C%20the%20PowerShell%20cmdlet%20you%20could%20use%20is%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGet-SPOSite%20%7C%20Select%20URL%2C%20StorageQuota%2C%20StorageUsageCurrent%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20don't%20know%20how%20to%20connect%20to%20Office%20365%20using%20PowerShell%2C%20%26nbsp%3Bcheck%20out%26nbsp%3B%3CA%20href%3D%22http%3A%2F%2Fpowershell.office.com%2Fget-started%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fpowershell.office.com%2Fget-started%3C%2FA%3E%20or%20this%20Pluralsight%20course%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.pluralsight.com%2Fcourses%2Fpowershell-office-365%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.pluralsight.com%2Fcourses%2Fpowershell-office-365%3C%2FA%3E%20%26nbsp%3Bif%20you%20have%20a%20Pluralsight%20subscription.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-29009%22%20slang%3D%22en-US%22%3ERE%3A%20Site%20collection%20listing%20in%20SharePoint%20admin%20portal%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-29009%22%20slang%3D%22en-US%22%3EThe%20team%20is%20working%20on%20making%20the%20modern%20team%20sites%20connected%20to%20Office%20365%20groups%20more%20visible%20in%20the%20admin%20UI%3B%20but%20for%20today%2C%20an%20admin%20can%20run%20a%20Powershell%20command%20to%20find%20all%20site%20collections%2C%20modern%20and%20classic%20across%20their%20tenant.%3C%2FLINGO-BODY%3E
Jasjit Chopra
MVP

I know there is a deep link between the SP site created by MS Teams and Office 365 which can be jeopardized if an admin deletes the site collection – but is there a way to see a listing of these sites somewhere in SP admin portal?

 

I would very much like to know how many team sites are out there and how much data they are consuming. Right now this information is not available via SP Admin portal in my tenant.

6 Replies
Solution
The team is working on making the modern team sites connected to Office 365 groups more visible in the admin UI; but for today, an admin can run a Powershell command to find all site collections, modern and classic across their tenant.

To add to what @Mark Kashman said, the PowerShell cmdlet you could use is:

 

Get-SPOSite | Select URL, StorageQuota, StorageUsageCurrent  

 

If you don't know how to connect to Office 365 using PowerShell,  check out http://powershell.office.com/get-started or this Pluralsight course https://www.pluralsight.com/courses/powershell-office-365  if you have a Pluralsight subscription. 

I was aware of the powershell option - looking forward to the UI enhancement :)

Vlad, our SharePoint Administrator (with O365 Admin) ran this script and it returned only the list of sites we can already see. Still cannot see the sites creates via teams and groups.

 

Are we missing something?

Andrew - I did test this before and cannot recall on top of my head if it was working before or not but you are correct I dont see those sites in powershell either. If i explicitly call the specific site with Get-SPOSite then it works. The listing does not work in powershell either.

@Vlad Catrinescu

@Mark Kashman

@Andrew Warland

Hi Mark,

I thought I had read this elsewhere but I am struggling to find any mention of it.

Do you know how close Microsoft are to allowing modern team sites connected to Office 365 groups to be visible in SharePoint Admin?

Thanks,

Andy.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies