Worklog/timespent report (with changes and projects)

Worklog/timespent report (with changes and projects)

Hello, we have a time spent report, but only show the worklogs from workorders.
We want to show also the worklogs from changes and projects.

I have seen this report but don't work in my environment: https://pitstop.manageengine.com/portal/community/topic/timespent-report-requests-project-and-changes

We have SDP 11.0 and SQL Server.

This is our query now:

SELECT "ct"."TS_ENDTIME" AS "Hora de finalización del tiempo empleado", "wo"."WORKORDERID" AS "ID de la solicitud", "wo"."TITLE" AS "Asunto", "ct"."TS_STARTTIME" AS "Hora de inicio del tiempo empleado", "ct"."TS_ENDTIME" AS "Hora de finalización del tiempo empleado", "ct"."TIMESPENT" AS "Tiempo empleado", "wtd"."NAME" AS "Tipo de registro de trabajo", "rctd"."FIRST_NAME" AS "Técnico del tiempo empleado"  FROM "WorkOrder" "wo" LEFT JOIN "WorkOrderToCharge" "wotoc" ON "wo"."WORKORDERID"="wotoc"."WORKORDERID" LEFT JOIN "ChargesTable" "ct" ON "wotoc"."CHARGEID"="ct"."CHARGEID" LEFT JOIN "SDUser" "rcti" ON "ct"."TECHNICIANID"="rcti"."USERID" LEFT JOIN "AaaUser" "rctd" ON "rcti"."USERID"="rctd"."USER_ID" LEFT JOIN "WorkLogTypeDefinition" "wtd" ON "ct"."WORKLOGTYPEID"="wtd"."WORKLOGTYPEID" WHERE  ( ( "rctd"."FIRST_NAME" = N'My name here' ) AND ( ( ( "ct"."TS_ENDTIME" >= 1592172000000 ) AND ( ( "ct"."TS_ENDTIME" != 0 ) AND ( "ct"."TS_ENDTIME" IS NOT NULL ) ) ) AND ( ( "ct"."TS_ENDTIME" <= 1592776799000 ) AND ( ( ( "ct"."TS_ENDTIME" != 0 ) AND ( "ct"."TS_ENDTIME" IS NOT NULL ) ) AND ( "ct"."TS_ENDTIME" != -1 ) ) ) ) )  AND wo.ISPARENT='1'  ORDER BY 1, 2