Related list / change requests for additional CI's

[HubisCZ]

Hello all,

Currently if change is created then in CMDB in related list you find out "change request" and Change number

but only if "CMDB_CI" was selected but if you create change with multiple CI's in affected CI's it does not appear in CMDB / related list / Change requests.

is there some way to have this information in Change requests or Should i create new related list?

[Karthiga S · Accepted solution]

Hi @HubisCZ 

This seems to be a configuration Issue. Please follow the below steps

1. Navigate to the Configuration Item (CI) record in the CMDB.
2. Check the Related Lists section at the bottom of the CI record.
3. If the "Change Requests" related list is not visible, you may need to personalize the form to add it.
4. To do this, click on the hamburger icon (three horizontal lines) in the top left corner of the form and select "Configure > Related Lists".
5. In the slushbucket that appears, move "Change Requests" from the "Available" list to the "Selected" list and click "Save".
6. Now, the "Change Requests" related list should be visible in the CI record.
7. If the related list is already there but the changes are not appearing, it could be due to the Affected CIs not being correctly associated with the Change Request.
8. To resolve this, navigate to the Change Request and ensure that the CIs are added to the "Affected CIs" related list.
9. If they are not, add them manually by clicking on "Edit" in the related list and selecting the appropriate CIs.
10. Once the CIs are added, they should appear in the "Change Requests" related list in the CI record.

Please mark it Correct and Hit Like if you find this helpful!

Regards,

Karthiga

[Karthiga S · Accepted solution]

Hi @HubisCZ 

This seems to be a configuration Issue. Please follow the below steps

1. Navigate to the Configuration Item (CI) record in the CMDB.
2. Check the Related Lists section at the bottom of the CI record.
3. If the "Change Requests" related list is not visible, you may need to personalize the form to add it.
4. To do this, click on the hamburger icon (three horizontal lines) in the top left corner of the form and select "Configure > Related Lists".
5. In the slushbucket that appears, move "Change Requests" from the "Available" list to the "Selected" list and click "Save".
6. Now, the "Change Requests" related list should be visible in the CI record.
7. If the related list is already there but the changes are not appearing, it could be due to the Affected CIs not being correctly associated with the Change Request.
8. To resolve this, navigate to the Change Request and ensure that the CIs are added to the "Affected CIs" related list.
9. If they are not, add them manually by clicking on "Edit" in the related list and selecting the appropriate CIs.
10. Once the CIs are added, they should appear in the "Change Requests" related list in the CI record.

Please mark it Correct and Hit Like if you find this helpful!

Regards,

Karthiga

[HubisCZ]

Hello Karthiga,

The the whole thing about this "issue" is following. Currently in CMDB in related list for example for one CI there are 89 changes. So i created new relationship which applies to table: CMDB_CI and Queries from table Task_CI
But it is showing completely different information in "Change request" it show you Number, Short description, State, etc etc. But in my related list "Changes" it show you Config item, Class, Task. Yeah you could filter out that on CI and also in task you could filter out "CHG" but then for info you need to open every single change. And I would like to have this information visible right from CMDB_CI table.

[Karthiga S · Accepted solution]

Hello @HubisCZ 

To achieve this, you can create a new related list in the CMDB_CI table that shows the desired fields from the Change Request table. Here are the steps:

1. Navigate to the form view of any CI record in the CMDB_CI table.
2. Right-click on the header of any existing related list and select "Configure Related Lists".
3. Click on "New" to create a new related list.
4. In the "Table" field, select "Change Request [change_request]".
5. In the "Use Related List" field, select "Task CI [task_ci]".
6. In the "Fields to display" section, add the fields you want to display in the related list. For example, you can add "Number", "Short description", "State", etc.
7. Click on "Submit" to save the new related list.

Now, when you navigate to the form view of any CI record in the CMDB_CI table, you should see the new related list with the desired fields from the Change Request table.

Please note that the fields available in the related list depend on the relationship between the CMDB_CI and Change Request tables. If there is no direct relationship between these tables, you may need to create a new relationship or modify an existing one to include the desired fields.

Please mark it Correct and Hit Like if you find this helpful!

Regards,

Karthiga

[HubisCZ]

Hello Karthiga,

So i did following. I created new related list called "changes" this related list Applies to table "cmdb_ci" and queries from "task_ci" also following "querry with" was added:

"

(function refineQuery(current, parent) {

current.addEncodedQuery('task.numberSTARTSWITHchg');

//current.addEncodedQuery('ci_item.nameSTARTSWITHkfdcql47^task.numberSTARTSWITHchg');

//current.addEncodedQuery('ci_item.nameSTARTSWITH' + + '^task.numberSTARTSWITHchg');

})(current, parent);

"

So with this I reduce amount of findings from 600k + to "only" 38k. That's so far good but still you have to put a filter and filter out only that one CI. Is it possible that it will automatically filter only those CI's (which you already opened)

Also there is one more thing as this related list is taking information from "task_ci" therefore you are not able to add into personalize list columns like: Short description (of that change), State, Schedule start/end. etc etc.

Is that even possible to add following?

Thank you