如何跟踪“关闭任务以更新”在Project Server 2010中使用报表数据库 [英] How can Track "Close Task to Update" using Reporting Database in Project Server 2010

问题描述

大家好

我有一些标记为"关闭要更新的任务"的任务使用"服务器设置" Project Server 2010中的页面。

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?

问候

- Mhhe

推荐答案

据我所知，你不会在报告数据库中找到它。

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

但可以在已发布的数据库中找到它。您必须使用表MSP_Assignments。在这里你可以找到一个WASSN_LOCKDOWN_BY_MANAGER列。

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.

你可以从MSP_EPMTask T内连接上做一个

You can do a

SELECT *在T.taskuid上的ProjectServer_Published.dbo.msp_assignments A = A.Task_UID其中A.WASSN_LOCKDOWN_BY_MANAGER = 1

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

"要更新的关闭任务"类似于statusmanager字段 - 你在任务级别设置它，但在数据库中它存储在赋值级别。

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.

希望有帮助

问候

Christoph

Christoph

这篇关于如何跟踪“关闭任务以更新”在Project Server 2010中使用报表数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！