Recently I have migrated a SP 2013 site to SP Online. Most of the list has items more than 30K to 40K(records). Unfortunately - some of the list has more than 100 and even 200 views! Obviously each view has their respective filters. In my case most of the filters bring more than 5K records and hence views get failed to render with the following error:
This view cannot be displayed because it exceeds the list view threshold (5000 items) enforced by the administrator.
I am okay with the error and I know how to fix them. To fix them, first I need to know how many views are there those are crossing 5K records. My SharePoint neighbors know very well how painful it is to see a view that crosses 5K records (surely I am talking about the speed to load data). It is an excruciating pain to check each view and record it somewhere that this view is crossing 5K records!
What I need: A mechanism (A tool like thing that might be written in CSOM or SPFx or anyway - I will be able to write if I get a pointer how to read views filter and how to check if that filter will cross the 5K records) that will take the input a site URL, iterate trough all the list and then all the views producing a report that will give me an insight of total number views (With names) that crosses 5K records so that I can quickly jump in and fix them.
Advance thanks for any pointer!