Report showing all users and what percentage of their resource has been allocated to what projects.
Hi,
|
One answer
Ralph Schoon (63.6k●3●36●46)
| answered May 11 '17, 4:18 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER 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: https://www.google.com/search?q=user+assignment+API+site%3Ajazz.net
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
.getClientLibrary(IResourcePlanningClient.class);
ResourcePlanningManager resourcePlanningManager = resourcePlanning
.getResourcePlanningManager();
IContributorInfo info = resourcePlanningManager.getContributorInfo(
this.user, true, monitor);
ItemCollection<IWorkResourceDetails> details = info
.getWorkDetails(this.user);
return details;
}
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.