OneDrive for Business now allows users to generate an external sharing report. The report is designed to help people understand what files are shared in their account. The report generates a CSV file that has lots of data, but you need to understand how to make sense of the data.
https://office365itpros.com/2019/10/22/onedrive-for-business-external-sharing-report/
