Sharing OneDrive Folder or SharePoint Folder with OneDrive for Business

[Cara Hicks]

We are moving our files from a server fileshare to OneDrive for Business and I am looking for a way to oversee 200+ staff OneDrives to maintain compliance with Acceptable Use Policy (no personal videos, music, photos, etc). We have used Folder Sizes for a number of years but I can't find anything that has oversight without the ability to make changes to files in OneDrive. I can get access to each drive, but this also allows me to make changes to those files and I don't want that. 

Is there a way to run reports on things like "file types on OneDrive", "largest files saved on OneDrive" ... that sort of thing? 

Thanks! 

[#2]

If you are looking for reports on file types and large files for few 100's of users on OD4B Sharegate would be your best bet to run these reports.

https://en.share-gate.com/blog/find-large-files-in-sharepoint

From Onedrive landing Page, You can also go to each individual user Storage Metrics page to look for large files for a specific user. Here's an article which describes how.

https://swethasankaran.com/2016/10/19/onedrive-sharepoint-storage-metrics/

Office 365 also provides some Usage reports in Admin Center for OD4B. Below URL provides more detail for the same.

https://support.office.com/en-us/article/office-365-reports-in-the-admin-center-onedrive-for-busines...

[#3]

Thank you! We are using Sharegate already for migrating to Sharepoint. I'll look at how to connect it to oneDrive! 

[#4]

To complement the answer you have already received, you could potentially get this information using SPO APIs (it's what sharegate is doing behind the scenes)