Powershell batch generation of SharePoint usage report

Question

Is it possible to get the usage report by powershell batch processing to get all the site collection reports instead of going to read the report in individual site collection?
https://www.spguides.com/sharepoint-2016-usage-analytics/

Answer 1

Hi @Terry Chan ,

For usage report is an internal function and we don't have an interface to directly download usage report from SharePoint, it is impossible to get usage reports in batches. You need to do it manually. As a workaround, you can loop all web applications and get all the site collections in the web applications, then export usage data to a .CSV file.

References:
Loop web applications and get site collections:
https://sharepointpixels.wordpress.com/2016/06/24/sharepoint-iterate-through-all-web-applications-site-collections-sites-lists-and-list-items-with-powershell/

Get usage data in SharePoint:
https://archive.codeplex.com/?p=sp13usagemonthlystats

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
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.