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

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

Answer 1

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

Answer 2

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.