Scenario/Problem: You need to display all safe data providers configured for an Excel Services application.
Solution: Use the Get-SPExcelDataProvider
cmdlet with the ExcelServiceApplication
parameter.
Using the Get-SPExcelDataProvider
cmdlet with the ExcelServiceApplication
parameter, as shown in Listing 21.10, displays all configured trusted data connection libraries.
Get-SPExcelDataProvider
-ExcelServiceApplication "Excel Services Application"
3.17.162.26