none
To find Resources who are part of build team RRS feed

  • Question

  • Hi,

    We need to find all those resources who are part of build team but are not assigned to any task. How can we achieve this?

    Currently, resource assignment view in resource center provides a view of resources who have task assigned in a project.

    Your help is appreciated.

    Best Regards,

    Anuja


    • Edited by Anujaa Tuesday, February 3, 2015 8:07 AM
    Tuesday, February 3, 2015 8:07 AM

Answers

  • Hi Anujaa,

    this information can be found in MSP_PROJECT_RESOURCES_PUBLISHED_VIEW in Draft DB and in MSP_PROJECT_RESOURCES_WORKING_VIEW in Published DB. So far I haven't been not able to find this information in Reporting DB.

    NOTE: Queries on DBs other than Reporting are not supported!!!

    In PSI there is a ReadProjectTeam method, this could also help? ANd this approach is supported.

    Regards
    Barbara


    To increase the value of this forum, please mark the replies that helped to solve your issue as answer. If you find answers to questions from other forum participants to be helpful, please mark them as helpful. Your participation will help others to find an appropriate solution faster. Thanks for your support!

    • Marked as answer by Anujaa Tuesday, February 3, 2015 11:55 AM
    Tuesday, February 3, 2015 8:41 AM
    Moderator

All replies

  • Hi Anujaa,

    this information can be found in MSP_PROJECT_RESOURCES_PUBLISHED_VIEW in Draft DB and in MSP_PROJECT_RESOURCES_WORKING_VIEW in Published DB. So far I haven't been not able to find this information in Reporting DB.

    NOTE: Queries on DBs other than Reporting are not supported!!!

    In PSI there is a ReadProjectTeam method, this could also help? ANd this approach is supported.

    Regards
    Barbara


    To increase the value of this forum, please mark the replies that helped to solve your issue as answer. If you find answers to questions from other forum participants to be helpful, please mark them as helpful. Your participation will help others to find an appropriate solution faster. Thanks for your support!

    • Marked as answer by Anujaa Tuesday, February 3, 2015 11:55 AM
    Tuesday, February 3, 2015 8:41 AM
    Moderator
  • Hello,

    As Barbara mentioned, to get this information in a supported way, use the PSI. An example using PowerShell can be found in this post:

    https://pwmather.wordpress.com/2012/01/12/projectserver-2010-psi-powershell-examples-ps2010-msproject-sp2010/

    The example code is:

    $pwaUrl = "http://vm353/pwatest" 
    $svcProjectUrl = $pwaUrl + "/_vti_bin/PSI/Project.asmx?wsdl" 
    $c = Get-Credential 
    $svcProjectProxy = New-WebServiceProxy -uri $svcProjectUrl -credential $c 
    $svcProjectProxy.ReadProjectTeam("3DC95F6F-60C4-48CB-8DA0-AA28DA6E31FD").ProjectTeam #will return all fields in the ProjectTeam dataset for the given project  GUID.

    Paul

    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Tuesday, February 3, 2015 9:02 AM
    Moderator