Change requests that caused incidents

[_yvind Winther]

Reporting on incidents caused by change is straight forward, but apparently more tricky from the Change request perspective.

I'm trying to setup a report that will show Changes that caused incidents. Browsing around has not helped so far. Anyone successfully managed to create a report like that using the standard reporting module?

[runemehlum]

It depends on how you define “caused by change”. The easy way would be to link the causing change on the incident form by using the caused by change field (on incident) and then report on that field from incidents.

[Christian_]

An alternative is that you, as mentioned above, use the Incident table and the field "Caused by Change".
Within the Report on the incident table you have access to all the fields on the related Change, and therefor show them in your report.
Option then is to group by the "Caused by Change field" for an better overview.

Another option if you absolutely must use the Change table, could be to write a Script Include that returns all the Changes that have contributed to an Incident.
You can read more regadring the concept here.