Aug 03 2022 08:12 AM
is it possible to export the SharePoint usage report on schedule?
What we would like to do is to have the usage of a SharePoint site collection beyond the 90 days mark offered by Microsoft (be able to get all the historic usage report)
this means that we would need to run the 90 days usage report at least 4 times through the year and have it stored somewhere on a SharePoint library
is this possible ?
The purpose is to create a report on Power BI that will show the historic usage of the site.
Thank you
Aug 03 2022 08:52 AM
Aug 03 2022 08:56 AM
@MikePalomares If you are comfortable using PowerShell, check out this PnP sample that gets site usage report and exports it to csv. You need to update the script to just get data for a particular site collection. If this works out, you can schedule this to run monthly to get your data for report. Get Site Usage Reports And Export It To CSV | PnP Samples
Aug 04 2022 07:50 AM
@Vasil Michev
I see this will extract all sites usages in the tenant, is there a way to do it for an specific site collection ?