Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Find local resource name in database RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    1
    Sign in to vote

    This is related to MSPS 2007.

    I am looking at finding the resource name for the tasks where the assigned resource is not from enterprise pool. If I look at the reporting schema, the resource for such an assignment returns "Generic Local Resource". But if I see the MPP, I also get a name. Is it possible to get this name as in the MPP along with this?

    Does that helps?
    --------------------------------------------------------
    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”.
    Thanks,
    Kangkan Goswami |Technical Architect| Blog: http://www.geekays.net/
    http://in.linkedin.com/in/kangkan


    • Edited by Kangkan Tuesday, July 2, 2013 11:16 AM
    Tuesday, July 2, 2013 11:16 AM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote
    I believe, that information is only in the published database. Since querying is not allowed directly on the published database, you will have use to PSI methods.

    Prasanna Adavi, PMP, MCTS http://thinkepm.blogspot.com

    • Marked as answer by Kangkan Wednesday, July 10, 2013 12:57 PM
    Tuesday, July 2, 2013 11:34 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote
    I believe, that information is only in the published database. Since querying is not allowed directly on the published database, you will have use to PSI methods.

    Prasanna Adavi, PMP, MCTS http://thinkepm.blogspot.com

    • Marked as answer by Kangkan Wednesday, July 10, 2013 12:57 PM
    Tuesday, July 2, 2013 11:34 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Kangkan,

    The project plan contains local resources. Project save the information's for these local resources as "Generic Local Resource".

    You may be able to extract it by calling a PSI, but I am sorry I cant think of a PSI call that gets local resource names.

    Regards,

    Dinesh Rai

    Cheers. Happy troubleshooting !!! Dinesh S. Rai - MSFT Enterprise Project Management

    Sunday, July 7, 2013 6:45 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I wrote a post on my blog about fetching users emails:

    http://sharepoint1on1.blogspot.com/2013/01/project-server-2010-get-group-members.html

    Just change

    tEmailsList.Add(resourceRow.WRES_EMAIL);

    to

    tEmailsList.Add(resourceRow.RES_NAME);

    and it will return usernames of all users.

    Monday, July 8, 2013 12:04 PM