CMDB_CI | change request | missing affected CI

[HubisCZ]

Hello all,

Currently I'm struggling with one issue in a CMDB_CI if you go to a related lists there is a table Change requests under which you could find "all" changes related to that CI in which you are. Unfortunately there are not all changes but only those which were in a change request set as a "primal one" if you put another CI's to affected CIs then they won't be shown.

Is there a way to see all changes even those with affected CI's ?

Or is it needed to for example create new related list?

So far I created new related list called "Changes" Applies to table CMDB_CI and Queries from table CMDB_TASK_CHG

Also when I open my custom related list you have to every time filter that one CI in which you already are.

I'm looking for most efficient way so it won't filter more then 30k every time when you open CI

Thank you

[Bhavani Shankar]

Hello @HubisCZ , 

In my case, I had to define a new relationship for [cmdb_ci] with [task_ci] (this contains CIs added in affected CIs list across all task based records)

Here is how I did it

1. All -> System Definition -> Relationships, and Create new

2. Fill the required fields as below

         Name: <Relationship name>

         Applies to table: Configuration item[cmdb_ci]

         Queries from table: CIs affected[task_ci]

Script: 

Add these two lines below comments

current.addQuery("ci_item", parent.sys_id);
current.addEncodedQuery("task.numberSTARTSWITHCHG");    //Incase only change requests are required

3. Submit the record.

4. Finally, from the CI record, configure related lists to include the one you just created.

Hope it helps you or anyone who finds this 😊