Here’s a modification of the SQL query to give a current count of new
and open tickets for each Owner:
FROM (SELECT Owner, Status, COUNT(Owner) AS count
WHERE Status = ‘new’ OR Status = 'open’
GROUP BY Owner, Status) AS t
LEFT JOIN Users u ON t.owner = u.id
ORDER BY u.realname, t.Status;
Works on RT 3.4.4, FCore4, mysql 4.1.11
[mailto:firstname.lastname@example.org] On Behalf Of Duncan
Sent: Friday, February 10, 2006 11:51 AM
Subject: [rt-users] Daily Stats - different versions (per user / per
This daily stats script is great script.
I have it setup, and it worked beautifully with RT 3.4.4.
Has anyone modified this at all to make different but similar reports?
Eg - a report of # of new and # of open (and then totals) tickets per
I wish my sql was better, but I tried to hack thru the query that was
there a bit, and I was afraid I’d break something.
Anyone do this already or have some suggestions?
Be sure to check out the RT Wiki at http://wiki.bestpractical.com
Download a free sample chapter of RT Essentials from O’Reilly Media at
WE’RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
San Francisco - Find out more at