get lists that have disabled throttling

Question

The following will disable throttling on a list-by-list basis. https://thesharepointfarm.com/2012/12/disable-throttling-on-a-list-by-list-basis/

how can we find out which lists have had throttling disabled in a farm or site collection.

Thank you,

Rumi

Answer 1

Below Script will get all the Large Lists which are exceeding the configured threshold limit in SharePoint.

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue  
   
#Get All Web Applications  
$WebAppsCollection = Get-SPWebApplication  
   
#Array to Hold Result - PSObjects  
$LargeListsResult = @()  
   
foreach($WebApp in $WebAppsCollection)  
{  
    #Get the Throttling Limit of the Web App  
    $Threshold = $WebApp.MaxItemsPerThrottledOperation  
   
    foreach($Site in $WebApp.Sites)  
    {  
        foreach($Web in $Site.AllWebs)  
        {  
            Write-host "Scanning site:"$Web.URL  
               
            foreach($List in $Web.Lists)  
            {  
                if($list.ItemCount -gt $Threshold)  
                {  
                    $Result = New-Object PSObject  
                    $Result | Add-Member NoteProperty Title($list.Title)  
                    $Result | Add-Member NoteProperty URL($web.URL)  
                    $Result | Add-Member NoteProperty Count($list.ItemCount)  
                       
                    #Add the object with property to an Array  
                    $LargeListsResult += $Result  
                }  
            }  
        }  
    }  
}  
Write-host "Total Number of Large Lists Found:"$LargeListsResult.Count -f Green  
   
#Export the result Array to CSV file  
$LargeListsResult | Export-CSV "c:\LargeListData.csv" -NoTypeInformation       

https://www.sharepointdiary.com/2015/03/powershell-to-find-all-large-lists-exceeding-threshold-limit.html

Thanks & Regards,

Answer 2

this will get me a report of all lists exceeding threshold set at the web/app level. That's not what I'm talking about. You have the option of disabling throttling at the individual list level per the link I included in my original post. I want to know how we can get a report of lists that have had throttling disabled at the list level.

Answer 3

Hello @Rumi ,

You could run the following script in SharePoint Online/2010/2013/2016.

if(!(Get-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction:SilentlyContinue))  
{   
    Add-PSSnapin Microsoft.SharePoint.PowerShell   
}  
$webApplicationURL = Read-Host “Enter SharePoint Web Application URL”  
$reportPath = Read-Host “Enter full Path URL in the format”  
$webapplication = Get-SPWebApplication $webApplicationURL  
$sites = $webapplication.Sites  
Write-Output “SharePoint List URL” | Out-File $reportPath  
foreach($site in $sites)  
{  
$webs = $site.AllWebs  
foreach($web in $webs)  
{  
$lists = $web.Lists  
foreach($list in $lists)  
{  
if(-not $list.EnableThrottling)  
{  
$listUrl = “$($web.Url)$($list.DefaultViewUrl)”  
Write-Host $listUrl -ForegroundColor Red  
Write-Output $listUrl | Out-File $reportPath -append  
}  
}  
$web.Dispose()  
}  
$site.Dispose()  
}  
Write-Host completed successfully!” -ForegroundColor Green  

You could refer to this article How to check if the list level Throttling is enabled or not in SharePoint Online/2010/2013/2016 .

Thanks,
Echo Du

========================

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.