Last year I picked up a usefull report from this forum that showed me the number resolved tickets per support group and technician within 4 hours, 8 hours 24 hours, 96 hours, 1 week, 2, weeks and 4 week.

Now we have migrated to PostgreSQL the report is not working anymore. Would it be possible to create this report for me in PostgreSQL?

Apart from this report I also would like to receive the same report but than with the number of tickets solved with the same interval but without statuses for which the SLA counter is not running (eg. waiting for customer)

Many thanks,

Joost.