Report on Affected CI table & Change Request

[Naveen87]

Hello Developers,

On a CHG record, We have a related list call Affected CI.

I'm creating a report on task_ci table to show the CHG record where these Affected CI are mentioned.

I have 1000's of CI for which report needs to be fetched. I don't want to add 1000's OR conditions.

Is there a way/condition which is written on Parent of CI & all downstream CI's are shown?

Ex:- 

SW_License_Key_PRD is a Parent CI(cmdb_ci_appl). It has 22 downstream CI.

Weblogic instance_SW_License_Key_PRD_fieslgp02_wl-clics-clics-2 is 1 of them.

On CHG0325591, Weblogic instance_SW_License_Key_PRD_fieslgp02_wl-clics-clics-2 is affected CI. 

I don't wish to add rest 21 CI in the report condition to fetch it.

I wish to add the Parent "SW_License_Key_PRD is a Parent CI(cmdb_ci_appl)" which will show all CHG's where 22 downstream/child CI's are used

Please suggest a way out.

[Naveen87]

Here is the new Database.

Not sure, Something is wrong.

[Mark Manders]

I am missing the relation between the tables (the 'where clause' is empty) or is that just not in your screenshot?