Resource Heat Map In Project Server 2013

We can achieve this by writing a simple query in SQL Server, as shown below.

Open the SQL Server and login to the SQL Server DB.

Once you are done with this, just open a new window (ctrl+N) and copy and paste the below query to achieve the task.

select R.ResourceName

    , RBD.Capacity

    , RBD.TimeByDay

from MSP_EpmResource_UserView R

INNER JOIN MSP_EpmResourceByDay_UserView RBD

ON R.ResourceUID = RBD.ResourceUID

where TimeByDay Between GetDate() and Getdate() + 5

The result looks like the below screen.

From the results, we can check the capacity of resources by the day.