Friday, 29 January 2016

OneLiners in Powershell with SharePoint for Excel Services

#ExcelService
Get-SPExcelServiceApplication
#Get Excel BI Server
Get-SPExcelServiceApplication | Get-SPExcelBIServer
#Get Excel Bloacked File type
Get-SPExcelServiceApplication | Get-SPExcelBlockedFileType
#Get Excel Data Connection Library
Get-SPExcelServiceApplication | Get-SPExcelDataConnectionLibrary
#Get Excel Data Provider
Get-SPExcelServiceApplication | Get-SPExcelDataProvider
#Get Excel File Location
Get-SPExcelServiceApplication | Get-SPExcelFileLocation
#Get Excel User Defined file
Get-SPExcelServiceApplication | Get-SPExcelUserDefinedFunction

No comments:

Post a Comment