History Tab query report

History Tab query report

Need a query to pull the following for all tickets:

Request ID

Requester

Category

Urgency

Priority

Created Time

DueBy Time

Request Status

Completed Time

Technician

All entries on history tab

On-prem version 14.0 Build 14006. PGSQL being used.

Anyone have a working query for this?

Thank you.

                  New to ADSelfService Plus?