
200
CHAPTER 7 AdministrAting shArePoint 2010with Powershell
Access Services
Access Services provides the Set-SPAccessServiceApplication cmdlet to configure various settings.
You may use the name of the Access Services service application as the identity (instead of the GUID).
To verify the name use
Get-SPAccessServiceApplication.
Set-SPAccessServiceApplication
-Identity <SPAccessServiceApplicationPipeBind>
[-ApplicationLogSizeMax <Int32>]
[-CacheTimeout <Int32>] [-ColumnsMax <Int32>]
[-Confirm [<SwitchParameter>]]
[-NonRemotableQueriesAllowed <SwitchParameter>]
[-OrderByMax <Int32>] [-OuterJoinsAllowed <SwitchParameter>]
[-OutputCalculatedColumnsMax <Int32>]
[-PrivateBytesMax <Int32>] [-RecordsInTableMax <Int32>]
[-RequestDurationMax <Int32>]
[-RowsMax <Int32>]
[-SessionMemoryMax <Int32>]
[-SessionsPerAnonymousUserMax <Int32>]
[-SessionsPerUserMax <Int32>]
[-SourcesMax <Int32>]
[-TemplateSizeMax <Int32>]
Excel Services
Excel Services is similar to Access Services because there is a Set-SPExcelServiceApplication
cmdlet available to configure the service application settings. You may also use the service applica-
tion name as the identity. Use the
Get-SPExcelServiceApplication cmdlet to verify the name.
Set-SPExcelServiceApplication
[[-Identity] <SPExcelServiceApplicationPipeBind>]
[-CachingOfUnusedFilesEnable <SwitchParameter>]
[-Confirm [<SwitchParameter>]]
[-CrossDomainAccessAllowed ...