How to copy Impacted CI from Problem to Affected CI of Problem Task

[Elena7]

Hello,

Wa recentely started to use a Problem module. I have a question: how to copy the Impacted CI's field from the Problem form to an Affected CI's field of the Problem Task' form. I also want to have a condition, if Impacted CI's field changes in the Problem, so the value in the Affected CI's field in Problem Task changes too.

The fields 'Impacted CI' and 'Affected CI' have different types. So I wanted to know what is the best way to do it?

 The Impacted CI's field on the Problem form:

The affected CI's field on the Problem Task's form:

Thank you in advance for your answers,

Elena

[AndersBGS]

Hi @Elena7 ,

This should be possible through a business rule and a script to do an automatic update.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Elena7]

Hello @AndersBGS ,

Thank you for your answer. Do you have an example of a Business rule. As the fields 'Impacted CI' and 'Affected CI' have different types, I don't know how to do it.

Thank you in advance,

Elena 

[AndersBGS]

Hi @Elena7 ,

I can see that many scripts has been provided, did you make it work or do you need any additional information?

f my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[p_n]

Hello @Elena7 
The affected CIs table is task_ci. You have to create a business rule on the problem record with the after-update condition Impacted CI changes. GlideRecord problem task table with problem and then problem task table with task_ci tables. Update the task CI configuration item field with the problems impacted CI field. Refer to below script.

var problemTask = new GlideRecord('problem_task');
	problemTask.addQuery('problem', current.sys_id);
	problemTask.query();
	while(problemTask.next()){
		var taskCI = new GlideRecord('task_ci');
        taskCI.addQuery('task', problemTask.sys_id );
		taskCI.query();
		while(taskCI.next()){
			taskCI.ci_item = current.u_impacted_cis; // impacted ci field
			taskCI.update();
		}	
	}

Mark my answer correct and Helpful if this helps you
Thank you!!