Question about creating a report

Hello again,

Everyone here has been a great help so far, so I was hoping that maybe
someone could tell me how I might go about generating a specific report on
my RT system :slight_smile:

I would like to create a report that would tell me which users are
generating the most tickets in my system.

Broken down something like


User num_tickets issues Status
User1 total_tickets Issue rejected
Issue resolved
Issue resolved
Issue open
------- ------------------ ----------- ------------
User2 total_tickets Issue resolved
Issue stalled
Issue open
------- ------------------ ----------- ------------

I am assuming that this will require me to do an mySQL Query of some sort
over multiple tables, however being the newbie that I am with all of this, I
am not sure whether I can do this directly in the RT interface somehow or if
I will need to do it from the cli for RT?

Hereโ€™s to hoping someone can point me in the right direction,

Greg Evans
Hood Canal Communications
(360) 898-2481 ext.212