It's all about the answers!

Ask a question

Report showing all users and what percentage of their resource has been allocated to what projects.

Lorenzo . (49311) | asked May 04 '17, 8:11 a.m.


One of our customers wants to be able to do a report showing all users and what  percentage of their resource has been allocated to what projects.

For this, they need to know how to extract the resource allocation for each resource from the database.   
Do we have the information on table and columns where this data is stored in the RTC v6.0 datamodel.

I have already send the details on  Live_Contributor_Assignment and Live_Contributor_Working_Time
tables that are are described here:

Data Warehouse Snapshot Schemas                              

I am not sure if this is all we have available.

Thanks very much

One answer

permanent link
Ralph Schoon (62.9k33645) | answered May 11 '17, 4:18 a.m.

First of all, it is discouraged to access the RTC Database directly. You should use the API, if available for that.

As far as I know, User Assignment Information is not stored in the data warehouse either. 

I was able to find several similar questions here: 

There is an internal Java API. Here some snippets I have figured out. Unfortunately I never managed to blog about it.

final IResourcePlanningClient resourcePlanning = (IResourcePlanningClient) teamRepository.getClientLibrary(IResourcePlanningClient.class);

private ItemCollection<IWorkResourceDetails> getWorkDetails(
IProgressMonitor monitor) throws TeamRepositoryException {
final IResourcePlanningClient resourcePlanning = (IResourcePlanningClient) this.teamRepository
ResourcePlanningManager resourcePlanningManager = resourcePlanning

IContributorInfo info = resourcePlanningManager.getContributorInfo(
this.user, true, monitor);
ItemCollection<IWorkResourceDetails> details = info
return details;

Your answer

Register or to post your answer.