Forum Discussion

Iron Contributor

Jun 30, 2020

Solved

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...

files

SharePoint Online

StephenRice
Jul 13, 2020
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

Jul 13, 2020

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

AllanWith

Iron Contributor

Jul 23, 2020

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
Microsoft
Jul 24, 2020
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
- AllanWith
  Iron Contributor
  Feb 15, 2021
  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!
  - StephenRice
    Microsoft
    Mar 04, 2021
    Hi Allan,
    
    There is no easy way to do this today unfortunately. We do know there's a desire though and it's something the team is investigating & looking at. Thanks!
    
    Stephen Rice
    Senior Program Manager, OneDrive