Report for finding all change requests with related incidents

Hi

Is it possible that there is a report feature that can return to us all the change requests with related incidents? I've been trying with powershell but have been getting strange results. If an incident is linked to a change request on the incident form, I can get results that relation and add it to a .csv file, however, if the incident is linked to the change request on the change request form, I can't get any results returned.

Has anyone else been able to use sql or powershell to return related work items?

3 replies