Same idea applies, its quite simple, make your own SQL query and you run the query on all tickets, matching results will be sent in email to you at your specified time.Something like this, given you you ost_ default prefix for the db:SELECT ost_ticket.number AS "Ticket Number", ost_user.name AS "Created By", ost_department.name AS "Assigned Department", ost_ticket.created AS "Ticket Created", ost_ticket.est_duedate AS "Estimated duedate", ost_ticket.lastupdate AS "Last Ticket Update", ost_sla.name as "SLA" FROM ost_ticket, ost_user, ost_department, ost_sla WHERE ost_ticket.user_id=ost_user.id AND ost_ticket.dept_id=ost_department.id AND ost_ticket.sla_id=ost_sla.id AND ost_ticket.status_id=1 AND ost_ticket.staff_id=0;It would show up something like this:+---------------+----------------+---------------------+---------------------+---------------------+---------------------+--------------+| Ticket Number | Created By | Assigned Department | Ticket Created | Estimated duedate | Last Ticket Update | SLA |+---------------+----------------+---------------------+---------------------+---------------------+---------------------+--------------+You can control what you want to see by changing status_id and staff_id, status_id=0 is open, staff_id=0 means no staff has been assigned.You can even create separate query, to show only out of SLA:SELECT ost_ticket.number AS "Ticket Number", ost_user.name AS "Created By", ost_department.name AS "Assigned Department", ost_ticket.created AS "Ticket Created", ost_ticket.est_duedate AS "Estimated duedate", ost_ticket.lastupdate AS "Last Ticket Update", ost_sla.name as "SLA" FROM ost_ticket, ost_user, ost_department, ost_sla WHERE ost_ticket.user_id=ost_user.id AND ost_ticket.dept_id=ost_department.id AND ost_ticket.sla_id=ost_sla.id AND ost_ticket.status_id=1 AND ost_ticket.staff_id=0 AND ost_ticket.isoverdue=1;After this you can easily insert this into a shell script .sh, something like this:#!/bin/bash#Some variablesYOURDB=ost_ticket_database_you_gotYOUREMAIL =yours@only.comechoechoecho "##############################"echo "# Current unassigned tickets #"echo "##############################"echoechomysql -u root -e 'SELECT ost_ticket.number AS "Ticket Number", ost_user.name AS "Created By", ost_department.name AS "Assigned Department", ost_ticket.created AS "Ticket Created", ost_ticket.est_duedate AS "Estimated duedate", ost_ticket.lastupdate AS "Last Ticket Update", ost_sla.name as "SLA" FROM ost_ticket, ost_user, ost_department, ost_sla WHERE ost_ticket.user_id=ost_user.id AND ost_ticket.dept_id=ost_department.id AND ost_ticket.sla_id=ost_sla.id AND ost_ticket.status_id=1 AND ost_ticket.staff_id=0' $YOURDBechoechoecho "##############################"echo "# Current tickets out of SLA #"echo "##############################"echoechomysql -u root -e 'SELECT ost_ticket.number AS "Ticket Number", ost_user.name AS "Created By", ost_department.name AS "Assigned Department", ost_ticket.created AS "Ticket Created", ost_ticket.est_duedate AS "Estimated duedate", ost_ticket.lastupdate AS "Last Ticket Update", ost_sla.name as "SLA" FROM ost_ticket, ost_user, ost_department, ost_sla WHERE ost_ticket.user_id=ost_user.id AND ost_ticket.dept_id=ost_department.id AND ost_ticket.sla_id=ost_sla.id AND ost_ticket.status_id=1 AND ost_ticket.isoverdue=1' $YOURDB# Lets send this to emailmail -s "Weekly Report" $YOUREMAIL < /tmp/outputYou might want to change it up a little bit, e.g., if you are using a DB password, etc, you might want to make a local user who can do the select for extra security.Then all you have to do is set up a scron script like this:0 6 * * Mon /your/path/to/shellscript.sh > /tmp/outputAs I said, quite simple :)