none
Where is the information stored for Resource Availability in PWA DB ? RRS feed

  • Question

  • I need to create a query to pull the data from ResAvailability.aspx. I would like to know where is the table or tables to pull the data of Availability. 
    Tuesday, October 17, 2017 4:48 PM

Answers

  • Hi,

    you can only retrieve capacity and base capacity. This information can be found in pjrep.EPM_MSPResourceByDay_UserView. The availabilty in ResAvailability.aspx is calculated while rendering, based on Capacity and assignments. So yyou need to do the same.

    Regards
    Barbara

    Tuesday, October 17, 2017 6:03 PM
    Moderator