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

[Duncan Shannon]

> 
> 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;
> 

Wicked!

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

Thanks Mike!

Duncan