Monitoring all SPO Sites Storage Used Month by Month

[coxygt]

Wondering if this is possible, but I have a requirement to be able to monitor every SPO site on my companies tenant, and to be able to pick up storage usage changes month by month.  I am aware of the Site Usage Reports within 365 Admin, but currently they are broken (not showing URL), so wondering if anyone else does this, if so, be great to see how you do it.

Need to see, site URL, Name, and current site storage used figures, storage allocated and last activity date.

[#2 · Accepted solution]

What I've done is to create an flow that get's the information using graph and save it to a SharePoint list:
https://learn.microsoft.com/en-us/graph/api/resources/sharepoint-site-usage-reports?view=graph-rest-...


I would later build a PowerBI report where I can see the graph per day/week/month/year.