[rt-users] Question about creating a report

Greg Evans gevans at hcc.net
Fri Mar 7 12:56:53 EST 2008


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 :)

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 




More information about the rt-users mailing list