[rt-users] How to do a report for tickets that were reopened and closed numerous times?

Benjamin Weser weser at osp-dd.de
Mon Jan 28 09:02:53 EST 2008

Have a look at the field NewValue  in table Transactions. There you can
count how many times a ticket (ObjectId = TicketId) was opened and resolved.

Mark Grob wrote:
> I am working on building a report in a separate reporting tool (SQL  
> based). How can I look up how many times a ticket has been closed an  
> reopened? Any suggestions?
> I want to see which of my Tech support reps are auto resolving an  
> issue and then it is getting reopened because the issue was not really  
> resolved.
> -Mark Grob
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com

More information about the rt-users mailing list