Daily Stats - different versions (per user / per tech)?

RT Users
1

Hi All-

This daily stats script is great script.

http://wiki.bestpractical.com/index.cgi?DailyStat

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
owner?

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?

Thanks
duncan

2

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;

Works on RT 3.4.4, FCore4, mysql 4.1.11

Mike-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Duncan
Shannon
Sent: Friday, February 10, 2006 11:51 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Daily Stats - different versions (per user / per
tech) ?

Hi All-

This daily stats script is great script.

http://wiki.bestpractical.com/index.cgi?DailyStat

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
owner?

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?

Thanks
duncan

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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
http://rtbook.bestpractical.com

WE’RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
San Francisco - Find out more at
http://bestpractical.com/services/training.html

3

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