custom report - logged time per technician per project/ticket // per month

custom report - logged time per technician per project/ticket // per month

Hi could u please help me write a custom query for our windows installation with MYSQL.

I'm looking for a report that gives me an overview for the work logs per technician be it Project or Request.


TicketId or Project ID  + Title
Work log end date.
Technician name
Work log amount of time + description

Preferable on a weekly basis.


Bonus question: is this possible if we would migrate to the cloud version of Servicedesk

Thank you.