In PPM/SPM, if you need to report on resource plans, allocations, availability, or capacity, utilize the resource aggregate tables:
resource_aggregate_daily
resource_aggregate_weekly
resource_aggregate_monthly
A very good write up is posted here.
Latest Posts
- UI Action to Automatically Import XML into Other Instances
- Report on Custom Tables – Get Table Name, Record Count, Date of Latest Record
- Find Customized Records for Any Table
- Admin Analytics – Custom monitoring/report tool to make life easier
- Report to view Record Count for all tables
- NBA Scoreboard – Built on ServiceNow
mySNstuff.com 