OneDrive Sharing Reports to see who can see what

OneDrive is a great tool, but it can be a bit difficult when it comes to finding what you’ve shared with whom, and whether you need to do some permission clean-up. By using the OneDrive Sharing Report, you can get all this information in an easy-to-read Excel spreadsheet. Here’s how that works…

Go into OneDrive in your browser, and click on the Options icon. That will give you the OneDrive Settings option:

Machine generated alternative text:
Settings 
OneDrive 
OneDrive settings 
es ore your ne rwe 
x

In the More Settings section, select Run Sharing Report:

Machine generated alternative text:
Duff, Thomas 
Q Notifications 
@ More Settings 
OneDrive 
More Settings 
Manage access 
Access requests and invitations 
Site collection administrators 
Run sharing report

Select a folder in your OneDrive to store the Sharing Report. In this case, I chose the Collection Folder:

Machine generated alternative text:
Files 
Choose a destination to save this 
report 
e 
Name 
EducationalMaterial 
PersonalVideos 
Apps 
Collection Folder 
0365PulseRoadmapClg 
MigrationFilesArchive 
Cancel

The process takes less than a minute, and you will then see the file in your selected OneDrive folder:

Machine generated alternative text:
Files > Collection Folder 
Name 
- Duff, Thomas 2020-5-19-13-3-37 1.csv 
Modified 
About a minute ago 
Modified By 
System Account 
File size 
14.1 KB 
Sharing 
Private

In the spreadsheet, you’ll see the path of each of your files, the file type, who you’ve shared the file with, and the level of access they have:

Machine generated alternative text:
User Name 
37 
38 
Mahan, Sandra 
39 
40 
Mahan, Sandra 
41 
42 
Mahan, Sandra 
43 
44 
Mahan, Sandra 
45 
46 
Mahan, Sandra 
47 
48 
Mahan, Sandra 
49 
50 
Mahan, Sandra 
51 
52 
Mahan, Sandra 
53 
54 
Mahan, Sandra 
55 
56 
Mahan, Sandra 
57 
58 
Mahan, Sandra 
Resource Path 
personal/ 
personal/ 
personal/ 
personal/ 
personal/ 
personal/ 
personal/ 
personal/ 
personal 
personal/ 
personal 
Item Typ 
Documents/Microsoft Teams Chat Files/CLD277xMicrosoftServiceAd png 
(Documents/Microsoft Teams Chat Files/CLD277xMicrosoftServiceAd png 
Permissio 
Contribute 
Contribute 
Contribute 
Contribute 
User Email 
(Documents/Microsoft Teams Chat Files/Everything2.jpg 
(Documents/Microsoft Teams Chat Files/Everything2.jpg 
Jpg 
Jpg 
(Documents/Microsoft Teams Chat Files/GameOfSharePointMigratior pdf 
Documents/Microsoft Teams Chat Files/GameOfSharePointMigratior pdf 
Documents/Microsoft Teams Chat Files/grouphug.gif 
(Documents/Microsoft Teams Chat Files/grouphug.gif 
Documents/Microsoft Teams Chat Files/landOSelfAssessmentMeetin docx 
Documents/Microsoft Teams Chat Files/landOSelfAssessmentMeetin docx 
Documents/Microsoft Teams Chat Files/lnvoice - PDF - JKRXPK - Janu pdf 
Documents/Microsoft Teams Chat Files/lnvoice - PDF - JKRXPK - Janu pdf 
Documents/Microsoft Teams Chat Files/MicrosoftServiceAdoptionSp PNG 
Documents/Microsoft Teams Chat Files/MicrosoftServiceAdoptionSp PNG 
personal 
personal/ 
personal/ 
personal/ 
personal/ 
personal/ 
personal/ 
personal/ 
personal/ 
personal/ 
personal/ 
(Documents/Microsoft Teams Chat Files/ TamaraPirate01.jpg 
(Documents/Microsoft Teams Chat Files/ TamaraPirate01.jpg 
(Documents/Microsoft Teams Chat Files/ TamaraPirate02.jpg 
(Documents/Microsoft Teams Chat Files/ TamaraPirate02.jpg 
Jpg 
Jpg 
Jpg 
Jpg 
(Documents/Microsoft Teams Chat Files/ThelJltimateGuideToSharePc pdf 
Documents/Microsoft Teams Chat Files/ThelJltimateGuideToSharePc pdf 
Documents/Microsoft Teams Chat Files/TomAndTamaraPirate.jpg jpg 
Documents/Microsoft Teams Chat Files/TomAndTamaraPirate.jpg jpg 
Duff, Thomas_2020-5-19-13-3-37_ @ 
Contribute 
Contribute 
Contribute 
Contribute 
Contribute 
Contribute 
Contribute 
Contribute 
Contribute 
Contribute 
Contribute 
Contribute 
Contribute 
Contribute 
Contribute 
Contribute 
Contribute 
Contribute 
Nguyen, Tanh 
Nguyen, Tanh 
Nguyen, Tanh 
Nguyen, Tanh 
Nguyen, Tanh 
Nguyen, Tanh 
Nguyen, Tanh 
Nguyen, Tanh 
Nguyen, Tanh 
Nguyen, Tanh 
Nguyen, Tanh 
User Or Group Typ 
Internal 
Internal 
Internal 
Internal 
Internal 
Internal 
Internal 
Internal 
Internal 
Internal 
Internal 
Internal 
Internal 
Internal 
Internal 
Internal 
Internal 
Internal 
Internal 
Internal 
Internal 
Internal

This is a great tool to do a periodic audit of your OneDrive sharing to make sure you’re not showing too much to too many people.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s