Cmdb server auto changing status to Retired and Non Operational

[AbidSiddiqui]

I have catalog item and we have one MRVS on that , in which we are adding the server's in MRVS , 

It has multiple task , last task is assigning to my team and we are checking the variable in MRVS "Server or DB Name" and searching the same with Name in server table (cmdb_ci) and updating the fields status like,
operational to Non operational ,
Install Status to Retired and
Updating ritm no in one fields - Requested Item Number.

Now i am doing automation of this , so that when we receive request it will check the MRVS "Server or DB Name" matches with "Name" in server table (cmdb_ci) and if matches these values should be updated/filled.

So Folks , what is the best way of doing this, Please share some insights.

Thank You

 

[palanikumar]

Hi @AbidSiddiqui ,

You can handle this in Flow. For each row in MRVS, lookup CI record that matches the name and then you can update the record using update record action.

You can refer the below article if you are not sure how to handle MRVS from the flow designer

https://www.servicenow.com/community/workflow-automation-articles/how-to-use-multirow-variable-sets-...

[AbidSiddiqui]

Hi @palanikumar 

Thanks for the reply , I have read the article ,
Actually in my scenario, I am doing one validation check also ,
- Name (cmdb_ci) should match with Variable "Server or DB Name" in variable set , 

For that i have added one lookup record first -

Later i am using update record -

But this is not working , Any idea if i am missing something.

Thank You