SQL to count number of issues moved from one project to another

[John Dean]

Hello all,

I need to count how many tickets have been moved from one project to another per month.

Does anyone have any SQL that might do this?

I have my own JIRA instance running against MySQL.

Thanks,

John

[Jobin Kuruvilla [Adaptavist]]

You will have to traverse the ChangeItem table and find out the changes where field is project. It has all the other info like oldvalue, newvalue etc. The time I guess is in ChangeGroup table but you can get it by a simple JOIN.