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.
Here is the new Database.
Not sure, Something is wrong.
