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

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. 

Highlighted

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

Highlighted

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?

Highlighted

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
Importer is not working
Stoni1350 in OneDrive for Business on
0 Replies
unable to apply PNP template due to MFA
gadagottiraj in SharePoint on
0 Replies
How to do license management
Ted123 in Office 365 on
2 Replies
Share Button added to the Toolbar!
HotCakeX in Discussions on
13 Replies
OneDrive for Business App will not start
MrDavo in OneDrive for Business on
0 Replies