locked
Pulling the resouces at the task level from the database RRS feed

  • Question

  • I would like to pull all the resources per task from the back-end database (SQL Server). Since you can assign multiple resources to multiple tasks ( many to many relationship), I wanted to know which tables to query to get that data.  
    Friday, February 16, 2018 7:45 PM

Answers

  • Hello,

    The assignment data will all be in the Assignment tables / views in the reporting schema / reporting database. For example: MSP_EpmAssignment, MSP_EpmAssignmentByDay, MSP_EpmAssignment_UserView, MSP_EpmAssignmentByDay_UserView. Then join to other table such as MSP_EpmResource, MSP_EpmTask, MSP_EpmProject to get get other properties as needed.

    Paul


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

    • Marked as answer by PWMatherMVP Tuesday, February 27, 2018 10:49 PM
    Saturday, February 17, 2018 9:52 AM