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

 

Here is Output:

delay task