Post
Ask Question

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.

  1. select R.ResourceName  
  2.   
  3.     , RBD.Capacity  
  4.   
  5.     , RBD.TimeByDay  
  6.   
  7. from MSP_EpmResource_UserView R  
  8.   
  9. INNER JOIN MSP_EpmResourceByDay_UserView RBD  
  10.   
  11. ON R.ResourceUID = RBD.ResourceUID  
  12.   
  13. 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.