Every Monday and Friday at 9:00, list all support tickets that aren't solved or closed, grouped by location.
For each ticket, show the title, the member, the assignee, and how many days it has been open. Put unassigned tickets and tickets with no reply in the last 2 days at the top of each location.
Email the summary to [your email address], starting with one line on how many tickets are open and how that compares with the last summary. If no tickets are open, say so in one sentence.