Tracking of manually moved SR from Incident project

[chandni]

We have JSD setup  mainly for incident,SR and CR project. Sometimes, end users raise an issue in different project due to lack of knowledge about the respective application.

For example, user raise an issue in incident but it actually is an issue of SR project. So the query is that how to track those incident which has been manually moved in SR project by technician later on.  Requirement is to pull this report at the end of the month from JIRA. Please guide us for  what possible ways are there to achieve this. 

Thanks and Regards,

Chandni Patel

[mogavenasan]

Hi @chandni,

If you have JQL Tricks Plugin installed on your Jira instance, then you can use JQL:

issue in movedIssues()

There are a few different apps on the Atlassian Marketplace that help you with this.

If paying/installing third-party apps is not an option for you - you can also query this information directly from the Jira database:

SELECT j.* FROM jiraissue j, changegroup g, changeitem i
where j.id = g.issueid
and g.id = i.groupid
and i.field = 'Project'
and i.oldstring = '<previous project name>'
and i.newstring = '<new project name>';

Thanks,
Moga