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