Get a Specific Trusted Data Connection Library

Scenario/Problem: You need to obtain a specific trusted data connection library reference.

Solution: Use the Get-SPExcelDataConnectionLibrary cmdlet to assign a variable the results using the -Identity and -ExcelServiceApplication parameters.

Providing the identity of the trusted data connection library to the Get-SPExcelDataConnectionLibrary cmdlet retrieves a specific data connection library instance. Use this to assign the results to a variable for use in other cmdlets, as shown in Listing 21.7.

Listing 21.7. Assigning a Variable to a Specific Data Connection Library

$trustedLibrary = Get-SPExcelDataConnectionLibrary
-Identity "http://sp2010/Data Connections"
-ExcelServiceApplication "Excel Services Application"

Tip

When you are creating a new trusted file location, the Identity becomes the same value as the Address property, as shown in the results. Refer to the figures in the previous sections for examples.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.117.103.5