Has anyone created reports from RT queues before?

I sent a message earlier about this but did not get a response.
Basically I need to create a monthly report showing all the tickets I have
worked on so I can present it as proof that I have been doing my job.
This month I ended up just printing each ticket’s history to postscript,
converting to pdf and then creating a cd with html on it that links to
each pdf. There has to be a nicer way to do this. I am not that great
with mysql besides getting it running and some minor admin’n. If I knew
how to send strings to mysql I should just be able to write a script that
could extract the info I need from the mysql database correct? Has anyone
done this? Could someone point me in a good direction to get me coding?
Thanks for your time.

I think that is what the Cozens Statistics Package
does. I have been trying to get it to work, but I
have been having a problem configuring apache to work
properly.

http://www.fsck.com/rtfm/factoid.html?id=183

I sent a message earlier about this but did not get
a response.
Basically I need to create a monthly report showing
all the tickets I have
worked on so I can present it as proof that I have
been doing my job.
This month I ended up just printing each ticket’s
history to postscript,
converting to pdf and then creating a cd with html
on it that links to
each pdf. There has to be a nicer way to do this.
I am not that great
with mysql besides getting it running and some minor
admin’n. If I knew
how to send strings to mysql I should just be able
to write a script that
could extract the info I need from the mysql
database correct? Has anyone
done this? Could someone point me in a good
direction to get me coding?
Thanks for your time.


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

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm

Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com