Reporting all sites on tenant with file versioning sizes

Brass Contributor

I am wondering if there is a report or even a powershell script that can crawl every site on my companies tenant, report for each site, each document that has multiple versions so I can find out how much storage is being taken by versioning?

I have 8000+ sites on the tenant, some of these I hope soon will fall to MS 365 SPO Archive, but for the active remaining sites, I know the limit for major versions is 500, but I am not 100% clear how that works.  If a Spreadsheet as an example is 2MB, if there are 50 versions, does each version take up the full 2MB (or the size of the file for the specific version, will likely be smaller as less data in it), or does it only contain the actual changes that were made for each version?

1 Reply
About the versions: yes, the 2 MB file with 50 versions will consume 100 MB of your storage quota.