Get Project Task Detail in Project Server 2013

Project Task Detail in Project Server 2013 :-

Before to get Project task detail i would like to explain what is task, task is an activity that needs to be accomplished within a defined period of time or by a deadline to work towards work-related goals

Select Project.ProjectName, Task.TaskName, Task.TaskBaseline0FinishDate, Task.TaskActualFinishDate,
Task.TaskPercentCompleted, Task.TaskUID, Res.ResourceName, Task.TaskOutlineNumber, Task.TaskIsSummary
from [diag].[pub_MSP_ASSIGNMENTS] as Assign
INNER JOIN [MSP_EpmResource_UserView] as Res ON Res.ResourceUID = Assign.RES_UID
INNER JOIN [MSP_EpmTask_UserView] as Task ON Task.TaskUID = Assign.TASK_UID
INNER JOIN [MSP_EpmProject_UserView] as Project ON Project.ProjectUID = Assign.PROJ_UID

 

Here is Output :

Project Task Detail


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

error: Content is protected !!