Forum Discussion
List of files and folders shared internally
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
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.
MicrosoftHi 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
- Hmm, okay, so how would that work if it's something shared from Teams? I mean in that case, it's not something where any kind of inheritance can be broken, since it has its own site collection. Also, wouldn't internal sharing of a file or folder always "break inheritance" in some way, since you are explicitly sharing a file with someone who is not already a member of the specific team/sharepoint site. We don't care about sharing links created for those who are already members, only those who are not.
While I'm at it, we would also really like some reports for administrators about what is shared and with whom (internally/externally/anonymously). It's not like it's a secret for administrators, we could already see it in the audit log. Something that could be pulled via the graph api would be a start, since it already has the possibility of pulling external sharing, but are you saying that the office graph api also supports internal sharing, as long as we're talking about broken inheritance?- StephenRice
Hi AllanWith,
By "Shared from Teams", do you mean that the user added the file to a Teams-connected site? In that case, when you get the sharing report for that site, you'd see the Teams membership groups as having access to the entire library.
Yes, internal sharing of a single file or folder will always break inheritance.
For broader reporting, auditing is the best option of what we have today. I am not 100% sure what is and isn't in Graph around this space. Thanks!
Stephen Rice
Senior Program Manager, OneDrive
StephenRice Hi again. We were able to confirm, that the report does indeed list internal sharing, so thank you for the help on that. And yes, what I meant was a Teams connected SharePoint site, so your explanation made sense.
What I want to ask now, is if it's possible to run a script that will extract that same information? For governance reasons, we'd like to have an overview of everything that's shared in our tenant from Teams connected Sharepoint sites. If this can be done by extracting one csv file per site, that's fine, but it would be even better if the data could be extracted via an API and piped into a database or whatever we choose.
Thanks!