Sharepoint Online Reports

[t_brejon]

Hello,

I would to know how I can have reports about Sharepoint on Office 365.

On our tenant we have the default site collection and another one with our entity (Collection_sites.png).

In these collection sites, we have some subsites, and I need to manage and follow update about this site (number of files, size, etc.).

I find the reports screen in Office 365 administration center, but it give me details about Office 365 groups only.

I try to do it in Powershell, but only for Office 365 groups.

How can I have reports about Sharepoint site but not Office 365 groups? I would to automate it.

Thanks in advance for your answer.

[#2]

@t_brejon, take a look at https://admin.microsoft.com/AdminPortal/Home#/reportsUsage/SharePointActivityV1 and https://admin.microsoft.com/AdminPortal/Home#/reportsUsage/SharePointSiteUsageV1. There you can find all types of activity on your SharePoint sites. You can export the stats to Excel and create your own reports based on the data.

Hope this can be useful for you.

Regards,

Margareta

[#3]

@Maggan Wåhlin I already take a look from this reports.

And I only see Office 365 groups site.

For example, I have a site under this site collection: https://mytenant.sharepoint.com/sites/PALALDA ; Named IsoTeam, so his URL is: https://mytenant.sharepoint.com/sites/PALALDA/isoteam. In these reports I can't see it.

We have others sites named CRM or Regulatory Affairs, they are not present in these reports.

I found a way, I have to go under Site Settings of the site collection, and I'm going under Storage Metrics. But I will like to find something to export, and if it is possible, to run automatically the first day of month. And by this way it's very time-consuming.

I already use Powershell for Mailbox, Groups, Microsoft does not offers for Sharepoint type of this site? I already know for the Office 365 groups.

[#4 · Accepted solution]

@t_brejon 

Here you can find some useful commands related to SharePoint:

• https://www.c-sharpcorner.com/article/useful-office-365-cmdlets-to-generate-sharepoint-online-report...
• https://gallery.technet.microsoft.com/office/Get-detail-report-of-all-b29ea8e2

You can also search here:

• https://gallery.technet.microsoft.com/office/site/search?f%5B0%5D.Type=RootCategory&f%5B0%5D.Value=O...

[#5]

@t_brejon 

These Report might help you in regards of files and size for the Libraries/Lists in the Sites: https://github.com/Barbarur/NovaPointPowerShell/blob/main/Solutions/Report/Items%20and%20Files%20rep...

It might need some modification to get the exact report you need, but can be use as reference.