[rt-users] Re: [rt-devel] Statistics for Users in Queues

[Ruslan U. Zakirov]

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
>