Get Delay Task Data in Project Server 2013

Get Delay Task:-

Project delay task in project server are those task which have start date less than current date. There are two way to get Resource Name with Group Name first is using Project server Interface and second is Sql query. Here i am getting Resource Name with Group Name by sql query:-

Select distinct Project.ProjectName, Task.TaskName, Task.TaskBaseline0FinishDate, Task.TaskActualFinishDate,
Task.TaskPercentCompleted, Task.TaskUID, 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
where getdate()> Task.TaskBaseline0StartDate


Here is Output:

delay task


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 !!