Request to Generate Total Time Spend After Due By Time?

Request to Generate Total Time Spend After Due By Time?

Dear All,

I would like to Generate a SQL Report which will demonstrate below Columns :

Our current built of the Application 14720 and we are using SQL server as a Database.

a) Request ID
b) Created Time
c) Requester
d) Subject
e) Request Status
f) Group
g) Technician
h) Due By Time
i) Resolved Time
j) Total Time Elapsed
k) Total Time Elapsed After Due Time in Hrs (Excluding Non-Operational Hours)
l) Total Time Elapsed After Due Time in Hrs (Including Non-Operational Hours)

Regards,
Wajahath Farooq

                  New to ADSelfService Plus?