How do I get a list of all O4B files shared with others - for all users

Question

I need to get a list of all files all users shared with others&nbsp;sorted by user and then by file URL. The tenant has more than 400 users.
&nbsp;
Audit log search does not work because it does not show shared files where sharing started before audit log start date and it does not show file name and path. I also found this script:&nbsp;https://gallery.technet.microsoft.com/scriptcenter/How-to-use-OneDrive-Rest-5b31cf78 But it seems to work for one particular user only.&nbsp;
&nbsp;
Can anybody help?

vasilmichev · Answer

Um, why don't you simply use eDiscovery/content search and the SharedWithUsersOWSUser (internal) or the ViewableByExternalUsers (external)&nbsp;keyword? More info here: https://support.office.com/en-us/article/keyword-queries-and-search-conditions-for-content-search-c4639c2e-7223-4302-8e0d-b6e10f1c3be3

vasilmichev · Answer

It does, and it can give you the actual item as well, if you want to export it :)

deleted · Answer

Can't use that function in that script and pipe to it from the get command that gets all your onedrive sites?

jcgonzalezmartin · Answer

You can get all the ODFBs through PowerShell and then use the script you have found. For instance, the following support article provides a PowerShell script to get all the ODFBs in an Office 365 subscription: https://support.office.com/en-us/article/how-to-display-a-list-of-onedrive-for-business-site-collections-8e200cb2-c768-49cb-88ec-53493e8ad80a

deleted · Answer

That was my first thought but I couldn't figure out how you would call that. Good info for future thou. Thanks :).

Forum Discussion

How do I get a list of all O4B files shared with others - for all users

Share

Resources