Automate usage statistics reporting RRS feed

  • Question

  • Hi

    Does anyone know if it possible to automate Usage reporting in SharePoint Online

    Go to Site Settings --> [Site Collection Administration] Popularity and Search Reports --> Usage --> [Generates Excel workbook with statistics]

    We've got a plethora of site collections we want to do this in. Is there anyway automate this? I cannot seem to find a direct url to the Excel sheet... Is there anyway to do it with PowerShell? Or DOES a direct URL exists?

    Hope someone can help me out

    Thanks in advance


    Friday, July 24, 2015 8:37 AM


  • Hi Martin,

    Actually, there is no direct URL for generating the report file.

    When we click the Usage button in Popularity and Search Reports, the button will call a JavaScript method to send the request to the server and the report file will be sent back as a response.

    And it seems that there is no such API for getting the reports in Client Object Model, so you need to do this one by one in the site collections in SharePoint Online.



    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Saturday, July 25, 2015 3:11 AM