I am trying to run an audit trail on all of my companies historical jiras by making a table via sql server. I was wondering there was a table in the jira database that tracks how many time each jira has been reopened and the date a jira was reopened. I can find the a change of status to reopen in CHANGEITEM, but can't find an associated date to each reopen time. Any help or tips would be great. Thanks!
I can't speak for JEP, but if you need to do this with SQL, then you should join Changeitem to Changegroup.
Each changeitem line records "field X changed from Y to Z" (and you've found the status changes). If you look at changeitem, it's also got a "group id" field. Use that to read the id in changegroup and you'll find changegroup records the person who made the change, the issue ID and the date/time they did it.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
This September 6-7, hundreds of Atlassian App developers will flock to Barcelona Spain to build skills, discover product roadmaps, meet face-to-face with the Atlassian team, and learn how to extend t...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs