Customized Report

Customized Report

Could some one kindly help in providing a query to generate a report containing the following fields:

Request ID
Subject
Description
Resolution
Time of first assignment to a technician
Time of first reply by the technician
First reply sent by the technician
From date x to date y


The DB is PGSQL and the build is  9.0    Build    9035

                  New to ADSelfService Plus?