Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Query to find historical Timesheet Approver in Project Server 2010

Unanswered Query to find historical Timesheet Approver in Project Server 2010

  • Thursday, 7 June, 2012 8:08 PM
     
     
    Sign In to Vote
    0

    Hi Folks,

    I need the query to find original timesheet approvers for each timesheet. The current Timesheet Manager may have been changed so I don't want to rely on the field: MSP_EpmResource_UserView.ResourceTimesheetManagerUID.

    Seems like I should be able to get this out of a MSP_Timesheet table....

    MSP_Timesheet.LastStatusChangeResourceNameUID appears to be null

    Carl

     

All Replies

  • Tuesday, 12 June, 2012 1:54 AM
    Moderator
     
     
    Sign In to Vote
    0

    The Reporting db holds copies of all Timesheet data, so I would read from there.

    Good luck!

    Rod Gill

    The one and only Project VBA Book

    Rod Gill Project Management

     
  • Tuesday, 12 June, 2012 4:37 AM
     
     
    Sign In to Vote
    0

    Hi Rod,

    Yes, the timesheet tables in the Reporting db is where I am looking (see my notes), but I can't find this basic information. I hope it exists.

    Carl

     
  • Monday, 18 June, 2012 8:25 AM
     
     
    Sign In to Vote
    0

    Carl,

    Take a look at ApproverResourceNameUID in the MSP_TimesheetLine table in the RDB.

    Treb Gatte

     
  • Thursday, 21 June, 2012 5:51 PM
     
     
    Sign In to Vote
    0

    Hi Treb,

    Thats the timesheet line task status manager.

    Carl

     
  • Thursday, 21 June, 2012 6:04 PM
     
     
    Sign In to Vote
    0

    Hey Carl,

    Then either the SDK is wrong or you found a bug or both. :-)

    The SDK lists this field as "Resource GUID of the timesheet approver" which is typically not the same as the Task Status Manager.

    What about LastStatusChangeResourceNameUID in the MSP_Timesheet where the TimesheetStatusID indicates approved? Otherwise, I'm out of ideas.

    Treb Gatte

     
  • Wednesday, 27 June, 2012 9:46 PM
     
     
    Sign In to Vote
    0

    Hi Treb,

    In my system, which has April patches, TimeSheet.LastStatusChangeResourceNameUID is null. My guess is that it only gets valued when someone "adjusts actuals" - that is just a guess; I haven't tested.

    Its easy to use MSP_EpmResource_UserView.ResourceTimesheetManagerUID but that underminds the whole rational of the timesheet tables.

    Carl


    • Edited by Pelican Carl Wednesday, 27 June, 2012 9:55 PM
    •