数据库管理团队的哪些表工作？ [英] What table of the database management teams work?

问题描述

我需要知道
表存储 数据
团队 项目工作 。 我
了解 分配给 在报告中
的项目 。

非常感谢 。

解决方案

您好，

您是在寻找项目团队中的资源还是在项目上有分配的资源？如果稍后，此信息在Project Server 报告数据库中提供（假设PS 2010/2007），下面的示例查询：

选择R.ResourceName 
，P.ProjectName 
，T.TaskName 
，A.AssignmentStartDate 
，A.AssignmentFinishDate 
，AD.TimeByDay as [Assignment Date] 
， AD.AssignmentWork 
，A.AssignmentPercentWorkCompleted 
，AD.AssignmentRemainingWork 
 from dbo.MSP_EpmAssignment_UserView A 
 Inner Join MSP_EpmAssignmentByDay_UserView AD 
 AD.AssignmentUID = A.AssignmentUID and AD .AssignmentWork> '0'
内部加入MSP_EpmResource_UserView R 
 ON R.ResourceUID = A.ResourceUID 
内部加入MSP_EpmProject_UserView P 
 On P.ProjectUID = A.ProjectUID 
 Inner Join MSP_EpmTask_UserView T 
 ON T.TaskUID = A.TaskUID和T.TaskIsProjectSummary = 0 
 
其中P.ProjectName ='项目名称' - 更新项目名称，甚至用于P.ProjectUID = 'Project GUID'

这将仅显示带有分配的资源，以查看项目团队中的资源而无需使用PSI进行分配：

http://msdn.microsoft.com/en-us/library/gg178522。 aspx

可以在此处看到通过PSI和PowerShell阅读项目团队的示例：

http://pwmather.wordpress.com/2012/01/12/projectserver -2010-PSI-PowerShell的为例es-ps2010-msproject-sp2010 /

谢谢

Paul

I need to know which table stores the data of team project work. I have to know the resources assigned to a project to be viewed in a report.
Thank you very much.

解决方案

Hi there,

Are you looking for the resources that are on the project team or resources that have assignments on the project? If the later, this information is available in the Project Server Reporting database (assuming PS 2010 / 2007), example query below:

select		R.ResourceName
		,	P.ProjectName
		,	T.TaskName
		,	A.AssignmentStartDate
		,	A.AssignmentFinishDate
		,	AD.TimeByDay as [Assignment Date]
		,	AD.AssignmentWork
		,	A.AssignmentPercentWorkCompleted
		,	AD.AssignmentRemainingWork
from dbo.MSP_EpmAssignment_UserView A
Inner Join MSP_EpmAssignmentByDay_UserView AD
On AD.AssignmentUID = A.AssignmentUID and AD.AssignmentWork > '0'
Inner Join MSP_EpmResource_UserView R
ON R.ResourceUID = A.ResourceUID
Inner Join MSP_EpmProject_UserView P
On P.ProjectUID = A.ProjectUID
Inner Join MSP_EpmTask_UserView T
ON T.TaskUID = A.TaskUID and T.TaskIsProjectSummary = 0

where P.ProjectName = 'Project Name' -- update for Project Name or even use where P.ProjectUID = 'Project GUID'

This will only show resources with assignments, to view resources that are on the project team without assignments you will need to use the PSI:

http://msdn.microsoft.com/en-us/library/gg178522.aspx

An example of reading the project team via the PSI and PowerShell can be seen here:

http://pwmather.wordpress.com/2012/01/12/projectserver-2010-psi-powershell-examples-ps2010-msproject-sp2010/

Thanks

Paul

这篇关于数据库管理团队的哪些表工作？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！