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 _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com