Trying to create a report showing planned hours per resource group per month.....

[champamp]

Hi - trying to create a report that buckets planned hours by month per resource plan per resource group.

However, I can only locate planned hours in aggregate in the resource_plan table. I thought I might find it by month in resource_allocation_monthly, but no joy.

I thought that maybe biz logic was doing the breakout by month (you can see it in the allocation workbench) - but user changes to planned hours per month are being persisted - so this must live *somewhere* in the ServiceNow data model....

Any guidance appreciated!

Thank you,

-Brad

[martinjanke]

Hi,

allocation per user, month and resource plan can be found in the table resource_allocation.

Requested hours per resource plan and month are in requested_allocation

Aggregated data per Demand/Project and user can be found in resource_aggregate_monthly.

There is a database view group_resource_aggregate_monthly which joins resource_aggregate_monthly with sys_group: with some filtering you can use that view to make aggregated reports per group.

[champamp]

Thank you! Are you saying that requested hours = planned hours? 

UPDATE - Requested hours <> planned hours - I still have not located this data in the SN data model.

[DBCOM]

I'm trying to accomplish the same in hopes that I can produce a resource plan / allocation view by month based on the sum of hours, but currently,  the current resource tables I've tried to pull from, including "Resource_Plan", doesn't provide me hours broken down by month.