none
How to find users current project? RRS feed

  • Question

  • Hi

    I want to identify and find that which one of my Project Server Users is in what Project in the specific time or in the Current time and find his/her Project Manager

    for example, i want to identify that Mr.Smith is in what project in 2010.10.15 and find his Project Manager

    Please give me some suggestions

     

    Sunday, October 3, 2010 11:30 AM

Answers

  • My current client generates a weekly status report in SSRS that goes to top
    management and includes the PM field.  It rarely is left unpopulated more
    than one reporting cycle.... ;-)
     
    There is an option in MPP to automatically prompt users to complete File
    Properties when they create a new file.  That's the closest I've seen to
    autopopulating it.
     Andrew Lavinsky [MVP]
    Twitter: @alavinsky
     
     

    Andrew Lavinsky [MVP] Twitter: @alavinsky Blog: http://blogs.catapultsystems.com/epm
    Wednesday, October 6, 2010 1:58 PM
    Moderator

All replies

  • So, project server? 2007 or 2010?

    I'll assume project server. In the Reporting db you can create a View that looks at teh time phased data to get a list of all resources with work on a specific date by looking at MSP_EpmAssignmentByDay_UserView. Link it to MSP_EpmAssignment_UserView to get Resource UID and Project UID and link to MSP_EpmResource_UserView and MSP_EpmProject_UserView to get Project Name and manager plus any other project custom fields you need.

    Full details in schema in free Project SDK download from microsoft.com


    Rod Gill

    The one and only Project VBA Book Rod Gill Project Management
    Sunday, October 3, 2010 8:11 PM
    Moderator
  • In Project Server 2010 SQL Server

    When i look at dbo.msp_EpmProject

    I can see the projectUID & project name & ProjectAuthorName & ProjectManager, but ProjectManager Field is empty, i was created this specific project with project professional 2010 and in the Manager Users section in server settings i was in Project Manager Group, but Database shows that no one is project Manager for this Project

    how can i solve this issue?

    Please give me some suggestions

    Wednesday, October 6, 2010 6:20 AM
  • See response in other newsgroup.  The PM field is populated through File
    > Properties within the Microsoft Project client.
     
    After populating, save and publish.
     Andrew Lavinsky [MVP]
    Twitter: @alavinsky
     
     

    Andrew Lavinsky [MVP] Twitter: @alavinsky Blog: http://blogs.catapultsystems.com/epm
    Wednesday, October 6, 2010 12:42 PM
    Moderator
  • You can also find in DB:

    In RDB you can find this information in field ProjectOwnerResourceUID in view MSP_EpmProject_UserView. Linking to MSP_EpmResource_UserView will give you the name (corresponds to Owner on Project Information page)

    Regards
    Barbara

    Wednesday, October 6, 2010 1:17 PM
    Moderator
  • Just to clarify - Barbara's answer is also correct.  There are two fields:
    Owner and Project Manager.  Owner actually has security implications.  Project
    Manager AFAIK simply displays on PWA views.
     
    In some environments, the PM and the Owner are the same.  In others, the
    Owner is the scheduler who reports to the PM.
     
    Andrew Lavinsky [MVP]
    Twitter: @alavinsky
     
     

    Andrew Lavinsky [MVP] Twitter: @alavinsky Blog: http://blogs.catapultsystems.com/epm
    Wednesday, October 6, 2010 1:41 PM
    Moderator
  • Hi Andrew,

    have you ever found a way to default this field in Project Properties? Since I have never found a way to force a user to maintain this field or to auto-populate a value, I skip this field most of the time. If you have any solution, I will appreciate (except training ;-))!

    Thanks!
    Barbara

    Wednesday, October 6, 2010 1:48 PM
    Moderator
  • My current client generates a weekly status report in SSRS that goes to top
    management and includes the PM field.  It rarely is left unpopulated more
    than one reporting cycle.... ;-)
     
    There is an option in MPP to automatically prompt users to complete File
    Properties when they create a new file.  That's the closest I've seen to
    autopopulating it.
     Andrew Lavinsky [MVP]
    Twitter: @alavinsky
     
     

    Andrew Lavinsky [MVP] Twitter: @alavinsky Blog: http://blogs.catapultsystems.com/epm
    Wednesday, October 6, 2010 1:58 PM
    Moderator
  • Hi Andrew,

    this weekly could also be a reason for not filling - if there are issues on that project ;-). The option to complete File Properties is a good idea. Thanks a lot!!!

    For most of my customers, there is no difference between scheduler and PM, so I have not to think about it that often. (Just read your definition in your other post). Customers are using owner field as PM field. If PM changes, they modify owner field.

    Thanks for new thoughts!
    Barbara

    Wednesday, October 6, 2010 2:03 PM
    Moderator
  • In IT, it's usually the same person playing both roles.  In construction
    or equipment maintenance, I see the roles split out a lot. 
     
    One could possibly define a relationship between the average greyness of
    a PM's hair in a specific industry and how much computer based scheduling
    they actually do, but I certainly would never consider doing so.
     
    Andrew Lavinsky [MVP]
    Twitter: @alavinsky
     
     

    Andrew Lavinsky [MVP] Twitter: @alavinsky Blog: http://blogs.catapultsystems.com/epm
    Wednesday, October 6, 2010 2:20 PM
    Moderator