在资源的所有项目中查找任务分配 [英] Finding Task Assignments across all the projects for a resource

问题描述

有没有办法找出使用PWA分配给特定资源的所有任务（ 从所有项目 ）？

Is there a way to find out all the tasks assigned (from all the projects) to a particular resource using PWA?

推荐答案

您好，


您可以使用SQl查询查找报告数据库中的资源分配或来自publsihed数据库的PSI。您也可以尝试使用PWA资源中心查看资源分配。



用于查找资源，项目和资源的SQL查询任务信息：

Hi There,

You can use SQl query to find the resource assignments in reporting database or PSI from publsihed database. You may also try to use PWA resource center to view resource assignments.

SQL query to find resource , project & task information:

select 
puv.ProjectName as [Project Name],
auv.ResourceUID as [Resource UID],

ruv.ResourceName as [Resource Name],
tuv.TaskName as [Task Name],
tuv.TaskStartDate as [Task Start Date],
tuv.TaskFinishDate as [Task Finish Date],
tuv.TaskIsCritical as [Task Is Critical],
tuv.TaskWork as [Task Work],
tuv.TaskRemainingWork as [Task Remaining Work],
tuv.TaskActualWork as [Task Actual Work],
tuv.TaskOvertimeWork as [Task Overtime Work],
tuv.TaskActualOvertimework as [Task Actual Overtime Work]
from 
MSP_EpmAssignmentByDay_UserView aduv
left outer join
MSP_EpmAssignment_UserView auv
on aduv.AssignmentUID = auv.assignmentuid
left outer join
msp_epmproject_userview puv
on auv.ProjectUID = puv.ProjectUID
left outer join
msp_epmresource_userview ruv
on auv.ResourceUID = ruv.ResourceUID
left outer join 
msp_epmtask_userview tuv
on auv.TaskUID = tuv.TaskUID

这篇关于在资源的所有项目中查找任务分配的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！