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: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > _______________________________________________ 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
