Forum Discussion

t_brejon's avatar
t_brejon
Copper Contributor
Apr 03, 2019
Solved

Sharepoint Online Reports

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.

  • 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-reports/
    • 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=Office365&f%5B0%5D.Text=Office%20365&f%5B1%5D.Type=SubCategory&f%5B1%5D.Value=SharePointOnline&f%5B1%5D.Text=SharePoint%20Online&f%5B2%5D.Type=ProgrammingLanguage&f%5B2%5D.Value=PowerShell&f%5B2%5D.Text=PowerShell

4 Replies

  • Barbarur's avatar
    Barbarur
    Brass Contributor

    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%20report%20from%20a%20SharePoint%20Online%20Site.md

     

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

  • t_brejon, take a look at https://admin.microsoft.com/AdminPortal/Home#/reportsUsage/SharePointActivityV1https://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

    • t_brejon's avatar
      t_brejon
      Copper Contributor

      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.

      • Maggan Wåhlin's avatar
        Maggan Wåhlin
        Iron Contributor

        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-reports/
        • 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=Office365&f%5B0%5D.Text=Office%20365&f%5B1%5D.Type=SubCategory&f%5B1%5D.Value=SharePointOnline&f%5B1%5D.Text=SharePoint%20Online&f%5B2%5D.Type=ProgrammingLanguage&f%5B2%5D.Value=PowerShell&f%5B2%5D.Text=PowerShell

Resources