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

[Mark Grob]

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