Query to get the capacity of a resource pool
I am trying to return the capacity of resource pool with a query.
I've tried the following one but the numbers aren't correct.
My ressource pool capacity for January 2020 is 18 in PPM Frontend but the query return me a higher result.
I've tried :
- the debug console to understand how it works but unfortunately, I can't understand.
- to use the rsc_rp_distribution_entries table but I don't know how to use it correctly.
join ppm_fiscal_periods pfp on pfp.fiscal_period_id = krpps.period_id
join rsc_resource_pools rrp on rrp.resource_pool_id = krpps.resource_pool_id
and pfp.long_name like '%2020'
and rrp.resource_pool_name = '123-ResourcePoolName'
order by 1,2,3;