My Resource Count by Project – SQL

The My Resource Count by Project portlet displays project information, total team count and the current user’s resource count assigned to each project. The user may narrow the results by filtering on project name, manager, status, team count, managed resource count or percentage managed resource count.

Using this portlet, resource managers can quickly identify which projects their resources are allocated to without having to navigate to each resource individually. Not only does this portlet display the overall team count on the project (team count), but it also displays the managed resource count (logged in user’s number of resources allocated to the project) as well as the percentage of managed resource count to team count.