Forum Discussion

romanazurelabit's avatar
romanazurelabit
Copper Contributor
Dec 08, 2025

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

Permissions
powershell
SharePoint Online

2 Replies

  • Lu_Zhang's avatar
    Lu_Zhang
    Icon for Microsoft rankMicrosoft
    Dec 11, 2025

    Hi,

    Thanks for the idea! Can you please explain a bit more about your end-to-end scenario? E.g., why do you need to look at the report? What action would you like to take by looking at the monthly report?

    Thanks,

    Lu

    • romanazurelabit's avatar
      romanazurelabit
      Copper Contributor
      Dec 11, 2025

      Hi Lu

      My use case is to create the "Shared with External User" report for all SharePoint sites and subpages. We have a very large number of SharePoint sites. Afterwards, all of these reports should be collected.

      Ideally, I would like a central report that provides this information across the entire SharePoint environment.

      If it can be done some other way is also fine, it just needs to be automated ;-)

      Thanks
      romanazurelabit



Resources