Statistics for Users in Queues

RT Developers
1

Has anyone added or modified the statistics web pages or created their
own web page script to get statistics for users? Like how many tickets
userA resolved/closed today/yesterday/last month… ticket resolution
comparison of users in a queue, average time a user has a ticket
open… etc

Thanks,
Michael Brown
InterCept
Systems Administrator
770.248.9600 x4856

2

Awesome… can’t wait to test this out

MichaelFrom: Ruslan U. Zakirov [mailto:cubic@acronis.ru]
Posted At: Wednesday, September 03, 2003 11:17 AM
Posted To: RT
Conversation: [rt-devel] Statistics for Users in Queues
Subject: Re: [rt-devel] Statistics for Users in Queues

Daily Report generator, It’s not ready for contribution yet I have no
time. I’m going to do packet on Saturday.
Major features:
Supported reports: current open tickets in any queue, today resolved
tickets in any queue
Different queues behavior (support requests, task list, bugz)
Could send reports by email to specified address
Writed as library and could be used from RT WebUI and CL perl scripts
Have CLScript that generate and send DRs for users who enabled
autogeneration
Have WebUI to view, change, send own DR and allow switch on/off
autogeneration
Misfeatures:
Cofiguration now splited for WebUI and CLScript.
Use native SQL, because of SearchBuilder bad documentation.
Hardcoded reports.
Couldn’t view another user’s DRs.
Other…
TODO:
Public release
Move configuration in RT_SiteConfig.pm
WebUI for Boss to look at workers activity
More flexible way to configure report content
Use RT API instead of SQL
Sat-Sun better handling.
More content layouts support.
RT wrote:

Has anyone added or modified the statistics web pages or created their

own web page script to get statistics for users? Like how many tickets

userA resolved/closed today/yesterday/last month… ticket resolution
comparison of users in a queue, average time a user has a ticket
open… etc

Thanks,

Michael Brown

InterCept

Systems Administrator

770.248.9600 x4856

3

Daily Report generator, It’s not ready for contribution yet I have no
time. I’m going to do packet on Saturday.
Major features:
Supported reports: current open tickets in any queue, today resolved
tickets in any queue
Different queues behavior (support requests, task list, bugz)
Could send reports by email to specified address
Writed as library and could be used from RT WebUI and CL perl scripts
Have CLScript that generate and send DRs for users who enabled
autogeneration
Have WebUI to view, change, send own DR and allow switch on/off
autogeneration
Misfeatures:
Cofiguration now splited for WebUI and CLScript.
Use native SQL, because of SearchBuilder bad documentation.
Hardcoded reports.
Couldn’t view another user’s DRs.
Other…
TODO:
Public release
Move configuration in RT_SiteConfig.pm
WebUI for Boss to look at workers activity
More flexible way to configure report content
Use RT API instead of SQL
Sat-Sun better handling.
More content layouts support.
RT wrote: