Statistics - Done!

RT Users
1

I’ve knocked a statistics page together:

http://peabody.itd.uts.edu.au/rt2stats/

Comments would be appreciated. Notice that the data you can see at the
above URL is test data, and is not representative of our RT installation.

If anyone is interested, I’ll put the source up. It’s a standalone perl
script, which interfaces directly with DBI databases. it should be
extremely portable, as there isn’t any fancy tricks in it.

Also, how do I put a regular.cgi into the rt virtualhost ?

T�o de Hesselle, | Kites rise highest against
Unix Systems Administrator | the wind – not with it.
|
University of Technology, Sydney | – Winston Churchill

2

I’ve knocked a statistics page together:

http://peabody.itd.uts.edu.au/rt2stats/

Comments would be appreciated. Notice that the data you can see at the
above URL is test data, and is not representative of our RT installation.
Just the sort of thing that people are looking for methinks.
Put up the source though, I’m kinda in the mood for playing with gd.
The way to middle-management’s heart is through his pie-charts.

If anyone is interested, I’ll put the source up. It’s a standalone perl
script, which interfaces directly with DBI databases. it should be
extremely portable, as there isn’t any fancy tricks in it.
Does it physically generate a file for each day?
If so, at least name the month directories by monthname - all
those numbers will only confuse the suits.

Also, how do I put a regular.cgi into the rt virtualhost ?
The same way you put it into your main server - VirtualHost Directive take most of the normal directives.

–
T�o de Hesselle, | Kites rise highest against
Unix Systems Administrator | the wind – not with it.
|
University of Technology, Sydney | – Winston Churchill

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Feargal Reilly,
Systems Administrator,
The CIA.

3

Also, how do I put a regular.cgi into the rt virtualhost ?

When I started playing with something like this, I did it this way:

ScriptAlias /stats /usr/local/rt2/stats
<Directory /usr/local/rt2/stats>
SetHandler cgi-script

And yes, can you put the src up please ?

Thanks,

Simon.

4

Comments would be appreciated

Its very nice and a great breakdown, the only thing I would say that
could be a useful extra is to have a breakdown on a per queue as well as
per user … something configurable would be cool idea (via a web form,
with dropdowns or something, ie show me a breakdown of all tickets in
queue blah between dates x and y or something ?)

Simon.

5

Yes this would be great if you put the src online

Regards,
Steve Poirier
Directeur d�veloppement / Projet Manager
Inet Technologies Inc.----- Original Message -----
From: “Teo de Hesselle” teo.dehesselle@uts.edu.au
To: rt-users@lists.fsck.com
Sent: August 13, 2001 01:37
Subject: [rt-users] Statistics - Done!

I’ve knocked a statistics page together:

http://peabody.itd.uts.edu.au/rt2stats/

Comments would be appreciated. Notice that the data you can see at the
above URL is test data, and is not representative of our RT installation.

If anyone is interested, I’ll put the source up. It’s a standalone perl
script, which interfaces directly with DBI databases. it should be
extremely portable, as there isn’t any fancy tricks in it.

Also, how do I put a regular.cgi into the rt virtualhost ?

–
T�o de Hesselle, | Kites rise highest against
Unix Systems Administrator | the wind – not with it.
|
University of Technology, Sydney | – Winston Churchill

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

6

Teo de Hesselle wrote:

I’ve knocked a statistics page together:

    http://peabody.itd.uts.edu.au/rt2stats/

Well… This is very rough, but here is the source:

    http://peabody.itd.uts.edu.au/rt2stats/dist/

There is no documentation. It’s a perl script, which you will have to edit
to include your own database name, etc.

This adds a bit of functionality since my first posting:

  • Everything except ‘Resolvers’ can be filtered per queue.
  • History directories are now like: $queuename/2001/08-Aug/16.html

I will happily add any contributed stuff in, providing that I think it
would be useful.

My immediate plans for extension:

  • Filter ‘Repsonders’ per queue
  • $N Tickets received in the last (2,7,30) days.
  • Make the queue selection dynamic (it’s currently hardcoded html!)

I hope you all find it useful.

T�o de Hesselle, | Kites rise highest against
Unix Systems Administrator | the wind – not with it.
|
University of Technology, Sydney | – Winston Churchill