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

/Martin

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.

Thanks,

Victoria