File Sharing Problems

How to Get a Central SharePoint Online Sharing Report

Steven ParkerSteven Parker Oct 21, 2026 869 views

Question details

The user wants to know how to generate a central report of file sharing activities in SharePoint Online to monitor external access and audit sharing links.

How to Get a Central SharePoint Online Sharing Report
Product
SharePoint Online
Device & OS
not provided
Scenario
Administrators need to track and audit external sharing links and access governance across various SharePoint sites.
Observed behavior
Admins need a reliable method to view all sharing links created recently or export a comprehensive audit log for security and compliance.
Before you start

Ensure you have SharePoint Administrator privileges or Global Admin rights in Microsoft 365 before attempting to access Data Access Governance reports or run external sharing PowerShell scripts.

Solution 1Recommended

Generate a Sharing Links Report via SharePoint Admin Center

The easiest way to review recent sharing activity without writing code is through the built-in Admin Center reports.

This built-in method provides a visual dashboard for administrators to monitor sharing activities across the tenant. It focuses on the highest number of sharing links created over a 30-day window.

1
Access Admin Center

Log in to the Microsoft 365 Admin Center with your administrator credentials and navigate to the SharePoint Admin Center.

2
Navigate to Reports

In the left-hand navigation pane, click on 'Reports' and select 'Data access governance'.

3
View Sharing Links

Locate the 'Sharing Links' section on the dashboard and click on 'View Reports'.

4
Run Reports

Click 'Run all' to generate data for all tracked sites, or select specific reports to run individually.

5
Review Data

Review the generated reports, which will display up to 100 sites with the highest volume of sharing links created in the past 30 days.

Generate a Sharing Links Report via SharePoint Admin Center
Report Limitations: The SharePoint Admin Center interface primarily highlights recent activity (past 30 days) and top sites. For complete historical data, advanced auditing tools are required.
Free Microsoft Office alternative

Manage and Share Files Easily with WPS Office

While SharePoint offers enterprise-level governance, WPS Office provides a free, lightweight, and highly compatible alternative for individuals and teams to create, manage, and securely share documents via built-in cloud services.

  1. 1. Install WPS Office: Download and install the free WPS Office suite from the official website.
  2. 2. Save to WPS Cloud: Open or create your document and save it directly to WPS Cloud for automatic syncing.
  3. 3. Share Securely: Click the 'Share' button in the top right corner to generate a secure link with customized viewing or editing permissions for your collaborators.
Fully compatible with Microsoft Word, Excel, and PowerPoint file formats.Built-in WPS Cloud allows for easy and secure file sharing with customizable permission links.Lightweight design ensures fast installation and smooth operation on older devices.Familiar user interface for a seamless transition from Microsoft Office.
microsoft office alternative - wps office

Frequently Asked Questions

Can I see sharing links created more than 30 days ago in the SharePoint Admin Center?

The built-in Data Access Governance report in the SharePoint Admin Center specifically displays data for sharing links created within the last 30 days. For older data, you must rely on Microsoft Purview Audit logs or previously scheduled PowerShell exports.

Do I need special permissions to run the PowerShell sharing report?

Yes, running external sharing reports via PowerShell requires you to have SharePoint Administrator or Global Administrator privileges in your Microsoft 365 tenant.

What information is included in the PowerShell external sharing report?

The PowerShell export typically includes the time the file was shared, who shared it, the recipient, the resource type, the specific site URL, the sharing type, and comprehensive audit information.

How do I export the SharePoint Admin Center report to CSV?

Once you generate and view the Data Access Governance report in the SharePoint Admin Center, you can click the 'Export' button located at the top of the report list to download the current view as a CSV file for offline analysis.