Guest User

Untitled

a guest
Mar 30th, 2018
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.71 KB | None | 0 0
  1. $SiteURL = "http://vmsrvr1:28516/"
  2.  
  3. Write-Host "Loading CSOM libraries" -foregroundcolor black -
  4. backgroundcolor
  5. yellow
  6. Add-Type -Path "c:Program FilesCommon Filesmicrosoft sharedWeb
  7. Server Extensions15ISAPIMicrosoft.SharePoint.Client.dll"
  8. Add-Type -Path "c:Program FilesCommon Filesmicrosoft sharedWeb
  9. Server Extensions15ISAPIMicrosoft.SharePoint.Client.Runtime.dll"
  10. Write-Host "Lib. successfully loaded !" -foregroundcolor black -
  11. backgroundcolor Green
  12.  
  13. $scriptPath = "D:PoCSolutions"
  14.  
  15.  
  16. $User = "mydomainadminuser1" #Read-Host -Prompt "username"
  17. $password = Read-Host -Prompt "Enter password" -AsSecureString
  18.  
  19.  
  20. Write-Host "Trying to reach $SiteURL // Handling ClientContext..." -
  21. foregroundcolor black -backgroundcolor yellow
  22. $Context = New-Object
  23. Microsoft.SharePoint.Client.ClientContext($SiteURL)
  24. $credentials = New-Object
  25. Microsoft.SharePoint.Client.SharePointOnlineCredentials($User,
  26. $password)
  27. $Context.Credentials = $credentials
  28. $context.RequestTimeOut = 5000 * 60 * 10;
  29. $web = $context.Web
  30. $site = $context.Site
  31. $context.Load($web)
  32. $context.Load($site)
  33. try
  34. {
  35. $context.ExecuteQuery()
  36. Write-Host "Connected !" -foregroundcolor black -backgroundcolor
  37. Green
  38. }
  39. catch
  40. {
  41. Write-Host "Impossible to reach $SiteURL : bad password ?" -
  42. foregroundcolor black -backgroundcolor Red
  43. return
  44. }
  45.  
  46. $list = $web.Lists["APT"];
  47. $fields = $list.Fields;
  48.  
  49. $list.Fields | select InternalName | Export-Csv -path ./blabla.csv;
  50. Write-Host "Done !" -foregroundcolor black -backgroundcolor Green
Add Comment
Please, Sign In to add comment