I've tried to use the custom report on ManageEngine to pull a report that could show the total number of hours spent by Technicians on a client site i.e. worklog type is site visit. 

I would like a monthly report grouped by customer.

Please can you help me with a MS SQL query this would help us know how many hours we've spent on each client's site.

Thank you.

Best regards,

Margaret.