Do any one has any PS script to download sharepoint online usage report?

Question

I had followed the some article to generate the report using Graph API, but I feel its generating storage report not the usage report and when I am comparing the Graph API generated usage report with actual usage report which I am downloading by clicking the download button in SharePoint site, its completely different as it has more tabs like Popular content, Usage by device, Usage by time etc....and its also showing the day to day activity, but in Graph API report these options are not coming.

Please suggest.

Do you have any custom PS script to generate the SharePoint Online site usage report? I am working on automation.

Note: I want to generate exactly the same Usage report using PS script as I am downloading it using download option in SharePoint Online site (It has tabs).

Answer 1

Hi @Tilo ,

If interested, you can use Microsoft Graph PowerShell SDK to work with graph.

Get started with the Microsoft Graph PowerShell SDK

Once you installed the Graph SDK module. Run the following commands to connect the Graph with required permissions.

#Connect Microsoft Graph  
$RequiredScopes = @("Reports.Read.All")  
Connect-MgGraph -Scopes $RequiredScopes  

Use the following command to get SharePoint site usage details.

Invoke-MgGraphRequest -Uri "https://graph.microsoft.com/v1.0/reports/getSharePointSiteUsageDetail(period='D180')" -OutputFilePath "C:\Temp\Report.csv"  

As @MichaelHan-MSFT mentioned, refer the following documentation to get the desired graph end-point and use it in the above command.

• SharePoint activity reports: https://learn.microsoft.com/en-us/graph/api/resources/sharepoint-activity-reports
• SharePoint site usage reports: https://learn.microsoft.com/en-us/graph/api/resources/sharepoint-site-usage-reports

Answer 2

Hi, @Sunny Rastogi ,

As far as I know, there is no such PS script to generate the site usage report the same as the reoprt downloaded from the UI.

Currently, if we want to generate sharepoint reports programmatically, we have to use the Graph API to acheive this. In offical graph documentation, there is only two kinds of sharepoint reports available:

• SharePoint activity reports: https://learn.microsoft.com/en-us/graph/api/resources/sharepoint-activity-reports?view=graph-rest-1.0
• SharePoint site usage reports:https://learn.microsoft.com/en-us/graph/api/resources/sharepoint-site-usage-reports?view=graph-rest-1.0

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.