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?

Vinod Survase 4,726 Reputation points
2023-11-29T10:47:43.69+00:00

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.

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,274 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,211 questions
OneDrive Management
OneDrive Management
OneDrive: A Microsoft file hosting and synchronization service.Management: The act or process of organizing, handling, directing or controlling something.
1,191 questions
{count} votes

Accepted answer
  1. Yanli Jiang - MSFT 23,581 Reputation points Microsoft Vendor
    2023-11-30T07:18:26.8933333+00:00

    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.

    User's image

    • 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:

    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.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful