Add owner UPN column to OneDrive for Business usage report
Currently only the owner display name and url of the user's OneDrive site is available in the OneDrive usage report. I use this report to then tie the information in to data that we have only in our internal reporting systems to gain insight into how OneDrive is being used, where it is being underused, and how users are sharing files. There is a script that can get the UPN from the url of the OneDrive site but there are hundreds of sites where the url's listed in the report end in .com1 and there are no emails in our system that match that pattern. Almost all other reports list the UPN of the owner but the OneDrive report only lists the url.