I have a site with several hundred of lists and over 100,000 items in total. I need a content roll up of the data to track the amount of items created per month/year.
I already took a look into:
Content Query Web Part: Apparently the threshold of 5,000 can't easily be exceeded. With regard to my amount of data (>100,000 items), this approach doesn't seem promising.
Content Search Web Part: As this web part is building upon the search functionality, it should work with more than 5,000 items. However, I can only return 50 items as a result, which is too little.
Linked Data Source and Data View Web Part: This was the promising approach. I created a linked data source and implemented it with a data view web part in SharePoint Designer. With right click -> 'Export to Excel' you could filter and count the data. However, it only exports the first page of results and ignores the other pages. Also the export ignores the filters (see picture) and thus I'd have to return all 100,000 items and filter them within Excel, which wouldn't work, because a limit of 50,000 items applies to data views.
Are there any ways to export a filtered data view web part? Is it even possible to roll up >100,000 items and export them to Excel?
Environment: SharePoint 2013 (+ Designer), only site owner permissions