Report on tickets raised outwith business hours
We are trying to create a report on incidents created in our ServiceDesk over the last year in our out-of-office hours, however the report function requires specific dates and will not search for time ranges only.
We require 3 reports on the number of incidents with a level of "SCOTS", "STEPS", "TELEPHONY" "WEB" created between 01/01/2017 and 31/12/2017 in the following time ranges:
Report 1: Mondays to Thursdays - 00:00 to 08:30 and 17:00 to 23:59
Report 2: Fridays - 00:00 to 08:30 and 16:30 to 23:59
Report 3: Saturdays & Sundays - 00:00 to 23:59
Database PSQL Postgres
9.1 Build 9119
We require 3 reports on the number of incidents with a level of "SCOTS", "STEPS", "TELEPHONY" "WEB" created between 01/01/2017 and 31/12/2017 in the following time ranges:
Report 1: Mondays to Thursdays - 00:00 to 08:30 and 17:00 to 23:59
Report 2: Fridays - 00:00 to 08:30 and 16:30 to 23:59
Report 3: Saturdays & Sundays - 00:00 to 23:59
Database PSQL Postgres
9.1 Build 9119