AssignmentOwner in SQL query RRS feed

  • Question

  • I need to build SQL-view based on data MS Project 2013/16

    The data should include information from timesheets with some addons.

    I'm using as a standard source [ProjectWebApp].[dbo].[MSP_TimesheetActual] with joins to reference tables (resources, timebyday, etc.). Also, I still need to get information on the assignment owner (управляющий назначениями, status manager). But I can`t find this information in database!

    Where can you get it from? 

    Tuesday, April 23, 2019 7:07 PM

All replies

  • The AssignmentOwner is a field related to the Assignments table. you can get the ResourceOwnerUID in the dbo.MSP_EpmAssignment and reference the GUID with the Resource table. 

    if you are looking to see who is responsible for approving a task in the timesheet, then look for ApproverResourceNameUID in the dbo.MSP_TimesheetLine

    Ali Al . PPM Consultant & Development Manager.
    FB TW IN

    Wednesday, April 24, 2019 2:44 AM