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

Highlighted
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
OneDrive for business - IT security check
yasothadevi in SharePoint on
0 Replies
Struggling how to do a calculation
Tim_Jevans in Excel on
4 Replies
Office 365 dependencies
JM206 in Office 365 on
0 Replies
Sharepoint Online Migration
Gaius1050 in SharePoint on
2 Replies
Adding a 'news story' is greyed out
Sophiemeg in SharePoint on
3 Replies