#/bin/bash

# Truncate CallBoard PRO table cb2queuehistoryentry
# and insert blank new queue statistic entry as startdate for new calculated statistics
# 
# CallBoard will re-calculate queue statistics from this startdate every 15 minutes 
PGPASSWORD=asterisk psql -U asterisk -c "TRUNCATE table cb2queuehistoryentry; INSERT INTO cb2queuehistoryentry (id, starttime, queueid, callcount, summedwaitduration, summedabortedwaitduration, summedsucceededwaitduration, summedcallduration, interncount, failedcount, sla10count, sla20count, sla30count, sla40count, sla50count, sla60count) VALUES ('49eb3d64-f74b-44e3-a54c-8297153e00d6', '2022-01-01 00:15:00', '0001', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);" asterisk

service callboard restart