Skip to the stories
Microsoft 365 & SharePoint

SharePoint Sharing Links Report: Finding Oversharing Before It Becomes a Problem

  • Gregory Zelfond
  • 568 views

SharePoint Advanced Management's Sharing Links Report surfaces Anyone and external links across sites. Here's how to run it and act on the results.

SharePoint Sharing Links Report: Finding Oversharing Before It Becomes a Problem

Until recently, SharePoint admins had little native visibility into what users were sharing. If you wanted that picture, you usually bought a third-party governance tool. Now the SharePoint Advanced Management module includes a built-in report that shows where links exist and who they reach. The report is called the Sharing Links Report, and it's the fastest way I know to find the Anyone links that quietly outlive the projects they were created for.

The gap it closes is real. A confidential file shared years ago through an Anyone link can still be live today, and nobody on the current team may even know it exists. If you're planning for Copilot in your tenant, that's the kind of exposure you want to find first, because Copilot works with content the user already has access to.

Enabling and running the report

Access starts in the Microsoft 365 admin center. The steps below follow the path described in the source material.

  1. Open the Microsoft 365 Admin Center.Microsoft 365 app launcher with the Admin app highlighted
  2. Under Admin centers, select SharePoint.Admin centers list in Microsoft 365 with SharePoint selected
  3. Under Reports, open Data access governance, then select View reports under Sharing links.SharePoint admin center Data access governance page with View reports under Sharing links
  4. On first use, click Enable data collection. Data is recorded only from that point forward, so nothing appears retroactively.Enable data collection button for the Sharing links reports
  5. Wait at least 24 hours before generating anything.Data collection enabled confirmation for Sharing links reports
  6. After that window, return to the page and click View reports.Sharing links report available for generation with the View reports button
  7. Three reports are available: 'Anyone' links, 'People in your organization' links, and 'Specific people' links shared externally. Run them one at a time or select all three with Run all.Sharing links page with the three link reports and the Run all button
  8. Generation is slower than the interface suggests. It says it might take a few hours, but one hands-on run took 24 to 48 hours.Sharing links reports running with a status that says it might take a few hoursCheck back later message while the Sharing links report is still running
  9. When the report is ready, click its name to open it.Completed People in your organization links report in the Sharing links list
  10. The summary shows the top 100 sites with that link type. For the full list, click Download detailed report to get a CSV.

People in your organization links report summary with the Download detailed report button

Three ways to act on what the report shows

Finding links is the easy half. The report gives you three remediation paths, and they differ mainly in how much you trust the site owner to act.

Option 1: Start a site access review

This is the option I'd reach for first, because the workflow is built into the report and it keeps site owners responsible for their own content. You pick a site and click Initiate site access review, then add context in the comments and click Send.Sharing Links Report with a site selected and the Initiate site access review buttonInitiate site access review panel with a comment for site owners and the Send button

The site owner receives a formal email with a View all created links button.Site access review email to the site owner with the View all created links button From there they can see the links they manage, remove or change access, and then select Complete review. They have to add resolution comments before the review closes, which leaves a record of what was changed and why.Site review page listing files shared with People in your organization links and Manage accessComplete review button on the site review page for sharing linksConfirm review dialog where the site owner adds a resolution comment

Option 2: Restrict site access

Sometimes you can't wait on an owner. Restrict site access is the faster lever. You can apply it from the Active Sites list, and the report interface offers the same action. Check the box next to the site, click Restrict site access, and confirm.Sharing Links Report with a site selected and the Restrict site access buttonRestricted site access confirmation with the Restrict access to this site checkbox

That speed is the trade-off. A restriction hits everyone using the site, not just the links you're worried about, so reserve it for sites where the exposure is serious and the owner can't be reached in time.

Option 3: Tighten sharing settings so the problem stops recurring

The first two options clean up existing exposure. Without changes to sharing settings, the same pattern returns next month. For the sites the report flagged, consider:

  • Setting an expiration on Anyone links so they stop working on a schedule rather than indefinitely.
  • Changing the default sharing link to Specific people, at the tenant or site level, so new links don't default to broad access.
  • Disabling external sharing for the site where content shouldn't leave the organisation, or limiting it rather than turning it off everywhere.

Limits to plan around

The report is useful, but it has boundaries that affect how you read the results.

  • You need the SharePoint Administrator role and a SharePoint Advanced Management (SAM) license assigned to your account.
  • Data collection has to be turned on before anything appears. Until then, the report is empty, so turn it on early rather than during an audit.
  • Site owners can't see the Sharing Links Report. They can only check sharing on their own site, which is why the site access review is the channel that reaches them.
  • The report is a point-in-time snapshot covering 28 days at most. It counts links created in that window, not every link that exists. An Anyone link created three years ago won't appear.

That last limit matters most. For the full picture, pair this report with the Site permissions across your organization report, which covers standing access rather than recent link creation. Here's the thing: a clean Sharing Links Report over 28 days doesn't mean your tenant is clean. It means nothing new was created in that window that the report can see. Run the report on a schedule, keep the tighter default sharing settings in place, and treat the old Anyone links as the backlog they are.

Source: Gregory Zelfond · sharepointmaven.com

Neighbouring cells