Can we get the file and folder sharing report from SharePoint and OneDrive as admin along with direction who has shared the file and folder with whom and vice versa? Is there any way via GUI or Graph API or PowerShell?

Question

Can we get the file and folder sharing report from SharePoint and OneDrive as admin along with direction who has shared the file and folder with whom and vice versa? Is there any way via GUI or Graph API or PowerShell?

For example:

User A shared a file & folder with user B and vice versa so we should be able to see it in report with that direction along with their user ID's.

Answer 1

Hi @Vinod Survase ,

Welcome to Q&A forum.

Yes, as an admin, you have many choices.

Implemented using GUI:

• Report on file and folder sharing in a SharePoint Online site.

1. Open the site where you want to run the report
2. On the Settings menu, click Site usage.
3. In the Shared with external users section, click Run report.
4. Choose a location to save the report, and then click Run report.

• Report on file and folder sharing in OneDrive

1. Open OneDrive Online.
2. On the Settings menu, click OneDrive settings.
3. Click More settings, and then click Run sharing report.
4. Choose a location to save the report, and then click Save.
5. Click Run sharing report again, please click "You may see the results of this query here" link.

More information, please refer to this article:

• Report on file and folder sharing in a SharePoint site

Or go to https://compliance.microsoft.com/auditlogsearch?viewid=Search , then you can search all records related to shared objects.

Implemented using PowerShell:

You can refer to this article:

https://o365reports.com/2021/05/20/audit-sharepoint-online-external-sharing-using-powershell/

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

Hope this helps.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.