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
,Project.ProjectUID,Task.TaskBaseline1StartDate
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:

 

---