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.
Next Recommended Reading Could Not Find Server 'Server Name' In sys.servers In SQL Server