Get the list of Project names and site address RRS feed

  • Question

  • SharePoint project server 2016.
    Need assistance to get the list of project names and the associated/connected SharePoint sites.
    Do we have any power-shell which would give us the output in excel.

    Please advise.


    Monday, November 5, 2018 6:56 PM


  • There might be some powershell, but instead try the Odata feed which works with on prem as well as online.   If you use the URL https://<yourtenant>/sites/pwa/_api/ProjectData/Projects and select the ProjectName and ProjectWorkspaceInternalURL columns you'll get what you need.

    Ben Howard [MVP] | web | blog | book | downloads | P2O

    Tuesday, November 6, 2018 7:48 AM