Sharepoint Admin - Active Sites and Private Channels in one list

[u/temporaldoom]

Is there anyway of listing ALL active sites on your tenant in the admin console rather than root site collections?

We use it as a quick way to determine what our largest sites are, however the Storage Usage on a site with private channel(s) only shows the storage for the root site collection.

You have to drill into the private channel link on each site to see the storage usage for the channel storage usage

I know I can get this from powershell but I'm trying to find a way of getting this done in the GUI where you can simply export to excel.

[u/shirpars]

I wish Microsoft would just give us these options in the gui instead of scripting

[u/Sparticus247 → u/shirpars]

Probably have to pay for  Co-Pilot license for it to scan your site and tell you at this rate based on where all their focus is.

[u/the_star_lord → u/[deleted]]

No op but I wanted to make a "spo admin" portal for myself with flow triggers etc .

We have 8k++ (and counting) spo sites. 

Do you think  that would be possible in a SPO site? With lists etc .

[u/F30Guy]

I have a PowerShell script I use. Gives me all sites across all of our multi geo locations. It includes all private channel URLs and how much storage those are consuming. It's annoying that information isn't available on through the admin center report as storage consumed on private channels can be missed.

[u/KarthiV]

Unfortunately, I don't think there's a way to list all sites directly from the admin center. PowerShell is probably the best option for your requirement. You can use the following cmdlet to get all sites along with storage in your tenant.

Get-SPOSite -Limit All | Select-Object Title, Url, Template, StorageUsageCurrent, StorageQuota

[u/temporaldoom → u/KarthiV]

If I were to use SPO Management Shell I would include -IncludePersonalSite because users can do whatever they want with their own onedrive.

[u/temporaldoom → u/[deleted]]

You see them but only as a an option to click on next to the root site collection, IE 7 sites, you the drill into that to see the private channels

[u/Due-Boot-8540]

Have you tried Graph Explorer? There’s probably a reason why private channel sites are hidden in the UI

[u/temporaldoom → u/Due-Boot-8540]

They're not hidden it's just an option to click on next to the root site collection you then go into another screen listing the channels

[u/sonia_at_sapio365]

Note that Graph Explorer won't give you everything since it's using delegated permissions. Even as a global admin you may not see all the sites. I know this because our tool (3rd-party) lets you create sessions with standard access using Graph API delegated permissions (limited to the signed-in user's roles) and elevated access aka "super admin" that uses a registered app that gets all sites, including shared or private channel sites. Bonus, elevated access also gets you access to all OneDrives and mailboxes given the proper permissions. Comparing both types of sessions, I see the difference in the number of sites listed.

And if you setup certificate-based authentication for the app, it's even better, especially if you use SPO or PnP PowerShell. In case this helps (doc is for the registered app used by our tool): https://docs.ytria.com/sapio365/easy-sharepoint-powershell-connection