I have 2 x projects in JIRA. One with key IP and one with key CIS.
In the IP project, I opened the epic and clicked the + to "raise issue within epic". This raised an ticket in the IP project with number IP-123
Later the same day, I navigate to the ticket from within the epic and it takes me to ticket number CIS-999 which was unexpected. CIS-999 is the ticket I raised but it looks like someone has moved it to CIS project, hence the CIS-999 ticket number now and not IP-123
I checked the ticket history and it has bad / incorrect audit trail information. The very first line says that "I created CIS-999 3 hours ago" which is incorrect. Additionally, there is no log of the ticket being moved.
How can I obtain the correct audit log?
How can I find out who moved the ticket and when?
Why is the ticket history log incorrect?
If you have audit requirements, you may want to look at Auditor for Jira. It will track things like issue moves and such.
https://marketplace.atlassian.com/apps/43203/auditor-for-jira?hosting=server&tab=overview
Thank you Andrew but not looking for any more 3rd party plugins.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Tony Pearce , I can share a little bit of info on this topic. Yes, it does sound like someone moved your issue and from now on, any attempts to visit the original ID (IP-123) will automatically redirect you to the new ID (CIS-999).
Scroll down to the bottom of CIS-999 and click the "All" tab in the "Activity" section. There you'll see the audit trail that's available for the move.
Here's what the "move" action looks like in Server:
In the screenshot, you can see I moved an issue from the "Help" project to the "Migration" project.
Additionally, since you have Jira Server: The original and new IDs are both stored in the "moved_issue_key" table in the Jira database.
You can see them with a simple query like: SELECT * FROM moved_issue_key
There's also some moved ID info in the "changeitem" table. Here's a sample query you can use to find moved issues in a specific project:
SELECT id, oldstring AS "original id", newstring AS "current id" FROM
changeitem WHERE oldstring LIKE "[PROJECTKEY]-%" AND newstring != ''
Note: Issues that haven't been moved are excluded with a null "newstring" condition.
Hope this helps!
Rachel Wright
Author, Jira Strategy Admin Workbook
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rachel,
When I go to the audit trail you describe, it does not mention about the move. So it appears that the "move" was not done from the jira gui menu to move the ticket the usual way - I really don't know. All I know is that the issue is not where it was created - I'm trying to dig more into this to find out the specifics (or even confirm my error) but have been unable to do both at the moment.
I manually moved the ticket back to IP and I do see this in the audit trail. So at the moment the ticket is like this:
Created in IP project
Then was in CIS project
Now I have manually moved it to IP project. <- this is the only move noted in the ticket history.
I ran SELECT * FROM moved_issue_key and I can see the issue_id listed once and the old_issue_key is that from the CIS project. If this only lists the last issue key then my move may have overwritten it.
I was unable to get the 2nd query working
SELECT id, oldstring AS "original id", newstring AS "current id" FROM
changeitem WHERE oldstring LIKE "[PROJECTKEY]-%" AND newstring != ''
What is PROJECTKEY ? is it current issue key like IP-123 ? or is it just "IP" in this case?
The errors are:
ERROR: column "[IP]-%" does not exist
LINE 2: changeitem WHERE oldstring LIKE "[IP]-%" AND newstring != ''...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The LINE 2: error is pointing to the first " in the line at: "[IP]-%
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Tony Pearce ,
What version of Jira you have?
Someone could be moving the issue through the REST API or maybe through an app? I assumed the displayed audit information would be the same regardless of the method, but I guess that isn't the case for your example.
For the sample query, remove the brackets and simply use the project key.
Like this: WHERE oldstring LIKE "IP-%"
I'm no DBA though. I'm sure you or the database admin at your company can improve on this query.
Rachel Wright
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Rachel but still no go on it
ERROR: column "IP-%" does not exist
LINE 1: ..."current id" FROM changeitem WHERE oldstring LIKE "IP-%" AND...
> Someone could be moving the issue through the REST API or maybe through an app? I assumed the displayed audit information would be the same regardless of the method, but I guess that isn't the case for your example.
I suggested to support that there was may be another way that the ticket was being moved but support had not been able to help. They were certain I raised the ticket it CIS. I think now because I done the test move back from CIS to IP on the same issue ticket that I may have ruined any "previous ticket number" type log in the db.
thanks all the same. I think I'll just have to monitor it fir now and see if it occurs again.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.