Work log + Tasks report

Work log + Tasks report

Hi Team,
I need to make a report with the time spent in a request, I custom it Tabular report - Time Spent... but the report don´t add the work logs within the tasks, so the report is partiallly useful.

The report must contain (minimum)
- Request ID
- Account
- Subject
- Time spent technician
- Dates
- task name (if exists)
etc..

I don´t know Postgres query, i need to obtain the total of hours spend in a request tasks and work logs.

Thanks for further help

Mike Diamond
                New to ADManager Plus?

                  New to ADSelfService Plus?