How can we report on issues that moved between issue types?

[Rumceisz]

Hi Everyone,

our customers need a report on raised issues that originally created as Question issue types and later moved to Incident. Is it possible to get this result?

Thanks,
Rumi

[somethingblue]

Hi Rumceisz,

You can query the database for this information using the following SQL statement:

select * from changeitem where field = 'issuetype';

You can then export your results to excel or whatever output your database tools will output to.

Cheers,

Branden