nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to audit trail a jira ticket?

Tony Pearce_u6iaqr

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?

Accepted answers

All comments

Rachel Wright

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

Tony Pearce_u6iaqr

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 != ''...

Tony Pearce_u6iaqr

The LINE 2: error is pointing to the first " in the line at: "[IP]-%

Rachel Wright

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

Andrew Laden

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

Tony Pearce_u6iaqr

Thank you Andrew but not looking for any more 3rd party plugins.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server