none
Deleting Project Server Enterprise Objects RRS feed

  • Question

  • We have been deleting Enterprise Projects in the past but, not checking the box to "<label for="ctl00_ctl00_PlaceHolderMain_PWA_PlaceHolderMain_deleteSharePointSites">Delete the connected SharePoint sites"
    </label>Now I am worried that we have old orphaned sites out there and wanted to see if there was an easy way to identify them and

    have them removed.<label for="ctl00_ctl00_PlaceHolderMain_PWA_PlaceHolderMain_deleteSharePointSites"></label>


    Ron Johnson Systems Administrator Michigan State University Federal Credit Union Office – (517) 333-2391 ron.johnson@msufcu.org WWW.MSUFCU.ORG

    Thursday, July 9, 2015 8:57 PM

Answers

  • Hi,

    you could get a list of all your subwebs using Powershell:

    $site=get-spsite -identity "yourpwaurl"
    $site.allwebs

    and compare this with the list of relevant subwebs you get from SQL:

    select ProjectWorkspaceInternalHRef from msp_epmproject_userview order by 1

    Everything that is in the first list but not in the second will probably be orphaned.

    Hope that helps

    Kind regards

    Christoph


    Christoph Muelder | Senior Consultant, MCTS, MCSE | SOLVIN information management GmbH, Germany

    • Marked as answer by RonJohnMSU Friday, July 10, 2015 12:56 PM
    Friday, July 10, 2015 12:28 PM

All replies

  • Hi,

    you could get a list of all your subwebs using Powershell:

    $site=get-spsite -identity "yourpwaurl"
    $site.allwebs

    and compare this with the list of relevant subwebs you get from SQL:

    select ProjectWorkspaceInternalHRef from msp_epmproject_userview order by 1

    Everything that is in the first list but not in the second will probably be orphaned.

    Hope that helps

    Kind regards

    Christoph


    Christoph Muelder | Senior Consultant, MCTS, MCSE | SOLVIN information management GmbH, Germany

    • Marked as answer by RonJohnMSU Friday, July 10, 2015 12:56 PM
    Friday, July 10, 2015 12:28 PM
  • Thank you. That is what I needed.

    Ron Johnson Systems Administrator Michigan State University Federal Credit Union Office – (517) 333-2391 ron.johnson@msufcu.org WWW.MSUFCU.ORG

    Friday, July 10, 2015 12:56 PM