I am a site collection admin for a SharePoint Online classic site. Its a huge site of about 1 TB size
We are planning for retention and archival of documents for which we need to generate site report on a regular basis.
This report should contain all the properties of documents looping into each subsite ,library folders.
Basically to identify when were the documents last modified or used.
Site usage just gives a brief overview. To have power shell script I am not a SharePoint admin for my tenant.