Parameters   Output Objects  

Searches Microsoft SharePoint data.

Syntax

Select-SharePoint [parameters]

Remarks

The Select-SharePoint cmdlet allows you to use a syntax similar to SQL SELECT statements to search Microsoft SharePoint data.

$conn = Connect-SharePoint -User 'MyUserAccount' -Password 'MyPassword' -AuthScheme 'NTLM' -URL 'http://sharepointserver/mysite;'
Select-SharePoint -Connection $conn -Table "Calendar" -Columns @("Id","Location") -Where "Location='Chapel Hill'"