General report on requests , changes and problems

General report on requests , changes and problems

I need to report query to generate per ticket by engineer for request, problems and changes.The table must contain ticket id, problem id, changes id,ticket subject,priority, requester, status, time spent engineer and total time spent and other. I can generate this report but only for request. I need to put in this report work log problems and changes. Can you help me to create this report query?

Sevice desk:
Our version : 9.3 Build 9301
Data base : postgres

Server service desk Ubuntu 12.04.3 LTS
kernel version 3.8.0 - 29-generic

                New to ADSelfService Plus?