Skip to main content
< All Articles

Sharing Links Report: How to Find Oversharing Before Copilot Does

Until recently, we had little oversight of users sharing content in SharePoint. If you wanted any visibility, you had to rely on third-party governance solutions. And trust me, this is a real problem. I cannot tell you how many times I have seen a confidential file shared years ago with an Anyone link, and that link is still alive and well today. Luckily, with the SharePoint Advanced Management module, we now have an out-of-the-box way to get more information about users’ SharePoint activity. The specific report that provides valuable insights into oversharing is called the Sharing Links Report.

How to access the Sharing Links Report

  1. First, navigate to the Microsoft 365 Admin CenterMicrosoft 365 app launcher with the Admin app highlighted
  2. Under Admin centers, click on SharePointAdmin centers list in Microsoft 365 with SharePoint selected
  3. Under Reports, click on Data access governance, then View reports under Sharing linksSharePoint admin center Data access governance page with View reports under Sharing links
  4. The first time you access these reports, you will need to enable data collection so that data can be recorded going forward. Click the Enable data collection button.Enable data collection button for the Sharing links reports
  5. You will then need to wait at least 24 hours before generating the report.Data collection enabled confirmation for Sharing links reports
  6. After about 24 hours, you can generate the reports. Click View reports.Sharing links report available for generation with the View reports button
  7. You will see 3 available reports: ‘Anyone’ links, ‘People in your organization’ links, and ‘Specific people’ links shared externally. You can select one at a time or all 3 to run all at once.Sharing links page with the three link reports and the Run all button
  8. Once again, you will need to wait as those reports are generated. Though it says “it might take a few hours”, in my case it took 24-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. Once completed, when it says the report is ready, click the report name to open it.Completed People in your organization links report in the Sharing links list
  10. You will then see a list of the top 100 sites that have this type of link. To download the detailed report in CSV format, click on Download detailed report.

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

How to mitigate oversharing found with the Sharing Links Report

You have 3 options for mitigating the findings of the Sharing Links Report.

Option 1: Initiate site access review with site owners

One option I really like, and that is built into this report’s workflow, is to initiate a site access review with the site owners. Once initiated, formal emails go out to the site owners asking them to review sharing settings and make changes. Here is how it works:

  1. Pick the site and click Initiate site access reviewSharing Links Report with a site selected and the Initiate site access review button
  2. Provide context for the review by typing in additional comments for the site owners, then clicking SendInitiate site access review panel with a comment for site owners and the Send button
  3. The Site Owner will then receive an email similar to what you see below.Site access review email to the site owner with the View all created links button
  4. Once they click View all created links from the body of the email, they will see the links they can manage and removeSite review page listing files shared with People in your organization links and Manage access
  5. Once changes are made, the site owner can click on the Complete review buttonComplete review button on the site review page for sharing links
  6. They will be asked to provide resolution comments as wellConfirm review dialog where the site owner adds a resolution comment

Option 2: Restrict site access

The second option is for when you want to act quickly and not be at the mercy of the site owner. You can restrict site access. I actually wrote a separate article on this feature some time ago. As mentioned in the article above, you can do this from the Active Sites list, but you can also do it from this report interface.

  1. Simply check the box next to the site and click Restrict site accessSharing Links Report with a site selected and the Restrict site access button
  2. You will then get a confirmation messageRestricted site access confirmation with the Restrict access to this site checkbox

Option 3: Tighten sharing settings to prevent future oversharing

Options 1 and 2 clean up what already happened. To keep the same thing from happening next month, adjust the sharing settings on the sites the report flagged.

  • Set an expiration on Anyone links. I explain how in this post.
  • Change the default sharing link. You can do so at the tenant or site level – change the default link type to Specific people.
  • Disable external sharing for the site. If a site should not share externally, limit or turn off external sharing for that site only.

Nuances about the Sharing Links Report

  • You must be a SharePoint Administrator and have a proper SharePoint Advanced Management (SAM) license assigned to your account.
  • As mentioned above, data collection must start before the report can be created. Up until then, no data will be presented in the report.
  • Site owners cannot see the Sharing Links Report. They can only check sharing on their own site.
  • The Sharing Links Report is a snapshot in time and goes back 28 days max.
  • Because of the 28-day threshold, it counts only new links created in the last 28 days, not every link that exists. For example, an Anyone link created 3 years ago will not show up. For the full picture, consider using the Site permissions across your organization report, which I explained in this post.
Gregory Zelfond, the SharePoint Maven - profile photo

About Me

I’m Greg Zelfond, a U.S. based SharePoint consultant, and I provide affordable out-of-the-box SharePoint consulting, training, and configuration assistance to small and medium-sized businesses all over the world.

Need help?