Forum Discussion
List of files and folders shared internally
Does anyone know if and when we will be able to generate an exportable list of files and folders shared internally from a SharePoint site or OneDrive? We need this for our internal governance so that site owners can determine whether sharing of given file or folder is still relevant.
Right now it is very cumbersome to determine if something is shared, as there are no visual cues online or in file explorer, no "shared by us" and there is no way to run a report. This is very suboptimal in a gdpr world, where we need to be able to easily adjust access at any given time to only those who need access.
If anyone knows of a solid way of obtaining this information otherwise (via script or 3rd party tools), please let me know. I know that it can be done by trawling the audit log, but this is not very robust (or user friendly).
Hi AllanWith,
The report I linked above should include internal sharing as well. It will only report items that have broken inheritance though so on a brand new SharePoint Site for example, you'll only see three rows for the Members, Visitors & Owners groups against the root web.
That's a great suggestion and I'll be sure to pass it along to the team! Thanks!
Stephen Rice
Senior Program Manager, OneDrive
- StephenRice
Microsoft
Hi AllanWith ,
I would suggest looking at the Sharing Reports feature: https://docs.microsoft.com/en-us/sharepoint/sharing-reports
This will generate CSV's that contain a row for every user, permission, item and link in a given site or OneDrive. Hope that helps!
Stephen RiceSenior Program Manager, OneDrive
- Hello Stephen, thank you for your reply!
As far as I can see, those reports only show external sharing, correct? I'm looking for internal sharing reports. I've seen comments that internal sharing would come to these reports, but so far haven't noticed anything.
It would be a great help if SharePoint would have "Shared By Us" much like OneDrive as well as visual indicators that show if a given folder is shared. This is currently not the case and this combined with the lack of internal sharing reports means it's a bit messy trying to ascertain what has or hasn't been shared and with whom.
Again, thank you kindly for your reply, it is much appreciated.- StephenRice
Hi AllanWith,
The report I linked above should include internal sharing as well. It will only report items that have broken inheritance though so on a brand new SharePoint Site for example, you'll only see three rows for the Members, Visitors & Owners groups against the root web.
That's a great suggestion and I'll be sure to pass it along to the team! Thanks!
Stephen Rice
Senior Program Manager, OneDrive
