Time by Resource and Investment -PM – SQL

The Time By Resource and Investment – PM portlet shows time spent on projects where the logged in user is the project manager.  This portlet is used to get a snapshot of investments and the time that has been put against them at the individual resource level for the projects that user has access to. This portlet is used for determining what resources have put time against specific investments and can be used to see where resources are spending their time or to help rationalize ETCs for remaining work for planning purposes. The portlet may be filtered by time-scale, date, resource or investment to narrow the search results.