question Updating Stale CIs using Worflow in CMDB forum

Updating Stale CIs using Worflow

Miguel Ferro — Mon, 04 Nov 2024 16:36:46 GMT

Hello Guys,

I need updated a lot of stale CIs. For to do it, I created the workflow below but is nor working.

Do you have any idea where the error is?

Step1:

Step2:

Step3:

Can you help me please ?

Re: Updating Stale CIs using Worflow

Community Alums — Mon, 04 Nov 2024 16:39:11 GMT

Did you tried to troubleshoot that in which step the flow is breaking?

Re: Updating Stale CIs using Worflow

Miguel Ferro — Mon, 04 Nov 2024 16:41:51 GMT

Yes.
Show me this error. But I don´t know what I need to do or how fix it.

Re: Updating Stale CIs using Worflow

Community Alums — Mon, 04 Nov 2024 16:50:56 GMT

Your first lookup record action is referring to CMDB Health Result(guessing it as the images are quite blurry).

Are you referring the Health Result record's sysid in the 2nd step? If yes, then it wont find any record.

If there is any field on CMDB health result table which refers to cmdb_ci table then you can use that field to dot walk its sysid

Re: Updating Stale CIs using Worflow

Miguel Ferro — Mon, 04 Nov 2024 17:22:15 GMT

Thanks for your answer.
I changed the information for the name in the step 2 and now is running.

But the workflow updates just one CI and I need update all.

Step1:

Step2:

Step3:

What I need to do for update one or more CIs found ?

Re: Updating Stale CIs using Worflow

Community Alums — Tue, 05 Nov 2024 15:51:03 GMT

That is because you are using "Look up record" which will only get 1 record.
You need to use "Look Up Records" action and same way to update multiple records you need to use "Update Multiple Records" action.

@Miguel Ferro if this helps, please mark the answer correct so others can also refer to the solution

Thanks
Deepak