Searching for tasks assigned to specific user

[TomW]

I am trying to find open tasks that have been assigned to a specific person i.e. approval tasks, so that I can chase them up with the assignee. I was planning on doing this by creating a report that shows all their unanswered tasks. What tables do I need to search in order to do this?

Thanks

[Victor]

Requests Table

and Tasks table

 

Possibly you could also build views in Activities List to show you what you need but I can't confirm 100%....

 

[Deen]

@TomW I believe h_sys_tasks would be the main table with the h_owner column being the task owner.