How to find large SharePoint lists
In your time as a SharePoint administrator, you have probably encountered the infamous error message: “This view cannot be displayed because it exceeds the list view threshold (5,000 items) enforced by the administrator.”
The list view threshold was introduced back in SharePoint 2010. The default limit in a SharePoint list and document libraries is 5,000 items per view. Anything beyond that will not be rendered. If you are running SharePoint on-premises, this limit can be adjusted via Central Administration > Web Applications > Resource Throttling settings. However, please consult this guide before you change anything.
SPDockit cannot help you work around this problem, but we can help you find all the SharePoint lists that are over or close to the threshold. Once you have that info, you can contact the owners of these lists and help them clear or better organize them.
With SPDockit’s Query Wizard, you can create custom reports that will help you determine if all your governance policies have been properly enforced across your SharePoint farm.
To find all lists with more than 4,500 items, follow these steps:
1. Navigate to Queries & Rules.
2. Click New Query to create a new query to run on your farm
3. Name your search query so you can find it more easily later in the wizard run history. Description is optional.
4. Under Location, select Queries. Click OK.
5. In Query scope list, click Lists. Click Next to continue.
6. Select Title, Url, and Item Count check box. Click Next to continue.
7. To define filed ordering and sorting for your report, for each field in the Sorting list choose between Ascending, Descending, or None. Click Next to continue.
8. Choose Manual Only. Send To is an optional feature.
9. Select Item Count with a specific value check box.
10. Click the underlined blue link titled “specific” and set the Condition list to Is greater than. For the preferred value, type in 4500. Click OK, and then click Next to proceed.
11. Under Scope and Target, clcik Web Application.
12. Click Finish. Your query is ready for execution.
13. Click Run to execute your query.
14. View your results.
To explore query results by date and time, click on the desired record. You can see them under the queries folder structure under each query definition, marked with an orange arrow.
