Reporting tools

Hi people

I was wondering if there are any decent reporting tools for RT. Ive tried
statistics3.tgz from the ftp, but it doest quite do what I need. I need to
be able to do reports by owner as well as queues. And perhaps groups too.

thanks

Andrew Xenides
Web Developer
EscapeNet
465 South Road
Keswick SA 5035
T: (08) 8292 5200
F: (08) 8292 5299
E: andrew@staff.esc.net.au
W: http://www.esc.net.au

winmail.dat (1.54 KB)

Hi,

I don’t think there are really any reporting packages out there for RT
that are really going to cover all the bases.

We ended up just writing up some custom scripts (combination of RT API
calls and straight SQL) to export various stats as csv, which is
imported into a commercial stats system (which handles KPI’s and all
that rubbish :slight_smile: ).

Not much help… but that’s how we do it :slight_smile:

Regards,
Matt.From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Andrew
Xenides
Sent: Thursday, April 07, 2005 1:49 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Reporting tools

Hi people

I was wondering if there are any decent reporting tools for RT. Ive
tried statistics3.tgz from the ftp, but it doest quite do what I need. I
need to be able to do reports by owner as well as queues. And perhaps
groups too.

thanks

Andrew Xenides
Web Developer
EscapeNet
465 South Road
Keswick SA 5035
T: (08) 8292 5200
F: (08) 8292 5299
E: andrew@staff.esc.net.au
W: http://www.esc.net.au

<< File: ATT14776630.txt >>

This email and any files transmitted with it are confidential and intended solely for the
use of the individual or entity to whom they are addressed. Please notify the sender
immediately by email if you have received this email by mistake and delete this email
from your system. Please note that any views or opinions presented in this email are solely
those of the author and do not necessarily represent those of the organisation.
Finally, the recipient should check this email and any attachments for the presence of
viruses. The organisation accepts no liability for any damage caused by any virus
transmitted by this email.

Andrew> I was wondering if there are any decent reporting tools for
Andrew> RT. Ive tried statistics3.tgz from the ftp, but it doest quite
Andrew> do what I need. I need to be able to do reports by owner as
Andrew> well as queues. And perhaps groups too.

I’m also looking into a reporting tool, but I’m still fighting with
statistics 0.1.5 and my RT 3.2.2 installation. I can now get the
basic table stats, but it hangs when I try to generate graphs.

The README is pretty skimpy on where it expects to put the generated
images and what permissions you need in there…

John

John Stoffel wrote:

Andrew> I was wondering if there are any decent reporting tools for
Andrew> RT. Ive tried statistics3.tgz from the ftp, but it doest quite
Andrew> do what I need. I need to be able to do reports by owner as
Andrew> well as queues. And perhaps groups too.

I’m also looking into a reporting tool, but I’m still fighting with
statistics 0.1.5 and my RT 3.2.2 installation. I can now get the
basic table stats, but it hangs when I try to generate graphs.

If your are getting problems with the graphs showing as broken images, I
too ran across this. I think a downgrade on GD::Graph may fix this,
although I never went back to check this. Check the date that
statistics was built and get a version of GD::Graph from that time
period to check this out.

DB

Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati

Drew> If your are getting problems with the graphs showing as broken
Drew> images, I too ran across this. I think a downgrade on GD::Graph
Drew> may fix this, although I never went back to check this. Check
Drew> the date that statistics was built and get a version of
Drew> GD::Graph from that time period to check this out.

I’m using version 1.43 of GD::Graph, which one are you using?

perl -e 'use GD::Graph; print "v: $GD::Graph::VERSION\n";'
v: 1.43

From the looks of it, my apache httpd process gets stuck with tons and
tons of:

futex(0x9cfc738, FUTEX_WAIT, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable)
futex(0x9cfc738, FUTEX_WAIT, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable)

Errors. I can kill if off without a problem, but it’s annoying that
it does happen.

I’m running RHEL v3.0 Workstation, perl 5.8.5, apache 2.0.46, mod_perl
1.99_12-2.1 (from a RPM).

Thanks,
John

John Stoffel wrote:

Drew> If your are getting problems with the graphs showing as broken
Drew> images, I too ran across this. I think a downgrade on GD::Graph
Drew> may fix this, although I never went back to check this. Check
Drew> the date that statistics was built and get a version of
Drew> GD::Graph from that time period to check this out.

I’m using version 1.43 of GD::Graph, which one are you using?

perl -e 'use GD::Graph; print “v: $GD::Graph::VERSION\n”;'
v: 1.43

When I was testing this all out, I tried to trace back and find what was
causing the broken images, but gave up as the production deadline
approached and stripped the graphs out. I’ve never really gone back to
investigate if this actually was the problem. The version installed is
1.43, though.

From the looks of it, my apache httpd process gets stuck with tons and
tons of:

futex(0x9cfc738, FUTEX_WAIT, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable)
futex(0x9cfc738, FUTEX_WAIT, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable)

Errors. I can kill if off without a problem, but it’s annoying that
it does happen.

I’m running RHEL v3.0 Workstation, perl 5.8.5, apache 2.0.46, mod_perl
1.99_12-2.1 (from a RPM).

Production: Fedora 2, perl 5.8.3, apache 2.0.51, mod_perl 1.99_12-2.1.
Same setup for my test instance, except with RT 3.2.3 instead of 3.2.2.

DB

Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati

John Stoffel wrote:

Drew> If your are getting problems with the graphs showing as broken
Drew> images, I too ran across this. I think a downgrade on GD::Graph
Drew> may fix this, although I never went back to check this. Check
Drew> the date that statistics was built and get a version of
Drew> GD::Graph from that time period to check this out.

I’m using version 1.43 of GD::Graph, which one are you using?

perl -e 'use GD::Graph; print “v: $GD::Graph::VERSION\n”;'
v: 1.43

I got this to work on my test box using 1.43. The problem now is that I
can’t duplicate that success anywhere else. What I ended up doing was
(many times) removing the GD, GD::Graph, and GD::TextUtil modules and
recompiling them from scratch.

The other thing I found at one point is that there were 2 version of
libgd installed. One was in /usr/lib and the other (which I built by
hand) was in /usr/local/lib. I did at one point remove libgd from
/usr/lib, but I’m pretty sure it still wasn’t working at that point.

I’ll keep fiddling with this for a little while longer.

DB

Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati