Automate "Run Report" in Setting > Site usage on Multiple Sharepoint Sites

Hi

How can I automate the "Run report" across multiple SharePoint sites?

Idea:

• Run the report on multiple SharePoint sites
• Collect the reports
• Preferably using Service Principal or Managed Identity
• Generate them automatically at the end of each month

Has anyone done something like this before?

Many thanks