[rt-users] Daily Stats - different versions (per user / per tech) ?

Duncan Shannon dshannon at techfluent.com
Fri Feb 10 13:37:35 EST 2006

> Here's a modification of the SQL query to give a current count of new
> and open tickets for each Owner:
> SELECT CONCAT(t.count,',',t.Status,',',u.realname)
> FROM (SELECT Owner, Status, COUNT(Owner) AS count
>       FROM Tickets
>       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;


I added it (and credited 'mike') to the wiki page.

Thanks Mike!


More information about the rt-users mailing list