Consolidated Overdue Ticket Email with Hyperlink

apyash

I am using osticket in below environment. I want to setup alert of overdue ticket to respective department at every day morning 10 a.m, this alert will have all tickets in single Email with few other fields. This ticket No will have hyperlink so if requires, he can click on individual ticket and see the ticket in ticket agent portal.

Suggest if any existing solution or option we have in osTicket or we can write any script code and merge the same.

Server Information
Ticket Version v1.14.1 (f1e9e88) — Up to date
Web Server Software Apache
MySQL Version 5.5.45
PHP Version 7.2.29

ntozier

Over due alerts are sent at the time when a ticket becomes over due.
There is no way in the UI to schedule a daily reminder email.

You would either have to:

write your own script and run it via cron/task scheduler that sends an email to achieve this.
modify the core files to achieve this