magritton
11/6/2015 - 5:56 PM

Powershell command in SharePoint to get the BCS throttle value. This also an example of a where working with a select. Note the GUID didn't

Powershell command in SharePoint to get the BCS throttle value. This also an example of a where working with a select. Note the GUID didn't really work.

Add-PSSnapin Microsoft.SharePoint.PowerShell -EA SilentlyContinue
$ID = Get-SPServiceApplicationProxy |  where {$_.DisplayName -like 'BCS*'} | select ID
$scuServAppProxy  = Get-SPServiceApplicationProxy -Identity 5b48a638-0ba1-4aee-825f-13d16294329f
Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $scuServAppProxy

Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $scuServAppProxy | Set-SPBusinessDataCatalogThrottleConfig -Maximum 1000000000 -Default 500000
Add-PSSnapin Microsoft.SharePoint.PowerShell -EA SilentlyContinue
$ID = Get-SPServiceApplicationProxy |  where {$_.DisplayName -like 'BCS*'} | select ID
$scuServAppProxy  = Get-SPServiceApplicationProxy -Identity 5b48a638-0ba1-4aee-825f-13d16294329f
Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $scuServAppProxy