Staff Member stats: Wats the current status? - Kayako

Joomlashack · **Staff Member stats: Wats the current status? -** 27-06-2007, 04:26 PM

I am trying to get the following stats on individual staff members

# tickets dealt with
Average response time
Time worked

I have read the forums and see lots of old posts of this, and comments about scripts being added to the CVS.

Does any script from a 3rd party dev exist currently?

eiden · 27-06-2007, 08:53 PM

This SQL gives you the number of tickets your staff members have worked on:

Code:

SELECT swstaff.fullname, 
(SELECT COUNT(DISTINCT swticketposts.ticketid) FROM swticketposts where swticketposts.staffid = swstaff.staffid) as tickets
FROM swstaff
ORDER BY tickets DESC

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Joomlashack Offline New Member Posts: 1 Join Date: Jun 2007	Staff Member stats: Wats the current status? - 27-06-2007, 04:26 PM I am trying to get the following stats on individual staff members # tickets dealt with Average response time Time worked I have read the forums and see lots of old posts of this, and comments about scripts being added to the CVS. Does any script from a 3rd party dev exist currently?

eiden Offline Member Posts: 211 Join Date: Apr 2006 Location: Norway	27-06-2007, 08:53 PM This SQL gives you the number of tickets your staff members have worked on: Code: SELECT swstaff.fullname, (SELECT COUNT(DISTINCT swticketposts.ticketid) FROM swticketposts where swticketposts.staffid = swstaff.staffid) as tickets FROM swstaff ORDER BY tickets DESC