none
How can Track "Close Task to Update" using Reporting Database in Project Server 2010 RRS feed

  • Question

  • Hi everybody

    I have some task that is marked as "Close task to update" using "server setting" page in Project Server 2010.

    But I want to know that what field is changed when I close some tasks? and how can I find these task using reporting database?

    Regards

    --Mhhe

    Saturday, July 14, 2012 7:05 AM

All replies

  • Hi,

    as far as I know you will not find it in the reporting database.

    But can find it in the published database. You have to use the table MSP_Assignments. Here you find a column WASSN_LOCKDOWN_BY_MANAGER.

    You can do a

    SELECT * from MSP_EPMTask T inner join ProjectServer_Published.dbo.msp_assignments A on T.taskuid=A.Task_UID where A.WASSN_LOCKDOWN_BY_MANAGER = 1

    The "close task to update" is similar to the statusmanager field - you set it on a task level, but in the database it is stored on assignment level.

    Hope that helps

    Regards

    Christoph

    Saturday, July 14, 2012 5:34 PM
  • Hi,

    Thank you for your reply.

    How can we view these Tasks in a excel services report?

    can we view these tasks in BI Center?

    Please Help.

    Saturday, May 11, 2013 12:54 PM