Is there any way to create one usage dashboard for all subsites in SharePoint?

Sahadeb Patro 121 Reputation points Microsoft Employee
2021-11-09T08:57:50.927+00:00

Explained:

Currently, there is no way to export the usage report on site collection level, but possible from Site level.

There is a need to create one usage dashboard for all subsites (within one Site collection) in SharePoint. Is this Possible with Power Automate / PowerShell /Graph API ?

Dashboard to contain:

  1. No of views for each subsite in last 30 days
  2. Top 10 maximum viewed documents in each subsite

Thanks in advance.

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,645 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,682 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,381 questions
Accepted answer
  1. Elsie Lu_MSFT 9,761 Reputation points
    2021-11-11T09:18:38.557+00:00

    Hi @Sahadeb Patro ,

    Per my research and knowledge, yes currently it is not supported at site collection level with OOTB/Powershell.

    And Power Automate is an indepent product, you could go the forum for more professional advice:
    Microsoft Power Automate Community

    Reference:
    View usage data for your SharePoint site

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Limitless Technology 39,371 Reputation points
    2021-11-11T09:20:48.553+00:00

    Hello SahadebPatro,

    This should be possible by creating custom Content Search web part to the subsites:

    https://support.microsoft.com/en-us/office/configure-a-content-search-web-part-in-sharepoint-0dc16de1-dbe4-462b-babb-bf8338c36c9a?ui=en-us&rs=en-us&ad=us

    --If the reply is helpful, please Upvote and Accept it as an answer--