Option 1: There's an Advanced Reporting report called Resource Assignments by Task that can help. While it doesn't have the Task ID, it is broken down by Resource and shows the amount of ETC. that can be used to match up the ETC and Resource
Option 2: From the Resource Allocations page
- Go to Home->Resource Planning->Resources
- Click on the Resource
- Click on the Allocations tab
- Click on the link to the project
- Click on the Tasks tab for the project,
- Select Assignments from the Tasks tab drop down
- On this page, you can filter on the resource to see if the task comes up
Option 3: From Organizer ->Tasks section (Logged in as user task is assigned to)
- Log in as the user the task is assigned to
- Go to Home->Personal->Organizer->Tasks
- Add Task ID to the column view
- Cross reference the Task ID with the amount of ETC if multiple tasks have the same amount of ETCs
Option 4: <For On Premise customers> Using the below queries can help depending on whether you have the Task ID or Task Name
- select * from PRTASK where prname = 'task name'
- select * from PRTASK where PREXTERNALID = 'Task ID'
Note the 'PRPROJECTID' from one of the above queries then run:
select * from inv_investments where id = 'PRPROJECTID' from query above
This will give you the project ID and name
Option 5: You can also create a custom portlet using Task as the Data Provider