Query to have elapsed time for tasks, request and project tasks together

Query to have elapsed time for tasks, request and project tasks together

Hi there,

I would like to have daily report with all time spent by tecnician on tasks, requests and project tasks. I can have it sepretly but no succes to combine it.
Using ServiceDesk Plus MSP 9.4 build 9408 with MS SQL database.

                New to ADSelfService Plus?